Google Sheets Integration

How Facebook Leads Become Rows in Your Google Sheet

LeadSync appends each Facebook, Google, LinkedIn, or TikTok lead as a new row in the Google Sheet you select. The first row of your sheet is treated as the header row -- column names there map to the field mapping dropdown in LeadSync, so you decide which lead form question goes in which column. Add columns to your sheet whenever you want to capture more data; LeadSync will pick them up the next time it reads the header.

Setup is a click-through Google OAuth authorisation. LeadSync requests the drive.file scope (the narrowest scope that lets us read your sheets and append rows), and you pick the sheet from a Google Picker that lists your Google Drive spreadsheets. No need to copy-paste sheet IDs or share files manually.

Campaign, Ad Set, and Ad Name Auto-Attribution

Beyond the standard lead form fields, LeadSync supports three special attribution columns: leadsync:campaign_name, leadsync:adset_name, and leadsync:ad_name. Add columns with these exact header names and LeadSync will fetch the campaign, ad set, and ad metadata from Meta's Marketing API for every lead and write them into your sheet -- no extra setup required.

This is gold for paid-social analytics: you can pivot your spreadsheet by campaign, ad set, or creative to see which combinations are producing the highest-converting leads, all without touching Meta Ads Manager. For agencies running multi-campaign tests, this column trio collapses what is normally a multi-tool reporting workflow into a single tab.

ArrayFormula Support and Token Refresh

If your Google Sheet uses ArrayFormula columns (a common pattern for derived columns like full-name concatenation, lead-score calculations, or cell-format normalisation), LeadSync detects them automatically and skips writing to those cells -- so your formulas continue to apply to each new row without being overwritten.

Google OAuth tokens expire every hour but the refresh token persists indefinitely. LeadSync refreshes transparently using the stored refresh token whenever an API call fails -- you authenticate once during setup and the integration keeps running unless you manually revoke LeadSync's access from your Google account.

Frequently Asked Questions

Click Google Sheets in the LeadSync destination list and authorise the Google OAuth connection. LeadSync requests the drive.file scope (the narrowest one that allows sheet reads and row appends), then you pick the destination spreadsheet from a Google Picker that lists your Drive sheets.

The first row of your sheet is treated as the header row. LeadSync reads the header column names and exposes them as targets in the field mapping dropdown -- so you decide which lead form question goes in which column. Add or rearrange columns and LeadSync picks up the change automatically.

Yes. Add columns with the exact header names leadsync:campaign_name, leadsync:adset_name, and leadsync:ad_name -- LeadSync will fetch this metadata from Meta's Marketing API for every lead and write it into your sheet. Useful for pivoting your data by campaign performance.

No. LeadSync detects ArrayFormula columns automatically and skips writing to those cells when appending a new row. Your formulas continue to apply to every new row without being overwritten.

LeadSync refreshes it automatically using the stored refresh token whenever an API call fails. You authenticate once during setup and never need to reconnect unless you manually revoke LeadSync's access from your Google account.

Each LeadSync connection writes to one sheet (tab) in one spreadsheet, but you can create multiple connections that share the same spreadsheet and write to different tabs. Useful for separating Facebook leads from LinkedIn leads in the same workbook.

Yes. LeadSync supports Google Sheets as a destination for lead forms from Facebook, Instagram, Google Ads lead form extensions, LinkedIn Lead Gen Forms, and TikTok Lead Generation. Each ad source becomes its own connection.

Yes. Each LeadSync connection writes to one sheet (tab) in one spreadsheet, but you can create multiple connections that share the same spreadsheet -- routing Facebook leads to one tab, LinkedIn leads to another, and TikTok leads to a third. The spreadsheet is shared; the tabs stay independent.

Google Sheets caps at 10 million cells per spreadsheet (raised from 5 million in 2022). If your sheet approaches the limit, LeadSync's append calls will start failing -- archive old leads to a separate sheet or move to a fresh spreadsheet. For high-volume lead sources, consider rotating sheets monthly or quarterly.

Available Integrations

How It Works

How Facebook Leads Become Rows in Your Google Sheet

Campaign, Ad Set, and Ad Name Auto-Attribution

ArrayFormula Support and Token Refresh

Frequently Asked Questions

Start Syncing Leads to Google Sheets