If you've been doing Lead Generation ads in Meta Ads and you've been painstakingly transferring the data manually to Google Sheets, then this guide is for you! We will show you how to connect your Facebook / Instagram lead forms to Google Sheets and transfer the data in real time via Zapier! No matter how many questions (fields) you have in your lead forms, you can transfer these data to Google Sheets automatically via Zapier.
Disclaimer: You will need to have a paid Zapier subscription to connect your Meta Ads Lead Form with Google Sheets via Zapier. Now, without further ado, let's get started!
Prepare your Meta Ads Lead Form and Google Sheets Document
Create a Lead Form (Instant Form) in Meta Ads
Create a new Google Sheets document
In your Google Sheets document, name a column as per each form field
For example, our lead form includes questions such as first name, email, phone number, and what are you looking for; so we will input the column according to these fields.
How to Connect Meta Ads Lead Forms with Google Sheets via Zapier
Login to your Zapier account
Create a New Zap
Select "Facebook Lead Ads" as the trigger and "New Lead" under the Event
Connect your Meta Ads account with Zapier: If this is the first time you're connecting your Meta Ads account with Zapier, then the system will prompt you to log in to your Meta Ads.
Select your Page and Form
Click on the dropdown to select the Facebook Page where your form is created
Select the form that you want to connect with Google Sheets.
Test your Trigger: If the system says they found a lead, it means a connection has been successfully established.
Add a new action and select Google Sheets
Select "Create Spreadsheet Row" under Event
Connect your Google account
Connect your Google Drive
Select the Document (Google Sheets) and tab where the lead form data will be transferred
Under each field (column), select the Meta Ads Lead Form data to be pasted once the form is submitted
Test your Trigger: If the setup is correct, you'll find this dummy submission in the connected Google Sheets document.
Publish your Zap
Frequently Asked Questions on Connecting Meta Ads Lead Forms with Google Sheets via Zapier
What do I need to connect my Meta Ads Lead Forms with Zapier?
A Meta Business Manager account with lead forms set up
A Google Workspace (formerly G Suite) account
A Zapier account (free plan available, but paid plan recommended for business use)
Appropriate permissions and access rights for all platforms
What permissions do I need to connect my Meta Ads Lead Forms with Zapier?
Meta Business Manager: Admin or Editor role
Facebook Page: Admin role
Google Sheets: Edit access to the destination spreadsheet
Zapier: Active account with available tasks
What should I do if the Zapier integration stops working?
Check your Zapier account status and task limits
Verify all account connections are active
Review recent changes to form or spreadsheet structure
Check for error notifications in Zapier
Test the Zap manually
Comments