AutomationFlowsEmail & Gmail › Facebook Lead Management: Automate Email Responses with Gmail & Google Sheets

Facebook Lead Management: Automate Email Responses with Gmail & Google Sheets

BySpaGreen Creative @spagreen on n8n.io

This n8n workflow is designed for marketers, sales teams, and business owners who use Facebook Lead Ads to capture customer information. It's perfect for those who want to immediately engage with leads through multiple channels without manual intervention. The workflow…

Event trigger★★★★☆ complexity18 nodesExecute Workflow TriggerFacebook Lead Ads TriggerGoogle SheetsGmail
Email & Gmail Trigger: Event Nodes: 18 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #10323 — we link there as the canonical source.

This workflow follows the Execute Workflow Trigger → Gmail recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "giVBIt7WFacM8ujc",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Facebook Lead Management: Send Bulk WhatsApp Messages & Emails Automatically",
  "tags": [],
  "nodes": [
    {
      "id": "243082de-153c-4081-b421-c2690d13915f",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        1296,
        464
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "0360724c-9b37-405c-a9be-1107077a1774",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        464,
        448
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "d8cd523e-ec3d-4211-bb5b-3f1b4d77e697",
      "name": "Click to Start",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        16,
        544
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f809a897-f90e-4934-9df2-af71d280c44c",
      "name": "Executed by Another Workflow",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        16,
        352
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "4732e301-3711-4a2f-89f4-d5749f5b3177",
      "name": "Facebook Lead Ads",
      "type": "n8n-nodes-base.facebookLeadAdsTrigger",
      "position": [
        -272,
        32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5a310514-3060-4504-ab68-e6180fe61a3c",
      "name": "Format Ads Lead Response Data",
      "type": "n8n-nodes-base.code",
      "position": [
        -48,
        32
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "8c60754c-c093-4b8a-8bfd-e5c5db005354",
      "name": "Save Ads Lead In Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        176,
        32
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "5bd4bc13-3292-492c-856b-4493cfe6ab09",
      "name": "Do Nothing",
      "type": "n8n-nodes-base.noOp",
      "position": [
        400,
        32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "edcded97-7794-4fb2-8628-c177fe6a3c7e",
      "name": "Get row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        240,
        448
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "547f9d37-251e-4f51-a7e5-ecdff32f1a2d",
      "name": "Send a Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        704,
        464
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "f236c5cd-9acc-465a-b746-e5b0504b6f11",
      "name": "Save State of Rows in Email Sent",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1024,
        464
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "57b50511-c5bb-44c8-a9be-6053455ec0c2",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        -128
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0e277c68-1aaa-41eb-8712-e4800c1cc8db",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7fa2848b-e556-468f-9b2c-1d6b02e35529",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        256
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2bdafef1-45f3-4c12-905e-485d3411d142",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -128
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b55eab3d-23b9-46f9-8e41-c542465583c0",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        208,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a1eb17e7-d9d8-426b-a0db-3ae283dcd880",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1200,
        -128
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fb1ce2cb-3b43-4307-87c8-1b18480ffdf1",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        768
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "963cb86f-d882-4f20-b315-24bdea9a9583",
  "connections": {
    "Wait": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a Email": {
      "main": [
        [
          {
            "node": "Save State of Rows in Email Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Click to Start": {
      "main": [
        [
          {
            "node": "Get row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Send a Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Facebook Lead Ads": {
      "main": [
        [
          {
            "node": "Format Ads Lead Response Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save Ads Lead In Sheet": {
      "main": [
        [
          {
            "node": "Do Nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Executed by Another Workflow": {
      "main": [
        [
          {
            "node": "Get row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Ads Lead Response Data": {
      "main": [
        [
          {
            "node": "Save Ads Lead In Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save State of Rows in Email Sent": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This n8n workflow is designed for marketers, sales teams, and business owners who use Facebook Lead Ads to capture customer information. It's perfect for those who want to immediately engage with leads through multiple channels without manual intervention. The workflow…

Source: https://n8n.io/workflows/10323/ — original creator credit. Request a take-down →

More Email & Gmail workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Email & Gmail

Splitout Code. Uses manualTrigger, httpRequest, stickyNote, splitOut. Event-driven trigger; 46 nodes.

HTTP Request, Execute Workflow Trigger, Gmail +1
Email & Gmail

Automate CSV imports into HubSpot without the mess. Powered by n8n. Supercharged by Pollup AI.

HTTP Request, Execute Workflow Trigger, Gmail +1
Email & Gmail

Code Filter. Uses googleSheets, gmail, stickyNote, executeWorkflowTrigger. Event-driven trigger; 32 nodes.

Google Sheets, Gmail, Execute Workflow Trigger
Email & Gmail

This n8n workflow enables teams to automate and standardize multi-step onboarding or messaging workflows using Google Sheets, Forms, Gmail, and dynamic logic powered by Code and Switch nodes. It ensur

Google Sheets, Form, Execute Workflow Trigger +2
Email & Gmail

Loan eligibility workflow. Uses formTrigger, googleSheets, gmail. Event-driven trigger; 53 nodes.

Form Trigger, Google Sheets, Gmail