$5 · Support the community
Lead GenerationFREE

Send Every Facebook Lead Ads Submission Straight Into Google Sheets

The moment someone completes your Facebook Lead Ads form, the lead is cleaned and written into Google Sheets as a de-duplicated contact — no copy-paste, no missed leads.

difficulty Beginnersetup 30 minresult A new Google Sheets contact appears within seconds of each Facebook Lead Ads submission, with name, email and company already filled in.—
—
  1. 1

    Step 1 — Receive the submission

    Add a Webhook node (POST). Copy its URL into Facebook Lead Ads as the submission endpoint so every completed form is pushed to n8n instantly.

  2. 2

    Step 2 — Normalise the fields

    Add a Set node. Create email, firstname, lastname and company and map each from the payload, e.g. {{ $json.body.email }}. This shields the rest of the flow from Facebook Lead Ads's field naming.

  3. 3

    Step 3 — Reject empty emails

    Add an If node with the condition {{ $json.email }} is not empty. The true branch continues; the false branch can alert you to a broken form.

  4. 4

    Step 4 — Write to the CRM

    Add a Google Sheets node. Set Operation to Append or Update, pick the sheet, and map each column. Match on email so re-submissions update in place.

  5. 5

    Step 5 — Confirm receipt

    Add a Respond to Webhook node returning Lead saved. This 200 response stops Facebook Lead Ads from retrying the submission.

Frequently asked questions

My Facebook Lead Ads field names are different — will this still work?

Yes. Only the expressions in the `Set` node (Step 2) reference field names. Change `{{ $json.body.email }}` to match the exact keys Facebook Lead Ads sends and every downstream step keeps working.

Will I get duplicate contacts in Google Sheets?

No. Step 4 upserts keyed on email address, so a repeat submission updates the existing Google Sheets record instead of creating a second one.

Related recipes
Lead GenerationFREE
Notionn8n
agent ready—

Log Every Facebook Lead Ads Lead to Notion Automatically

This n8n workflow watches Facebook Lead Ads for a new lead and automatically add it as a new page in a Notion database. Set it once and it runs 24/7.

n8nn8nNotionNotion
Beginner · 25 min setup
Lead GenerationFREE
Google Sheetsn8n
agent ready—

Automatically Send Every Facebook Lead Ads Lead to Google Sheets in Real Time

Connect Facebook Lead Ads and Google Sheets in n8n: each new lead is captured and sent straight to Google Sheets, in real time and completely hands-off.

n8nn8nGoogle SheetsGoogle Sheets
Beginner · 30 min setup
Lead GenerationFREE
Telegramn8n
agent ready—

Automatically Send Every Facebook Lead Ads Lead to Telegram in Real Time

Connect Facebook Lead Ads and Telegram in n8n: each new lead is captured and sent straight to Telegram, in real time and completely hands-off.

n8nn8nTelegramTelegram
Beginner · 30 min setup
Explore more like this
All Lead Generation recipes →n8n Facebook Lead Ads automationsn8n Google Sheets automations
About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.