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.
- 1
Add the Facebook Lead Ads Trigger node
Start with a
Facebook Lead Ads Triggernode — connect your Facebook account via OAuth, then setPageto the Facebook Page running your ads andFormto the specific lead form you want to capture. This fires the workflow the moment a new lead arrives. - 2
Map the fields with a Set node
Add a
Setnode after the trigger to shape the data cleanly. Create fields:full_nameto{{ $json.field_data.find(f => f.name === 'full_name')?.values[0] }},emailto{{ $json.field_data.find(f => f.name === 'email')?.values[0] }}, andphoneto{{ $json.field_data.find(f => f.name === 'phone_number')?.values[0] }}. This turns the raw payload into tidy values your destination can use. - 3
Send it to Google Sheets
Add a
Google Sheetsnode set to operationAppend Row. Connect your Google account, choose theSpreadsheetandSheet(e.g. aLogtab), and map each field from the Set node to a matching column. Make sure row 1 of your sheet has headers with the same names. - 4
Activate and test
Click
Activatein the top-right of the canvas. Trigger a test lead in Facebook Lead Ads, then confirm it appears in Google Sheets. Once it works, you're done — every new lead now flows through automatically.
Frequently asked questions
Do I need any coding skills to set this up?
No. n8n is a visual, drag-and-drop tool. You connect your Facebook Lead Ads and Google Sheets accounts, point the nodes at the right form/sheet/channel, map the fields, and activate. No code required.
Can I send each lead to more than one place at once?
Absolutely. Branch the workflow after the Set node: connect it to multiple destination nodes so the same lead lands in Google Sheets and, say, Slack or a spreadsheet simultaneously.
Can I send each lead to more than one place at once?
Absolutely. Branch the workflow after the Set node: connect it to multiple destination nodes so the same lead lands in Google Sheets and, say, Slack or a spreadsheet simultaneously.
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.
n8nNotion
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.
n8nTelegram
Automatically Send Every Typeform Response to Google Sheets in Real Time
Connect Typeform and Google Sheets in n8n: each new response is captured and sent straight to Google Sheets, in real time and completely hands-off.
n8nTypeformGoogle SheetsKeep every recipe free
FlowRecipesHub is free and always will be. If a workflow saved you time, chip in what you like — it helps us keep the lights on and build the next batch of automations for everyone.
One-tap support is being set up — check back soon. 💚
Secure checkout via Paddle · one-time, no account needed