Circle Separator4 mins read

How to Connect Snapchat Ads to Google Sheets

The easiest way to connect Snapchat Ads to Google Sheets is to use a Snapchat Ads connector such as Coupler.io for campaign reporting. It connects to Snapchat Ads through account authorization, lets you choose campaigns, ad squads, ads, metrics and dimensions, and refreshes the results in Google Sheets automatically.

There are 3 practical ways to move Snapchat data into Google Sheets:

  • Use Snapchat's native connection for lead form submissions.
  • Use a connector for campaign performance reporting.
  • Build a custom Snapchat Marketing API and Google Apps Script workflow when you need more control.

If you only need leads from Snapchat Lead Generation Ads, use Snapchat's native Google Sheets connection. For campaign data such as spend, impressions, swipes and conversions, use a connector or build a custom API integration.

Choose the Right Snapchat Ads to Google Sheets Method

Your requirementRecommended methodWhat it connects
Send Snapchat lead form submissions to a spreadsheetSnapchat native Google Sheets connectionLead records from Lead Generation Ads
Import campaign performance automaticallyCoupler.io or another Snapchat Ads connectorCampaign, ad squad, ad and demographic reporting
Build a customised data pipelineSnapchat Marketing API plus Google Apps ScriptCustom metrics, schedules, filters and sheet logic
Combine Snapchat with Google Ads, Meta Ads or other platformsMulti-source connectorCross-channel reporting in one spreadsheet

How to Connect Snapchat Lead Ads Directly to Google Sheets

Snapchat's native Google Sheets integration sends lead form data to a spreadsheet. It is designed for lead records, not general Snapchat Ads performance reporting.

Steps to Connect Snapchat Leads to Google Sheets

  1. Open Snapchat Ads Manager.
  2. Open a native lead generation campaign.
  3. Select the ad and open Creative Details or Form Builder.
  4. Select Connect Form to CRM.
  5. Choose Google Sheets and click Connect.
  6. Sign in to the Google account with edit access to the spreadsheet.
  7. Select the Google Spreadsheet and connect it.
  8. Select Send Test Report to confirm the connection.

The Google account must have edit permission for the spreadsheet. Snapchat also warns that renaming the connected spreadsheet after testing can break the connection and require you to reconnect it.

This method works when the sheet needs to contain:

  • Lead names and contact details
  • Form responses
  • Lead submission information
  • Campaign or ad attribution connected to each lead

Use a different method if you need a complete Snapchat Ads performance dashboard.

How to Import Snapchat Ads Performance Data With a Connector

A connector is the quickest option for campaign reporting. Coupler.io supports campaign performance, ad group performance, ad performance and geo-demographic reports. You can select metrics, dimensions, date ranges and filters before sending the data to Google Sheets.

Steps to Connect Snapchat Ads to Google Sheets With Coupler.io

  1. Create or open the Google Sheet where the data will be stored.
  2. Create separate tabs for raw Snapchat data and reporting calculations.
  3. Open the Snapchat Ads to Google Sheets integration in Coupler.io.
  4. Authorize your Snapchat Ads account.
  5. Select a report type:
    • Campaign performance
    • Ad squad or ad group performance
    • Ad performance
    • Campaign geo-demographic insights
    • Ad group geo-demographic insights
  6. Select the Snapchat Ads account or accounts to import.
  7. Choose the reporting period.
  8. Select the metrics and dimensions you need.
  9. Add filters for campaigns, ad squads, ads, countries, platforms or other available fields.
  10. Connect the Google account.
  11. Select the spreadsheet, destination tab and starting cell.
  12. Choose Replace or Append as the write mode.
  13. Set the refresh schedule.

Coupler.io says Snapchat Ads authorization does not require you to copy an API key manually. The integration supports historical date ranges, source-side filters and scheduled refreshes as often as every 15 minutes, depending on the plan.

Which Snapchat Ads Fields Should You Import?

Import fields that identify the campaign, show when the activity happened and measure the result. A campaign performance sheet will usually include:

  • Date
  • Campaign ID
  • Campaign name
  • Ad squad ID
  • Ad squad name
  • Ad ID
  • Ad name
  • Impressions
  • Reach
  • Swipes
  • Spend
  • Swipe-up rate
  • Video views
  • Purchases or other conversion events
  • Conversion value
  • Country or region
  • Operating system or device type

Snapchat's Ads API supports reporting at the ad account, campaign, ad squad and ad levels. It also supports total, daily and hourly reporting granularities.

Should You Use Replace or Append?

Use Replace when the sheet should show the latest version of a selected reporting range. Use Append when the sheet is a historical log and each scheduled run should add new rows.

A simple workbook structure is:

  • Snapchat_Raw: imported data
  • Campaign_Summary: formulas and pivot tables
  • Dashboard: charts and performance indicators
  • Settings: account IDs, date ranges and filter values

Keep formulas, charts and pivot tables outside the connector's target range. A scheduled import can rewrite the selected data area.

How to Build a Custom Snapchat Ads API and Google Sheets Integration

A custom integration is the right choice when a connector does not provide the fields, data processing or workflow you need.

Snapchat's Ads API uses OAuth 2.0 authentication. API requests include an access token in the Authorization header, and the token reflects the permissions granted to the user or application.

Steps for a Custom Snapchat Ads Reporting Workflow

  1. Create an OAuth app in Snap Business Manager.
  2. Authorize access to the Snapchat Marketing API.
  3. Obtain and securely store access and refresh tokens.
  4. Request campaign, ad squad or ad statistics.
  5. Convert the returned JSON data into rows and columns.
  6. Write the rows to Google Sheets.
  7. Schedule the script to run automatically.
  8. Store a last-run timestamp to avoid duplicate records.

Google Apps Script can call external APIs, write data to a spreadsheet and run on a time-driven trigger. Google's installable triggers support recurring execution intervals, so Apps Script can handle scheduled Snapchat reporting.

Google Sheets also provides an API method for appending values to the next available row in a table.

Custom Workflow Structure

Snapchat Ads API
        ↓
Google Apps Script
        ↓
Data cleaning and field mapping
        ↓
Google Sheets raw data tab
        ↓
Formulas, pivots and dashboards

A custom workflow gives you control over:

  • Custom field selection
  • Account-level access rules
  • Data deduplication
  • Currency conversion
  • Campaign naming rules
  • Historical snapshots
  • Custom alerts
  • Combining Snapchat data with sales or CRM data

The trade-off is maintenance. You must manage OAuth token renewal, API errors, rate limits, schema changes and reporting logic yourself.

For most teams, use a connector for Snapchat Ads performance data and keep the spreadsheet structure simple:

  1. Import daily campaign-level data.
  2. Store it in a dedicated raw-data tab.
  3. Use formulas or pivot tables in separate tabs.
  4. Add a campaign summary with spend, impressions, swipes, conversions and cost per conversion.
  5. Use a dashboard tab for charts and pacing.
  6. Schedule the import instead of downloading CSV files manually.

Use Snapchat's native connection for lead records, a connector for campaign performance and a custom Ads API integration only when you need fields or processing rules that the connector does not support.

Next Read