The Scenario
Your agency manages Snapchat ad spend for 10 clients. It's the last week of the quarter and your finance team is asking for a transaction reconciliation — every charge against the organization for the past 90 days, with dates, amounts, ad account references, and transaction types. They need it by Friday. The billing data lives in Snapchat's organization transaction history, which you've never exported before.
The bad version:
- Log into Snapchat Business Manager, find the Billing section, navigate to Transaction History.
- Discover the transaction list paginates and you can only see 30 entries at a time.
- Copy the visible records into a spreadsheet. Click Next. Copy. Click Next. Copy — for what turns out to be 11 pages of transactions.
- Format the date column because it's in a format that won't sort correctly in Sheets.
Eleven pages of manual copy-paste is not a finance workflow. It's a time tax.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to the Snapchat Marketing API from inside your Google Sheet. Billing transaction data is accessible through the organization endpoint, and SheetXAI can pull and write all pages in one call.
List all transactions for Snapchat organization ID org_123 from the last 90 days and write transaction date, ad account, amount, and transaction type into columns A through D of the Transaction History tab
What You Get
- One row per transaction, all pages fetched
- Column A: transaction date in YYYY-MM-DD format
- Column B: ad account name or ID
- Column C: amount (in the organization's billing currency)
- Column D: transaction type (Invoice Payment, Auto-Pay, Adjustment, etc.)
- Full 90-day window with no pagination gaps
What If the Data Is Not Quite Ready
You need to filter to a specific ad account only
Fetch Snapchat organization org_123 transactions from the last 90 days where ad account is abc123 and write transaction date, ad account, amount, and type into columns A through D
You want the running balance added as a cumulative column
List all transactions for Snapchat organization org_123 from the last 90 days — date in A, ad account in B, amount in C, type in D — then add a running total in column E that accumulates the amount from row 2 downward
You need to flag credit adjustments separately from charges
Pull 90 days of Snapchat organization org_123 transactions — date in A, ad account in B, amount in C, type in D — then write Credit in column E for any transaction where the amount is negative, and Charge for any positive amount
Full reconciliation: pull transactions, match against client invoices, flag gaps
Fetch the last 90 days of transactions for Snapchat organization org_123 — date in A, ad account in B, amount in C, type in D — then look up each ad account against the Client Mapping tab (column A = ad account, column B = client name) and write the client name into column E, then flag any transaction where no client mapping was found with Unassigned in column F
One prompt builds the reconciliation sheet and surfaces the unmapped accounts at the same time.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet your finance team uses for billing reconciliation, then ask it to pull 90 days of Snapchat organization transactions. Related: reconciling ad account invoices, and the hub overview for all Snapchat workflows.