Facebook Lead Ads → Google Sheets + Slack
Every new lead from your Facebook or Instagram ads lands in a sheet and pings your team.
How it works
Trigger: Facebook Lead Ads — new lead
- Receive the new lead from your Facebook lead form.
- Add the name, email, phone and form name to your Leads sheet.
- Post the lead to #leads in Slack so someone calls within minutes.
Diagram
Trigger App
Build it
Pick your tool — same automation, step by step.
Copy and paste straight into an n8n canvas (Ctrl+V), or download and use Import from File. Then connect your own credentials and replace every YOUR_… placeholder.
Show code (125 lines)
{
"name": "Facebook Lead Ads → Google Sheets + Slack (Flowngn)",
"nodes": [
{
"parameters": {
"content": "## Facebook Lead Ads → Google Sheets + Slack\nEvery new lead from your Facebook or Instagram ads lands in a sheet and pings your team.\n\n**Setup**\n1. Open each node and connect your own credentials.\n2. Replace every YOUR_… placeholder.\n3. Test once, then activate.\n\nFree template from Flowngn",
"height": 260,
"width": 340
},
"id": "2799f021-3b0c-4e6c-a9be-88fef2d1f699",
"name": "Setup notes",
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-420,
-60
]
},
{
"parameters": {
"page": {
"__rl": true,
"value": "YOUR_PAGE_ID",
"mode": "id"
},
"form": {
"__rl": true,
"value": "YOUR_FORM_ID",
"mode": "id"
},
"event": "newLead",
"options": {}
},
"id": "2799f021-3b0c-4e6c-a9be-88fef2d1f699",
"name": "New lead",
"type": "n8n-nodes-base.facebookLeadAdsTrigger",
"typeVersion": 1,
"position": [
0,
0
],
"webhookId": "2799f021-3b0c-4e6c-a9be-88fef2d1f699"
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "YOUR_SPREADSHEET_ID",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "Leads",
"mode": "name"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"date": "={{ $now.toISO() }}",
"name": "={{ $json.data?.full_name ?? $json.full_name }}",
"email": "={{ $json.data?.email ?? $json.email }}",
"phone": "={{ $json.data?.phone_number ?? $json.phone_number }}",
"form": "={{ $json.form?.name ?? '' }}"
}
},
"options": {}
},
"id": "2799f021-3b0c-4e6c-a9be-88fef2d1f699",
"name": "Add to Leads",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
300,
0
]
},
{
"parameters": {
"select": "channel",
"channelId": {
"__rl": true,
"value": "#leads",
"mode": "name"
},
"text": "=📣 New ad lead: {{ $('New lead').item.json.data?.full_name ?? $('New lead').item.json.full_name }}\n📞 {{ $('New lead').item.json.data?.phone_number ?? $('New lead').item.json.phone_number }}",
"otherOptions": {}
},
"id": "2799f021-3b0c-4e6c-a9be-88fef2d1f699",
"name": "Ping #leads",
"type": "n8n-nodes-base.slack",
"typeVersion": 2.2,
"position": [
300,
220
]
}
],
"connections": {
"New lead": {
"main": [
[
{
"node": "Add to Leads",
"type": "main",
"index": 0
},
{
"node": "Ping #leads",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"meta": {
"templateCredsSetupCompleted": false
},
"tags": []
}In Make, create a new scenario and add these modules in order:
- Facebook Lead Ads › Watch Leads
- Google Sheets › Add a Row
- Slack › Create a Message
- Every module run uses Make operations — the free plan includes a monthly quota.
- Module and step names can differ slightly as Make and Zapier update their apps.
In Zapier, create a new Zap and add these steps in order:
- Facebook Lead Ads — New Lead
- Google Sheets — Create Spreadsheet Row
- Slack — Send Channel Message
- Zaps with more than two steps need a paid Zapier plan.
- Module and step names can differ slightly as Make and Zapier update their apps.
Tips
- Leads contacted within 5 minutes convert far better — the Slack ping is the important part.
Related flows
MarketingEasy
Weekly leads by source, compared with last week
Every Monday, see how many leads each channel brought this week versus last week, on Slack.
Google Sheets → Slack2h/mo
MarketingAdvanced
Competitor price change monitor
Check public product pages daily and get notified when a price changes.
HTTP Request → Google Sheets → Gmail5h/mo
MarketingEasy
Reddit brand mention alerts
Get a Slack message whenever someone mentions your brand or keyword on Reddit.
RSS → Slack3h/mo