How to Add LinkedIn Lead Gen Form Leads to Google Sheets

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

Before You Start

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

• First Name
• Last Name
• Email
• Phone (if collected)
• Company (if collected)
• Job Title (if collected)

4. Add a Date column to track when leads arrive
5. 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 LinkedIn Account

1. Log in to LeadSync
2. Go to Ad Accounts > LinkedIn from the left menu
3. Click Add LinkedIn Account
4. Sign in to LinkedIn 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., "LinkedIn 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 LinkedIn 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 LinkedIn form field to the corresponding Google Sheet column
7. Click Update Notification

Step 5: Test Your Setup

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

Troubleshooting

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