How to Add Google Lead Ads to Google Sheets

Automatically add Google Lead Ads leads to a Google Sheet as they come in.

Before You Start

• LeadSync account (Business plan or higher)
• Google Ads account with Lead Form Extensions
• An active Google Lead Ads 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., "Google Leads")
3. Add column headers in the first row to match your Lead Form fields:

• First Name
• Last Name
• Email
• Phone (if collected)

4. Add a Date column to track when leads arrive
5. Optional: Add tracking columns like Platform, Campaign Name

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

Step 2: Connect Your Google Ads Account

1. Log in to LeadSync
2. Go to Ad Accounts > Google from the left menu
3. Click Add Google Account
4. Sign in to Google 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., "Google Leads Sheet")
7. Click Update Connection

Step 4: Connect Your Lead Form

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

Step 5: Test Your Setup

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

Troubleshooting

• Can't see your Ad Account? Make sure your Google 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.

Updated on: 24/01/2026