Sign up
  • Home
  • Automation with Zapier

Connect Facebook Lead Ads to Google Sheets

Zapier tutorials

4 min read

Connect Facebook Lead Ads to Google Sheets

Automatically create a leads database

By Kaylee Moser · August 11, 2021
facebook-lead-ads-to-google-sh primary img

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: 

  1. Click the Use this Zap button above to get started (and create a Zapier account if you haven't already). 

  2. Connect your Facebook account, and select the Page and form you'd like to use.

  3. 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). 

  4. Select the Google Sheet columns you'd like to add information to.

  5. Map your Facebook Lead Ads form information to the appropriate Google Sheet columns. 

  6. 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:

  1. Connect your Facebook Lead Ads account, and set up your trigger step in Zapier.

  2. Create your Google Sheet.

  3. 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.

A screenshot outlining Zapier permissions, including managing ad accounts, leads, accounts, seetings, and webhooks, and creating and managing ads for your Page.

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.

A screenshot of the trigger setup showing a Page and Form selected.

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.

A sample quiz with a poll on favorite ice cream flavor. It reads: Zapier Example Welcome! This is a test lead ad. What is your favorite ice cream flavor? There are buttons for chocolate and vanilla and to continue.

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:

  • Date

  • Lead email

  • Lead name

  • Favorite ice cream

A screenshot of a Google Sheet with columns for "date," "lead email," "lead name," and "date."

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.

A screenshot of the action setup for a Zap showing Google Sheets as the app and Create Spreadsheet Row as the event.

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.

Setting up the action step in Zapier. The screenshot shows the drive, spreadsheet, worksheet selected and a field for "date." A dropdown menu shows information from your lead ads to insert into the 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.

A fully mapped set of fields showing information from Facebook Lead Ads that will be sent to your spreadsheet. "Created Time" is below "Date," "Email" is below "Lead Email," and "Full Name" below "Lead Name.

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.

A screenshot of a Google Sheet showing information from Facebook Lead Ads brought into a spreadsheet.

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.

Related reading:

Get productivity tips delivered straight to your inbox

We’ll email you 1/wk, and never share your information.

Kaylee Moser picture

Kaylee Moser

Kaylee Moser is a freelance writer living in the Sierra Foothills of California. When she’s not writing, she’s either gardening, collaging, or playing with her dog.

tags

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign upSee how it works