The Scenario
You're a demand gen manager at a SaaS company running Snapchat lead generation campaigns. It's the end of the month and your head of sales wants to know how many leads came in per form across the Snapchat campaigns — and wants the lead details imported into Salesforce. You have the data sitting in Snapchat Ads Manager but you've never pulled it programmatically before, and the Snapchat Lead Gen center doesn't have a bulk export with all the fields your Salesforce admin needs.
The bad version:
- Open the Snapchat Lead Gen section. Click through each form to see its name and ID. Write those down.
- Navigate to the leads report for each form one at a time. Download or copy the leads count.
- Export each form's individual lead records — name, email, submission date — into separate CSVs.
- Merge the CSVs in Sheets manually, adding a Form Name column to each before combining.
Five lead gen forms. Five separate exports. One manual merge. And you still have to clean the date format before uploading to Salesforce.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside your Google Sheet and can pull lead gen form metadata and lead data from the Snapchat Marketing API in one call.
List all lead generation forms for Snapchat ad account abc123 and write form ID and form name into columns A and B of the Lead Forms tab
What You Get
- One row per lead form
- Column A: form ID (what you need to reference the form in further API calls)
- Column B: form name as it appears in Ads Manager
- Complete list of all forms in the account
What If the Data Is Not Quite Ready
You want lead counts included alongside the form list
List all lead generation forms for Snapchat ad account abc123 with their submission counts for the last 30 days, and write form ID, form name, and lead count into columns A through C of the Lead Summary tab
You want to pull the actual lead records from a specific report run
Fetch the Snapchat leads report for ad account abc123 report run ID rep_456 and write lead name, email, and submission date into columns A through C of the Lead Details tab, formatting dates as YYYY-MM-DD
You want to combine form names with lead records for a unified export
Fetch all lead forms for Snapchat ad account abc123, then for each form fetch the lead records and combine them into a single table with columns: form name, lead name, email, and submission date, all written into the Combined Leads tab starting at row 2
Full lead gen pipeline: pull all forms, pull all leads, flag duplicates, and prep for Salesforce import
Fetch all lead gen forms for Snapchat ad account abc123, pull lead records for each form for the last 30 days, combine into a single table with form name in A, lead name in B, email in C, submission date in D — then check for duplicate emails in column C and write Duplicate in column E for any email that appears more than once, so the Salesforce admin knows which records to skip
One prompt gets you from raw Snapchat data to a Salesforce-ready sheet with duplicates already flagged.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your Snapchat lead data should land, then ask it to pull all lead forms and lead records for the past 30 days. Related: exporting campaign performance stats, and the hub overview for all Snapchat workflows.