Having a database full of leads from ads is incredibly useful, but having to manually copy over all the information is time-consuming and downright boring. Fortunately, with Zapier you can automate the whole process, copying all the data you need from your Facebook Lead Ads over to a Google Sheet.
In case you're unfamiliar, Facebook Lead Ads let you gather new leads from online advertisements using custom forms. Google Sheets is cloud-based spreadsheet software and Google's answer to Microsoft Excel.
To get this integration working, all you need is a Facebook account with a page for your ad to run and a Google account with access to Google Sheets. Let's get started.
Option 1: Get started quickly with a Zap template
You can use the Zap template below as a starting point. Click the Use this Zap button, and you'll be guided through setup. You'll need to create a Zapier account, if you don't already have one.
Here's how it works:
Click the Use this Zap button above to get started (and create a Zapier account if you haven't already).
Connect your Facebook account, and select the Page and form you'd like to use.
Connect your Google Sheets account, and select the Sheet you want to use (you'll also be given the option to create a new spreadsheet).
Select the Google Sheet columns you'd like to add information to.
Map your Facebook Lead Ads form information to the appropriate Google Sheet columns.
Test your workflow, and turn it on.
Option 2: Create your own Zap
If you'd like more control over information in your Zap or would like to add additional actions, like automatically emailing your new lead or notifying your team about form responses in Slack, you can click here to start a new Zap from scratch.
Here are the steps involved:
Connect your Facebook Lead Ads account, and set up your trigger step in Zapier.
Create your Google Sheet.
Set up your Google Sheets action step in Zapier.
Step 1: Connect your Facebook Lead Ads account to trigger your Zap
The first thing you need to do is set up a new Zap to connect your Facebook Lead Ads trigger to the Google Sheets action.
To get started, choose Facebook Lead Ads as your app and New Lead as your trigger event. Please note that you will need a paid Zapier account to use this app in a Zap.
Click Continue. You will be asked to sign in to your Facebook account, if you haven't already. You will need to give Zapier access to some features on your Facebook account before proceeding.
Click Continue to give permission, then customize your Zap trigger by selecting a Facebook page and form to use for this integration.
For each app you connect, Zapier will ask for a general set of permissions which allows you to be flexible with your Zaps. The only actions Zapier takes on your app accounts are those a given Zap needs to accomplish what you've set up.
If you don't already have a form for your Facebook Lead Ad created, now is the time to make one. You can do so following Facebook's tutorial. For this tutorial, we made a simple form that collects the lead's name, email, and an answer to a question about ice cream.
When you've finished creating your form, return to your Zap and click Refresh fields to refresh the form menu so that you can see your new form.
Once you've selected a page and form, click Continue. You will be asked to pull in sample data, which is always a good idea when setting up a new Zap.
Step 2: Create your Google Sheet
Next, log in to your Google Sheets account and create the Sheet that you will use to log the leads from your Facebook ad. Be sure that your Sheet has a frozen header row with clearly labeled columns. This will help make the next step easier.
For this example. we are going to log:
Favorite ice cream
You can read more about formatting Google Sheets to work with Zaps here.
Step 3: Connect your Sheet to the Facebook Lead Ads trigger
Now that your Google Sheet is created, it's time to set up the action for your Facebook Lead Ads trigger. Choose Google Sheets as your app and Create Spreadsheet Row as your action.
This will prompt you to sign in to your Google Sheets account. After you've signed in, you can select the Google Drive, spreadsheet, and worksheet you wish to use for this integration.
Once you've selected your worksheet, the values you entered for the columns in your header will appear. If you decide to make any changes to your Sheet at this point, click Refresh Fields to update your options in this box.
Finally, select the values from the Facebook Lead Ads trigger's payload to populate your Sheet.
You can be as creative as you want for this part, filling out your Sheet with whatever data is useful to log. Click Show all options to load the full payload.
As you can see, it's showing the test data from our Facebook Lead Ads payload. Once all fields are selected, click Continue, and then test your Zap. After running the test, you should see the data from your Facebook Lead Ad form as a row in your Sheet.
Once you're sure everything is working correctly, make sure to turn on your Zap by clicking the toggle switch at the bottom of the screen.
And that's all! From now on, all new leads from your Facebook Lead Ads account will be logged in your Google Sheet as a new row.
Get more out of your Facebook Lead Ads and Google Sheets connection
If this data entry automation made life easier for you, check out some of our other Zaps using Facebook Lead Ads and Google Sheets:
This article was originally published in July 2019 and was updated in August 2021 by Kaylee Moser.