Connect Facebook Lead Ads to Google Sheets

When you get a new lead from Facebook Lead Ads, your first thought is probably "Yay, my ad is working!" But getting a lead is just the first step. You also need to make sure you're routing it to the right place, so you can follow up and nurture it into a new customer. You'll probably want to send that lead's information to your customer relationship management (CRM) platform or marketing automation tool, as well as keep a backup in a spreadsheet tool like Google Sheets.

Of course, you could move leads around manually, either by copying and pasting all of this information or by downloading and uploading CSV files. If you have a lot of leads, however, that's inefficient and often leads to errors—like accidentally pasting information into the wrong field.

That's where Zapier comes in. With Zapier, you can automate the process of moving leads into the appropriate spreadsheet. This way, you can be confident that you aren't losing any new leads. 

Ready to get started? Follow these steps to connect Facebook Lead Ads to Google Sheets using Zapier.​​

Before you begin

Create your Google Sheet

Log in to your Google Sheets account and create the Sheet that you want to store the leads from your Facebook ad. Make sure your Sheet has a frozen header row with clearly labeled columns.

You can learn more about formatting Google Sheets to work with Zaps here.

Check Facebook Lead Ads permissions

You'll need admin access to the Facebook page you want to use, the associated ad account, and access to leads. Learn more about setting up these permissions.

You'll also need to create a form in Facebook Lead Ads and have at least one lead. If you don't have a lead, you can create a sample lead with Facebook Lead Ads' testing tool.

Finally, you'll need to be on a Zapier paid plan or in your two-week trial to use Facebook Lead Ads in a Zap. 

Connect Facebook Lead Ads to Google Sheets

Now you're ready to set up your automated workflow in Zapier. We call these workflows Zaps, and they can do a lot of common tasks for you, including moving information from one app to another. In this case, we're transferring lead information from Facebook Lead Ads into Google Sheets. You can create a Zap from scratch, but we also offer lots of templates to help get you started quickly. 

To get started with a template, just click on the one below, and you'll be taken to the Zapier editor. You'll also need to create a Zapier account if you don't have one yet. Then, follow the directions below to set up your Zap.

Set up your Facebook Lead Ads trigger step

First, you'll need to set up your trigger step—the event that starts your Zap. Search for and select Facebook Lead Ads for your trigger app and New Lead for your trigger event. If you're using the Zap template we linked above, these fields will already be selected for you. 

Next, sign in with your Facebook Leads Ads account (if you haven't already) and click Continue.

Next, choose the Facebook Page where you're running your ad campaign, and then choose the form where you're collecting the data. If you have multiple Pages or forms, you can select the one you want from the dropdown menu. Then click Continue.

Finally, you'll need to test your trigger step to make sure it's working correctly. Click Test trigger to pull in the latest submissions from your Facebook Lead Ads form.

If you don’t have any submissions yet, you'll need to use Facebook’s Testing Tool to create customized sample data for the form. Read our help guide for more details.

Once Zapier has returned the latest leads, select the one you want to use and click Continue with selected record.

Set up your Google Sheets action step

Now it's time to set up the action—the event your Zap will perform once it's triggered. If you're using the Zap template we shared earlier, these fields will already be set up  for you. Otherwise, you'll need to search for and select Google Sheets as your action app and Create Spreadsheet Row as your action event. Then, sign in with your Google Sheets account and click Continue.

Now it's time to customize your action step. Start by selecting the Google Drive, spreadsheet, and worksheet you want to use for this workflow.

Zapier will pull in the column headings from your Google Sheet. You'll need to map some data from your Facebook Lead Ads trigger to these columns. But don't worry—field mapping is easy. Just click the plus sign (+) in any field and select the data you'd like to use from the modal. Once you've mapped all of your fields, click Continue.

Finally, we always recommend testing your action step to make sure it's working as expected. Click Test step to test your Zap.

If your test is successful, you should see the data from your Facebook Lead Ad in your Google Sheet as a new row, based on how you configured it in the previous step.

Once everything is set up correctly, click Publish to turn on your Zap. And that's it! From now on, all new leads from your Facebook Lead Ads account will be logged in your Google Sheet as a new row.

Do more with Facebook Lead Ads with multi-step Zaps

Your Zap doesn't have to stop with just one action, however. Multi-step Zaps allow you to perform many actions from a single trigger. Multi-step Zaps can be handy when you need to:

• Send the same information to multiple places. For example, you may want to capture lead information in a spreadsheet, your CRM tool, and send a notification to a team chat app.

• Reformat or change trigger information before you use it in another action. For example, you might want to send certain leads to your tool with a path step or reformat your data to meet the needs of your CRM fields with a formatter step.

• Kick off an entire workflow. For example, whenever you receive a new lead, your sales team can instantly start their nurture process by auto-emailing that lead.

To create a multi-step Zap in the Zap editor, click on the plus sign where you'd like to add another step. 

You can then choose the app, AI tool, or Zapier feature you want to use in your new step.

Set up your action and test it. Keep in mind that with multi-step Zaps, the order of the steps matters—especially if you need to use information from a previous step. You can rename each step and add a description so it's easier to understand what's happening at each point.

Once you've added as many actions as you need, you're ready to publish and begin using your Zap.

More ways to automate Facebook Lead Ads

If connecting Facebook Lead Ads to Google Sheets made life easier for you, and you want to automate more of your lead management, check out some other helpful Zaps:

This article was originally published in July 2019, with later updates by Khamosh Pathak. It was most recently updated in February 2026 by Hannah Herman.