n8n recipe · leads

Facebook Lead Ads → Google Sheets → Slack

Leads from a Facebook Lead Ads form land in Google Sheets the moment they arrive, with a Slack ping.

페이스북 광고 신청서로 손님이 들어오면 바로 구글 시트에 적고 슬랙으로 알려 줘요.

Steps

  1. When when a facebook lead ad form is submitted — Facebook Lead Ads node
  2. Then add a row to google sheets — Google Sheets node
  3. Then send a slack message — Slack node

Fields to fill (8)

The file has every node wired up. These are the blanks only you can fill (your form, your sheet, your words).

NodeWhat to do
Facebook Lead Adsfill page (The page linked to the form for retrieving new leads)
Facebook Lead Adsfill form (The form to monitor for fetching lead details upon submis...)
Google Sheetsfill documentId (Document)
Google Sheetsfill sheetName (Sheet)
Google Sheetsfill columns (Columns)
Slackcheck select = 'channel' (first option; pick yours)
Slackfill channelId (The Slack channel to send to) — only if select = channel
Slackfill text (The message text to post)

Accounts to connect (3)

In n8n, pick or add a credential on each node — one of the types below.

Get the n8n file

Download facebook-lead-ads-to-sheets-and-slack.json

  1. Open a new, empty workflow in n8n.
  2. Open the workflow menu (⋯) and choose Import from File — or copy the JSON below and paste it onto the canvas (Ctrl/Cmd+V).
  3. Connect the accounts, fill the fields above, run one test, then turn the workflow on.
Or copy the JSON 
{
  "name": "Leads from a Facebook Lead Ads form land in Google Sheets the moment they arrive",
  "nodes": [
    {
      "id": "n1",
      "name": "Facebook Lead Ads Trigger",
      "type": "n8n-nodes-base.facebookLeadAdsTrigger",
      "typeVersion": 1,
      "parameters": {
        "event": "newLead",
        "page": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "form": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "position": [
        240,
        300
      ],
      "notes": "step: when a facebook lead ad form is submitted"
    },
    {
      "id": "n2",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.7,
      "parameters": {
        "resource": "sheet",
        "operation": "append",
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {},
          "matchingColumns": [],
          "schema": []
        }
      },
      "position": [
        460,
        300
      ],
      "notes": "step: add a row to google sheets"
    },
    {
      "id": "n3",
      "name": "Slack",
      "type": "n8n-nodes-base.slack",
      "typeVersion": 2.7,
      "parameters": {
        "resource": "message",
        "operation": "post",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "text": ""
      },
      "position": [
        680,
        300
      ],
      "notes": "step: send a slack message"
    }
  ],
  "connections": {
    "Facebook Lead Ads Trigger": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "active": false
}