Send WhatsApp Bulk Messages From Google Sheets

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 →

{
  "id": "9KGiiRIN9IKHc7Ls",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "WhatsApp Bulk Message Broadcast From Google Sheet",
  "tags": [],
  "nodes": [
    {
      "id": "e76ca205-6342-48e8-baf2-dd46c7cd8524",
      "name": "Fetch All Pending Queries for Messaging",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        128,
        32
      ],
      "parameters": {},
      "notesInFlow": false,
      "retryOnFail": false,
      "typeVersion": 4.6
    },
    {
      "id": "96e27292-9c80-4294-87da-7c16a3b1e5c2",
      "name": "Limit",
      "type": "n8n-nodes-base.limit",
      "position": [
        368,
        32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e9246a66-68d4-4159-b231-b9032f104ddf",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        640,
        32
      ],
      "parameters": {},
      "executeOnce": false,
      "typeVersion": 3
    },
    {
      "id": "f3ba4b18-d324-4548-80e5-469354af27a9",
      "name": "Change State of Rows in Sent1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1072,
        16
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "547f5f77-cf4a-4d50-897a-682b53389293",
      "name": "Send Message to 100 Phone No1",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1072,
        208
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d85bfed1-57d8-4889-834e-d0a3b0288cf1",
      "name": "Clean WhatsApp Number",
      "type": "n8n-nodes-base.code",
      "position": [
        848,
        208
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "daafd591-1d05-4469-a727-2985f56081db",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -864,
        -160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "37d1728b-89fe-4bf8-9c5e-e42d3e4e51ae",
      "name": "Trigger Every 5 Minute",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -80,
        32
      ],
      "parameters": {},
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "e5e04a32-bc80-4623-ac07-b00706d20adf",
  "connections": {
    "Limit": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Change State of Rows in Sent1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Clean WhatsApp Number",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clean WhatsApp Number": {
      "main": [
        [
          {
            "node": "Send Message to 300 Phone No",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Trigger Every 5 Minute": {
      "main": [
        [
          {
            "node": "Fetch All Pending Queries for Messaging",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Message to 100 Phone No1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch All Pending Queries for Messaging": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

About this workflow

This workflow enables automated bulk WhatsApp message broadcasting using the WhatsApp Business Cloud API. It pulls recipient and message data from a Google Sheet, sends templated messages (optionally with image headers), and updates the sheet with the message status. It is ideal…

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

More Slack & Telegram workflows → · Browse all categories →

Related workflows

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