Facebook Lead Ads → Google Sheets + Slack

Every new lead from your Facebook or Instagram ads lands in a sheet and pings your team.

Easy Saves ~6 hours/month MarketingBy Flowngn team

Works with n8n · Make · Zapier

How it works

Trigger: Facebook Lead Ads — new lead
  1. Receive the new lead from your Facebook lead form.
  2. Add the name, email, phone and form name to your Leads sheet.
  3. Post the lead to #leads in Slack so someone calls within minutes.

Diagram

fNew leadFacebook Lead Ads Trigg…GAdd to LeadsGoogle SheetsSPing #leadsSlack
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.

Workflow JSON
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": []
}

Open in the playground to edit →

Tips

  • Leads contacted within 5 minutes convert far better — the Slack ping is the important part.

Related flows