Articles on: Integrations

How to Add Facebook Lead Ad Leads to Google Sheets

If you’re a Gmail user, you’re probably familiar with Google Sheets. It’s part of a Googles (mostly) free, web-based software office suite available within G-suite and Google Drive.

The beauty of Google’s office suite is that you can edit and collaborate with others – from your computer, phone or tablet.

This makes Google Sheets a great basic free CRM for Facebook Leads for you and your team if you haven’t decided to go with one of the many fancier, complicated and expensive options. We won’t mention names.

With our latest integration, you can now automatically add new Facebook Lead Ad Leads into a Google Sheet. Available on Business, Marketing and Agency accounts, here’s how to get setup…

Following is a 5-minute video tutorial, or you can follow the how-to steps below.

Step-by-Step Guide

Log-in to your Google account:

Go to Google Sheets and create a new sheet, naming it accordingly. Make sure the fields on each column are the same details you are using (or going to use) for your Facebook Lead Form. Also, please avoide any non alphanumeric characters such as
: ! @ $ % & *

By default, the Google sheet file name is named Sheet1 and the tab is also named sheet1, so we suggest to rename your Google sheet file and tab which will be helpful in the latter part:

Now login to LeadSync and click on Connect a Service:

Click on the Connection drop-down arrow and select Google Sheets.

You will be taken to another window, click Allow:

Once you click on Allow, you will be taken back to Setup Connection window and the Google Sheets token will automatically be filled up. Name your connection appropriately and in the List box select the name of your Google Sheet file (refer to step 2) and click on Update connection:

Once you are back in the main LeadSync view, click on Add Facebook Lead Form button:

Select your Facebook business page (Admin access) and the correct Lead Form (important). For connection, select Google Sheets and click on Update Notification:

New options will appear, for Select Sheet, select the Google Sheet tab name

Map the fields from your Facebook Lead form to the column names in your Sheet.

Note At the bottom there are two date options: you can maps one or both depending on if you just want to show the date, or the time and date.

Click Update to finish setting up your Google Sheet connection

TIP: you can setup multiple notifications, so you may want to set up an email notification that will alert you when a new lead comes in.

Here's how to test your connection. This should add a test lead to Google Sheets.

Updated on: 05/07/2021

Was this article helpful?

Share your feedback


Thank you!