Link Meta Ads Lead Forms with Google Sheets via Zapier

Watch the step-by-step walkthrough below, then follow along with the guide to set up a Zapier automation that sends every new Meta Ads lead form submission straight into a Google Sheets spreadsheet.

Follow the Steps Book Coaching
Step by Step

Link Meta Ads Lead Forms with Google Sheets via Zapier

Follow these steps alongside the video to automate your lead capture from Meta Ads into Google Sheets.

Important: You will need a paid Zapier subscription to connect your Meta Ads Lead Form with Google Sheets via Zapier.
Part 1 — Preparation
1

Create a Lead Form (Instant Form) in Meta Ads

2

Create a new Google Sheets document

3

Name a column for each form field in your spreadsheet

  • For example: Name, Email, Phone Number — one column per field you collect in the lead form
Part 2 — Zapier Setup
1

Navigate to Zapier and create a New Zap

2

Select Facebook Lead Ads as the trigger and New Lead as the Event

3

Connect your Meta Ads account with Zapier

4

Select your Page and Form

5

Test your Trigger

6

Under Action, select Create Spreadsheet Row in Google Sheets

7

Connect your Google Drive account

8

Select the Spreadsheet and Worksheet where leads will be saved

9

Map each column to the corresponding Meta Ads Lead Form field

  • Under each column heading, select the matching lead form data to be pasted when a form is submitted
10

Test your Action and Publish the Zap

Need 1-on-1 help with Meta Ads?

Book a 90-minute coaching session and we'll work through your Meta Ads account together!

Book a Coaching Session
FAQ

Frequently Asked Questions

Common questions about connecting Meta Ads lead forms to Google Sheets via Zapier.

Do I need a paid Zapier plan to connect Meta Ads to Google Sheets?

Yes. The Facebook Lead Ads trigger in Zapier requires a paid subscription — it is not available on the free plan. You will need at minimum a Zapier Starter plan. Google Sheets actions are available on paid plans as well. Check Zapier's current pricing for the most up-to-date plan details.

How long does it take for a new lead to appear in Google Sheets?

Once your Zap is live, new leads typically appear in Google Sheets within 1–5 minutes of the form being submitted. Zapier checks for new leads at a regular polling interval, so there may be a short delay. On higher-tier Zapier plans, you can reduce this interval for near-instant delivery.

Will the Zap capture leads that came in before I set it up?

No. Zapier only captures leads that are submitted after the Zap is published and turned on. Historical leads that were collected before the Zap was activated will not be sent to Google Sheets automatically. To import past leads, download them manually from Meta Ads Manager and paste them into your spreadsheet.

Can I send leads to multiple Google Sheets at once?

Yes, but you would need a separate Zap for each sheet. Each Zap handles one trigger-action pair. If you want to send the same lead data to two different spreadsheets or tabs, create two Zaps with the same Facebook Lead Ads trigger but different Google Sheets actions. This counts as two tasks per lead submission.

What happens if I edit the Meta Ads lead form after setting up the Zap?

If you add or remove fields from your lead form, the column mapping in your Zap may break. Zapier stores the field mapping based on the form structure at the time of setup. After editing the form, go back into your Zap, re-test the trigger to load the new fields, and update the Google Sheets column mapping to match the updated form fields.

Can I connect Meta Ads leads to a CRM instead of Google Sheets?

Yes. Zapier supports connections to popular CRMs including HubSpot, Salesforce, Pipedrive, and many others. The setup process is similar — select your CRM as the Action app instead of Google Sheets, then map the lead form fields to the corresponding CRM fields. Meta also has native integrations with some CRMs via its own Leads Centre.

Keep Learning

Related Meta Ads Tutorials

More step-by-step guides to get more from your Meta Ads campaigns.

Get Personal Help

Book a 1-on-1 Coaching Session

Need a hands-on walkthrough tailored to your account? Book a 90-minute coaching session and we'll set it up together.