How to Add Facebook Lead Ad Leads to Google Sheets

Create Your Google Sheet

If you don’t already have a Google Sheet setup to collect leads, log into your Google Sheets account and create one as follows.

Log-in to your Google Account.

Go to Google Sheets and create a new sheet, naming it accordingly.

Add the fields names to your sheet making sure they are the same details you are using (or going to use) for your Facebook Lead Form. Be sure to add a date field and a date & time field so you can also record when a lead is added.


Optional: Add Tracking Data Fields
If you’d like to track where your leads have come from, you can add the 4 following fields to your Google Sheet: Platform, Campaign Name, AdSet Name and Ad Name.

Connecting a Meta Lead Form to a Google Sheet

Now that you’ve created your Google Sheet that you want to use to collect Facebook leads, let’s set up the connection between the lead form and Google Sheet.

Add A Google Sheet Connection

In your LeadSync account, go to the Connection section, then click Add Connection.



Select Google Sheets from the dropdown list.



You’ll then be prompted to select your Google account and allow LeadSync access to write data to only the Google Sheet you choose.



Use the Select Sheet button to choose the sheet you want to add leads to.

Pairing Your Lead Form To a Google Sheet

To pair the lead form you’re using in your lead ads with your Google Sheet, go to the Lead Forms section and click Add Facebook Lead Form.



Select your Page, Form and the Google Sheets connection you just setup. Make sure you Select the Sheet too!



Map the Data from Your Facebook Instant form (lead form) to the fields in your Google Sheet then click Update.

Testing Your Connection

We recommend you test your connection: here’s how.

Updated on: 23/01/2025