Skip to content

How to Add TikTok Lead Gen Form Leads to Google Sheets

Automatically add TikTok Lead Gen Form leads to a Google Sheet as they come in.

Before You Start

  • LeadSync account (Business plan or higher)
  • TikTok for Business account with Lead Gen Form access
  • An active TikTok Lead Gen Form campaign
  • A Google account

Step 1: Create Your Google Sheet

  1. Go to Google Sheets and create a new spreadsheet
  2. Name your sheet (e.g., "TikTok Leads")
  3. Add column headers in the first row to match your Lead Gen Form fields:
  4. First Name
  5. Last Name
  6. Email
  7. Phone (if collected)
  8. Add a Date column to track when leads arrive
  9. Optional: Add tracking columns like Platform, Campaign Name, Ad Name

Tip: Column headers should match your form field names exactly for easier mapping.

Step 2: Connect Your TikTok Account

  1. Log in to LeadSync
  2. Go to Ad Accounts > TikTok from the left menu
  3. Click Add TikTok Account
  4. Sign in to TikTok for Business and authorize LeadSync
  5. Your account appears in the table when connected

Step 3: Set Up a Google Sheets Connection

  1. Go to Connections from the left menu
  2. Click Add Connection
  3. Select Google Sheets from the dropdown
  4. Click Connect to Google and authorize LeadSync to access your Google account
  5. Click Select Sheet and choose the spreadsheet you created
  6. Name your connection (e.g., "TikTok Leads Sheet")
  7. Click Update Connection

Step 4: Connect Your Lead Gen Form

  1. Go to Lead Forms from the left menu
  2. Click Add TikTok Lead Form
  3. Select your Ad Account from the dropdown
  4. Select your Lead Gen Form
  5. Select your Google Sheets Connection
  6. Map your fields: Match each TikTok form field to the corresponding Google Sheet column
  7. Click Update Notification

Step 5: Test Your Setup

Submit a test lead through your TikTok campaign. The lead should appear in your Google Sheet within 1-2 minutes.

Troubleshooting

  • Can't see your Ad Account? Make sure your TikTok account has access to the ad account.
  • Leads not appearing? Check that your field mapping is correct and the sheet has the right column headers.
  • Wrong columns? Edit your connection and re-map the fields to the correct columns.
  • Form not showing? The form must be part of an active or paused campaign.