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 Goole 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:

Afterwards, log-in to LeadSync and click on Connect a Service:

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

Afterwards 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 and the correct fields (refer to Step 2). Click Update Notification once you are done:

At the bottom you can see a _submission date field_**_, you don’t need to add this to your FB lead form as it’s automatically generated by LeadSync, however, you need to create a submission date column in Google Sheet to match it correctly._

TIP: you can setup multiple notifications, so you may want to setup 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.
Was this article helpful?
Thank you!