• Home

  • Automation with Zapier

  • Zapier tutorials

Zapier tutorials

5 min read

How to automatically track and respond to leads from Facebook Lead Ads

By Khamosh Pathak · September 1, 2023
A hero image of the Facebook Lead Ads logo connected to the Zapier logo on a light yellow background.

Facebook Lead Ads offer a great way to source organic leads directly from people actually interested in what you're posting. This can be a new product launch, a discount sale, or even a new board game meetup. But all that data doesn't need to stay on Facebook, only to be manually exported later. 

What if you could turn the Facebook leads into instantly actionable steps? With Zapier, you can create a single automated workflow—what we call Zaps—that sends out a personalized email and adds lead data to an ongoing Google spreadsheet at the same time. Give your entire team access to lead data and quickly follow up with leads without going to Facebook. 

This workflow requires a multi-step Zap, which is available on a paid Zapier plan or during a free trial. Learn more about multi-step Zaps. Facebook Lead Ads is a also premium app—available on Zapier's paid plans. Learn more about premium apps

Before you begin

Before you get started, make sure your Facebook Leads Ads settings are such that you're capturing the full name and email of users interacting with your Facebook ad.

Next, create a new spreadsheet in Google Sheets and create headers that correspond to the data you're trying to collect. The Zap won't work correctly if your spreadsheet doesn't have a header row.

In this example, we're collecting a person's full name and email address for joining a local board game meetup. If you wanted, you could also add a column for keeping track of the email you'll send in your second action step of this Zap.

A Google Sheets spreadsheet titled "Facebook Lead Ads" with columns for "Full Name" and "Email"

How to add Facebook Leads to Google Sheets and Gmail

Zapier lets you create automated workflows called Zaps, which send your information from one app to another. You can create your own Zap from scratch without any coding knowledge, but we also offer quick templates to get you started. 

If you'd like to start with a template, click the template below, and you'll be taken to the Zap editor. You'll need to create a Zapier account if you don't already have one. Then, follow the directions below to set up your Zap.

Send a Gmail email and add a spreadsheet row to Google Sheets for new leads in Facebook Lead Ads

Send a Gmail email and add a spreadsheet row to Google Sheets for new leads in Facebook Lead Ads
  • Facebook Lead Ads logo
  • Gmail logo
  • Google Sheets logo
Facebook Lead Ads + Gmail + Google Sheets

Set up your Facebook Lead Ads trigger

Let's start with the trigger—the event that starts your Zap. If you're using the Zap template, this will be selected for you. Otherwise, search for and select Facebook Lead Ads as the trigger app and New Lead as the trigger event, then click Continue.

A trigger step in the Zap editor with Facebook Lead Ads selected for the trigger app and New Lead for the trigger event.

Next, connect your Facebook account, if you haven't already, then click Continue.

To set up the trigger, select the Facebook Page and Form you'd like to use in this Zap. Then, click Continue

In the Zap editor, fields to select a Facebook Lead Ads page and form that are shown filled in.

Now, it's time to test your trigger step. This will gather information from the Facebook Ads form that will be used to set up the rest of your Zap. Before clicking Test trigger, make sure there's at least one submission in the form (you can add fake testing data if you don't have any submissions). 

Zapier will show you the most recent data from the ad form.

A selection of Facebook Lead Ads test data in the Zap editor with "Lead B" selected.

Click Continue with selected record to move on to setting up your action step. 

Set up your Gmail action

Now it's time to set up the action that will send out the email—the event your Zap will perform once it's triggered. If you're using the Zap template, these will already be selected for you. Otherwise, search for and select Gmail as your action app and Send Email as your action event. Click Continue.

An action step in the Zap editor with Gmail selected for the action app and Send Email for the action event.

Next, connect your Gmail account, if you haven't already. Then click Continue.

Now, it's time to customize your action step. First, click in the To field and select either Email or Raw Email from the Insert Data dropdown. This will ensure the email is sent to the email address collected in your previous Facebook Lead Ads step.

The Insert Data menu is shown open with a list of a data from the previous Facebook Lead Ads trigger step.

Next, customize the From Name section. Here, you can automatically input the Facebook page's name or use something else. 

Use the Subject field to create an eye-catching subject line.

Craft the email copy in the Body field. Write in the static copy you'd like to repeat each time. You can also add data from your previous Facebook Lead Ads step—like the lead's name—by clicking in the field and selecting the data from the dropdown.

Gmail fields in an action step with data from the previous Facebook Lead Ads step added to the Body field.

You can then add a custom signature or attachments if you'd like. Once you're ready, click Continue.

Next, click Test action, and Zapier will send a test email using the linked Gmail account. You will see the test date in the preview. 

If it works correctly, you should also see an email in your sent emails in your Gmail inbox. This is what our successful email looked like.

An email in Gmail that says "Thank you for registering for our board game meetup!"

Once you're happy with your step, click Continue to move on to the next action step.

Set up your Google Sheets action

Now it's time to set up the Google Sheets action—the event your Zap will perform once the email is sent. If you're using the Zap template, these will already be selected for you. Otherwise, click the + button at the end of the steps to add a new action. 

Search for and select Google Sheets as your action app and Create Spreadsheet Row as your action event. Click Continue.

An action step in the Zap editor with Google Sheets selected for the action app and Create Spreadsheet Row for the action event.

Next, connect your Google Sheets account, if you haven't already. Then click Continue.

Let's customize the Google Sheets action now. First, choose the appropriate drive in the Drive field where your Google Sheet is stored. Next, select the Spreadsheet you created for the landing page, then choose the appropriate Worksheet (by default, it's "Sheet1").

Google Sheets fields for Drive, Spreadsheet, and Worksheet.

Zapier will then automatically pull in the column headings you added to your sheet. 

What's left now is to map our columns with the data from Facebook Lead Ads. To add the data from your previous Facebook Lead Ads step, simply click in a field and select the data you'd like to use from the Insert Data dropdown.

For our example, we'll add Full Name to the Full Name field and Raw Email or Email data to the Email field. Your mapping will depend on your landing page, but Zapier shows the data preview from the test, so it's quite easy to match the fields that you want. 

Once that's done, click Continue.

Fields for "Full Name" and "Email" are shown filled in with data from the previous Facebook Lead Ads step.

Click Test action, and Zapier will send the test data to the spreadsheet in Google Sheets. Check the results to make sure the right data is mapped to the appropriate columns.

A succesful test message that shows info added to a spreadsheet.

If you'd like, you can go to your Google Sheets spreadsheet to double-check. Here's what the successful test results look like for us.

A Google Sheets spreadsheet with a name and email filled in.

And that's all there is to it! Any time you get a new lead from a Facebook form, they will instantly receive a personalized email, and their data will be added to a new row in Google Sheets. Now, sit back and convert those leads! 

Related reading:

  • 4 ways to automate Facebook Lead Ads

  • 6 ways to automate Google Sheets

  • 4 ways to automate Gmail

  • How to connect Facebook Lead Ads to Google Sheets

  • Connect Facebook Lead Ads to a Mailchimp email list

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags

Related articles

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

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'