The Scenario
A re-engagement campaign is going live next week and it's targeting your holiday buyers from 2025. Your CRM exported 50,000 hashed email addresses into a Google Sheet three days ago. The campaign manager needs those emails in a Snapchat audience segment before the creative team finishes the assets — and it turns out nobody has actually done a bulk audience upload to Snapchat before.
The bad version:
- Read Snapchat's developer documentation to find the right audience upload endpoint and the correct SHA-256 hashing format requirement.
- Figure out that the API requires batches of no more than 100,000 records, formatted as a JSON array inside a specific request body schema.
- Export column A as a CSV, write a script to read it, chunk it, and POST it to the API with correct authentication headers.
- Test the script, realize the auth token expired, refresh it, re-run, check the Ads Manager UI to confirm the segment was created and shows the expected approximate user count.
This is a one-time task that shouldn't take a developer two hours. But without the API scaffolding already built, it always does.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside your Google Sheet. It reads the data in your sheet and handles the Snapchat API call — including batching — so you don't need to write a line of code.
Create a Snapchat audience segment called Holiday Buyers 2025 in ad account abc123 and add all SHA-256 hashed emails from column A of the Upload List tab to it, processing in batches of 100,000
What You Get
- A new audience segment created in Ads Manager with the name you specified
- All 50,000 emails uploaded in a single operation, batched automatically
- Confirmation written back to the sheet: segment ID, status, and approximate user count once Snapchat's matching runs
What If the Data Is Not Quite Ready
The emails aren't hashed yet and you need to hash them first
Take all plain-text emails in column A of the Upload List tab, hash each one using SHA-256, write the hashed values into column B, then upload column B to a new Snapchat audience segment called Holiday Buyers 2025 in ad account abc123
You want to add to an existing segment instead of creating a new one
Add the 50,000 SHA-256 hashed emails in column A of the Upload List tab to existing Snapchat segment ID seg_abc123 in ad account abc123, processing in batches of 100,000
You have a column of customer types and only want to upload a specific subset
Filter column A to rows where column B says High Value, then upload those SHA-256 hashed emails to a new Snapchat segment called High Value Reengagement in ad account abc123
Full audience build: hash, upload, and log the result
Take plain-text emails from column A of the Upload List tab, hash them with SHA-256 into column B, create a Snapchat audience segment called Holiday Buyers 2025 in ad account abc123, upload column B to it in batches of 100,000, and write the resulting segment ID and status into cells D1 and D2
Combining the hashing, uploading, and logging into one ask means the sheet is a complete record of what was sent and when.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet containing your hashed customer list, then ask it to create the Snapchat audience segment and upload the emails. Related: auditing your existing audience segments, and the hub overview for all Snapchat workflows.