tr Skip to content

Connect Facebook Lead Ads and Google Sheets

Send each lead from your Facebook lead forms to a Google Sheet, with the answers you choose in the columns you choose. FlowMattic runs the workflow on your own WordPress site, so the sales team works from one shared list and a busy campaign costs the same as a quiet one.

7 triggers 21 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Facebook Lead Ads1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Lead
2. ActionAdd New Row

When Facebook Lead Ads fires New Lead, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Facebook Lead Ads and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Facebook Lead Ads app icon Google Sheets app icon Ready-made template

Add each new Facebook lead as a row in Google Sheets

The sheet becomes the live list of the campaign. Whoever follows up works from the same rows instead of downloading a file from Ads Manager.

New LeadAdd New Row

View the template
Facebook Lead Ads app icon Google Sheets app icon

Update the existing row when someone signs up twice

Look the email up first. A Router updates the row of a repeat lead and adds a new row only for a new person, so the count stays honest.

New LeadLookup Row DataRouterUpdate Row

Facebook Lead Ads app icon Google Sheets app icon

Give every lead form its own tab

Agencies running several forms route each lead by form name, so each client or campaign has a tab that holds only its own leads.

New LeadRouterAdd New Row

Facebook Lead Ads app icon Google Sheets app icon

Bring a form's earlier leads into the sheet

Leads collected before the workflow existed are not lost. Pull them once with Retrieve Leads, loop over the list and write each one as a row.

ScheduleRetrieve LeadsIteratorAdd New Row

Facebook Lead Ads app icon Google Sheets app icon

File each lead in the current month's tab

Format the lead's date as a month name and use it as the sheet name, so monthly reporting starts from a clean tab without moving rows by hand.

New LeadDate/Time FormatterAdd New Row

Facebook Lead Ads app icon Google Sheets app icon

Clean names and phone numbers before they reach the sheet

Lead forms collect whatever people type. Trim spaces and fix the capitalisation of names first, so the sheet is ready for a dialler or a mail merge.

New LeadText FormatterAdd New Row

Set up: each new lead as a row

At the end, every new lead from the form you pick is written to your sheet as one row.

  1. Connect Facebook Lead Ads

    In FlowMattic, open Connects and add a Facebook Lead Ads connection with the Facebook account that manages your page.

  2. Connect Google Sheets

    Add a Google Sheets connection with an account that can edit the spreadsheet you want to fill.

  3. Start with New Lead

    Create a workflow, choose Facebook Lead Ads and the New Lead trigger, pick the page and form, then send a test lead so FlowMattic captures its fields.

  4. Add New Row

    Add a Google Sheets step with Add New Row, choose the spreadsheet and sheet, map each lead field to its column, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up
Add each new Facebook lead as a row in Google Sheets Template
  1. Facebook Lead Ads app icon 1. Trigger in Facebook Lead Ads New Lead
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From Facebook Lead AdsTo Google Sheets
    Full nameName
    EmailEmail
    Phone numberPhone
    Form nameSource
    Created timeDate
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

  • Facebook Lead Ads has one trigger, New Lead, so these workflows start from Facebook. To work with leads collected earlier, use the Retrieve Leads action.
  • The fields come from the questions in your lead form, so the mapping above is an example. Add the sheet's header row first so every column is there to map.
  • Without a lookup step, a person who submits the form twice gets two rows. Search the email column with Lookup Row Data before writing if that matters.
  • Google Sheets triggers such as Update Specific Column Value can start a second workflow, for example when your team marks a lead as called.
Facebook Lead Ads app icon

Facebook Lead Ads

Integration page

Triggers (1)

  • New LeadTriggers when a new lead is created

Actions (2)

  • Retrieve LeadsRetrieve the leads for specific lead form
  • Retrieve Lead by Lead IDRetrieve a specific lead by its Lead ID
Google Sheets app icon

Google Sheets

Integration page

Triggers (6)

  • New Spreadsheet RowTrigger when a new row is added to the spreadsheet
  • New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
  • Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
  • Update Cell DataTrigger when any cell is updated in the spreadsheet
  • Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
  • Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

  • Add New RowAdd a new row with mapped data
  • Update RowUpdate existing row in specific spreadsheet with mapped data
  • Delete RowDelete row by ID in specific spreadsheet
  • Clear Row DataClear data or row by ID in specific spreadsheet
  • Lookup Row DataSearch for data in specific spreadsheet
  • Get Cell DataGet data for particular cell in specific spreadsheet
  • Update Cell DataUpdate data for particular cell in specific spreadsheet
  • Get Row CountGet total number of rows in specific spreadsheet
  • Get Row DataGet rows data from the sheet based on specified range
  • Create Spreadsheet ColumnCreate a new column in specific spreadsheet
  • Create New SheetCreate a new sheet in specific spreadsheet
  • Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
  • Copy SheetCopy a sheet to another or within the same spreadsheet
  • Get RowsRetrieve rows in JSON format for use with Iterator
  • Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
  • Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
  • Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
  • Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
  • Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Facebook Lead Ads and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Lead details stay on your server

Names, emails and phone numbers pass through your own WordPress site on the way to the sheet, not through another company's automation account.

A busy campaign costs the same

Runs are unlimited, so a lead form that brings in thousands of leads a month needs no bigger plan than one that brings in ten.

Add WordPress steps after the sheet

Once the row is written, the same workflow can create a FluentCRM contact, a WooCommerce coupon or a welcome email from your own site.

Common questions

Do I need to write code to send Facebook leads to Google Sheets?

No. You pick the New Lead trigger, choose your page and form, and map the lead's fields to columns in an Add New Row step. The whole workflow is built on the FlowMattic canvas inside WordPress.

Can I keep repeat sign-ups out of the sheet?

Yes. Add a Lookup Row Data step that searches the email column, then a Router. One path runs Update Row when the email is already there, the other runs Add New Row for a new person.

Which Google account do I need?

Any Google account that can edit the spreadsheet. A free Gmail account and a Google Workspace account both work, and the sheet can stay shared with your team as it is today.

Can I bring in leads collected before I set this up?

Yes. Run a workflow with the Retrieve Leads action for the form, loop over the results with Iterator and write each lead with Add New Row. Run it once, or on a schedule if you want a regular catch-all.

Can one lead go to more than one sheet?

Yes. Add a second Google Sheets step pointed at another spreadsheet, or use a Router to send each lead to the sheet for its form or client.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Facebook Lead Ads and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Facebook Lead Ads integration 2.0.2, Google Sheets integration 2.2.4.