{
  "name": "Automated WhatsApp welcome messages for sales leads with Google Sheets & Rapiwa",
  "nodes": [
    {
      "id": "0550f462-b916-47d3-bebf-b505da01a7fd",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2736,
        -880
      ],
      "parameters": {
        "width": 1040,
        "height": 1728,
        "content": "# Automated WhatsApp Welcome Messages for Sales Leads with Google Sheets & Rapiwa\n\n## What does this workflow do?\nThis n8n automation helps you send personalized WhatsApp messages to your leads, direc"
      }
    },
    {
      "id": "0841f0a0-7042-4049-8642-6d40987fc607",
      "name": "Fetch All Pending Queries for Messaging1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1072,
        -496
      ]
    },
    {
      "id": "27263025-0d11-4e6b-bf84-df8e3269cd24",
      "name": "Limit1",
      "type": "n8n-nodes-base.limit",
      "position": [
        -656,
        -496
      ]
    },
    {
      "id": "ed57db8c-6127-454f-b7a1-b65a77877e7b",
      "name": "Clean WhatsApp Number1",
      "type": "n8n-nodes-base.code",
      "position": [
        16,
        -480
      ]
    },
    {
      "id": "7e100ddc-107e-4059-90cb-b4cef3d5c3a7",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -416,
        -496
      ]
    },
    {
      "id": "da9deff5-b797-4997-a2e2-5923f09f7c18",
      "name": "Send Message Using Rapiwa1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        816,
        -128
      ]
    },
    {
      "id": "ae5bfcf0-f1c5-41a5-ad48-2f0cc94faa3c",
      "name": "Update rows: not sent & unverified1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        816,
        80
      ]
    },
    {
      "id": "fc1b5295-dda0-43ee-a275-32f55b969cb4",
      "name": "Update rows: sent & verified1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1040,
        -128
      ]
    },
    {
      "id": "524c6411-7826-4ef0-a723-e6fa741758b9",
      "name": "Wait1",
      "type": "n8n-nodes-base.wait",
      "position": [
        1040,
        80
      ]
    },
    {
      "id": "1f9f9e50-4934-4184-b4dd-b4aa3d2351ac",
      "name": "Check valid whatsapp number Using Rapiwa1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        224,
        -480
      ]
    },
    {
      "id": "31c3193f-ac56-4ae8-8221-06ef827f00ee",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1600,
        -896
      ],
      "parameters": {
        "width": 320,
        "height": 720,
        "content": "## Workflow Schedule\nThis workflow runs automatically every 5 minutes. You can adjust the interval if you want messages to go out more or less frequently. This ensures your leads are always contacted "
      }
    },
    {
      "id": "f1ed589d-493c-4a62-9fb3-5bbf0f83b0a5",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1248,
        -896
      ],
      "parameters": {
        "width": 448,
        "height": 944,
        "content": "## Google Sheets Connection\nThis step fetches all leads from your Google Sheet that are marked for messaging (where the `check` column is filled). Make sure your Document ID and Sheet GID are correct."
      }
    },
    {
      "id": "83a91565-e5b4-4551-a8b7-6407ce030c6b",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -768,
        -896
      ],
      "parameters": {
        "width": 608,
        "height": 1232,
        "content": "## Limit and Process Leads\nTo keep things running smoothly, the workflow processes up to 60 leads at a time. You can change this limit as needed. Each lead is handled one by one, so every contact gets"
      }
    },
    {
      "id": "5f158c59-9cb4-4c43-9705-8cb6843baef8",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -128,
        -896
      ],
      "parameters": {
        "width": 560,
        "height": 1232,
        "content": "## Clean and Verify WhatsApp Numbers\nBefore sending messages, each WhatsApp number is cleaned (removing spaces and symbols) and checked to make sure it’s a real, active WhatsApp account. Only valid nu"
      }
    },
    {
      "id": "30aea538-f33c-4e6e-ae4a-8295cc455f0f",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        464,
        -896
      ],
      "parameters": {
        "width": 848,
        "height": 1232,
        "content": "## Message Sending & Status Update\nIf a WhatsApp number is valid, the workflow sends a personalized message and updates the sheet to show it was sent. If not, it marks the row as not sent and unverifi"
      }
    },
    {
      "id": "20ec8ec0-ef20-40fe-9f97-8f11c201eb71",
      "name": "Trigger Every 5 Minute1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1504,
        -496
      ]
    },
    {
      "id": "769eb9a9-5afb-42f3-8b79-26dbb824902d",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        560,
        0
      ]
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Send Message Using Rapiwa1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Update rows: not sent & unverified1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Clean WhatsApp Number1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Clean WhatsApp Number1": {
      "main": [
        [
          {
            "node": "Check valid whatsapp number Using Rapiwa1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Trigger Every 5 Minute1": {
      "main": [
        [
          {
            "node": "Fetch All Pending Queries for Messaging1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Message Using Rapiwa1": {
      "main": [
        [
          {
            "node": "Update rows: sent & verified1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update rows: sent & verified1": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update rows: not sent & unverified1": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch All Pending Queries for Messaging1": {
      "main": [
        [
          {
            "node": "Limit1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check valid whatsapp number Using Rapiwa1": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}