The Scenario
You're the demand gen manager at a SaaS company. Your head of sales just asked: "how many Snapchat leads did we get last month, and can you get them into Salesforce?" You've been running Snapchat lead gen campaigns for 30 days across 5 forms. You know the data is there. You've never pulled it programmatically and you don't know if the Ads Manager export covers all the fields your Salesforce admin needs.
The bad version:
- Open the Snapchat Lead Gen Manager. Click into each form to find its ID and name. Write those down.
- For each form, navigate to the leads export. Download a separate CSV. Each CSV has slightly different column names.
- Open 5 CSV files. Manually add a Form Name column to each. Combine them in Excel. Normalize the date format. Send the merged file to your Salesforce admin.
Five forms. Five exports. One manual merge. Half a day to produce data that already existed in a structured format somewhere in Snapchat's system.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside your Excel workbook and can pull lead gen form metadata and lead records from the Snapchat Marketing API directly.
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 sheet
What You Get
- One row per lead form
- Column A: form ID (the reference you need for pulling lead records)
- Column B: form name as it appears in Ads Manager
- Complete list of all forms in the account, ready for follow-on queries
What If the Data Is Not Quite Ready
You want submission counts included alongside the form list
List all lead generation forms for Snapchat ad account abc123 with 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 sheet
You need 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 sheet, formatting dates as YYYY-MM-DD
You want all forms and their lead records combined into one table
Fetch all lead forms for Snapchat ad account abc123, then for each form pull the lead records and combine into a single table with form name, lead name, email, and submission date written into the Combined Leads sheet starting at row 2
Full pipeline prep: all forms, all leads, duplicate flag, Salesforce-ready output
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 appearing more than once, so the Salesforce admin knows which records to skip on import
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook 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.