{
  "name": "WhatsApp number verify & confirmation system with Rapiwa API and Google Sheets",
  "nodes": [
    {
      "id": "6cc792e7-eb4a-4e9e-8989-338986085fb8",
      "name": "Cleane Number",
      "type": "n8n-nodes-base.code",
      "position": [
        -624,
        144
      ]
    },
    {
      "id": "5707dc19-9692-40db-96f4-8e2061d0e0b2",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -992,
        128
      ]
    },
    {
      "id": "78732045-d7d2-464d-85b5-e4069a76f6d5",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1552,
        128
      ]
    },
    {
      "id": "05f4d013-f55c-43ad-90a3-e93db13a6482",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        16,
        144
      ]
    },
    {
      "id": "04cff67c-51e0-4516-9279-13349b9badfb",
      "name": "unverified append row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        496,
        320
      ]
    },
    {
      "id": "50964759-12c0-42e3-a38a-6a317293bfac",
      "name": "verified append row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        752,
        -32
      ]
    },
    {
      "id": "deaa6822-f6d6-42c4-a2cd-64698c77611b",
      "name": "Wait1",
      "type": "n8n-nodes-base.wait",
      "position": [
        768,
        320
      ]
    },
    {
      "id": "0c2f6847-5472-4f5a-9fa1-e63fca06e2c1",
      "name": "Format Webhook Response Data",
      "type": "n8n-nodes-base.code",
      "position": [
        -1296,
        128
      ]
    },
    {
      "id": "0f832810-51fd-408a-9b41-68c12d0aaf9d",
      "name": "Send Message Using Rapiwa",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        528,
        -32
      ]
    },
    {
      "id": "6a2c5979-109d-4e30-9c40-109aeef24632",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2656,
        -480
      ],
      "parameters": {
        "width": 944,
        "height": 3136,
        "content": "# WhatsApp Number Verify & Confirmation System with Rapiwa API and Google Sheets\n\n## Overview\n### This n8n workflow receives data from a submitted form, verifies if the provided WhatsApp number is val"
      }
    },
    {
      "id": "bf94c923-f333-4ea5-8cd1-82433fd9e92f",
      "name": "Check valid whatsapp number Using Rapiwa",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -416,
        144
      ]
    },
    {
      "id": "7b625fbd-b299-4183-bb65-85c8bfa020a1",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1664,
        -480
      ],
      "parameters": {
        "width": 544,
        "height": 816,
        "content": "## Trigger via Webhook\n\nA **Webhook** node listens for POST requests on the path:\n\n**Example input:**\n\n```json\n{\n  \"business_name\": \"ABC Corp\",\n  \"location\": \"New York\",\n  \"whatsapp\": \"+1 (234) 567-89"
      }
    },
    {
      "id": "c0e6db0e-ba2f-448e-a948-c6adb0d6301a",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        -480
      ],
      "parameters": {
        "width": 320,
        "height": 816,
        "content": "## Batch Processing\n\nThe **SplitInBatches** node:\n\n- Allows future scalability for handling multiple records.\n- Each item is processed individually.\n"
      }
    },
    {
      "id": "cacbf378-6483-42ac-a76a-ad221b657d37",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -736,
        -480
      ],
      "parameters": {
        "width": 560,
        "height": 816,
        "content": "## Clean WhatsApp Number\n\nThe **Clean Number** node:\n\n- Converts the number to a string.\n- Removes all non-digit characters.\n- Updates the number for API compatibility.\n\n## & Validate WhatsApp Number\n"
      }
    },
    {
      "id": "1e2ba823-daa4-4760-872e-f2565e8148d7",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        -480
      ],
      "parameters": {
        "width": 432,
        "height": 816,
        "content": "## Conditional Logic\n\nThe **If** node checks whether `data.exists == true`:\n\n- **True branch (verified):**\n  - Sends a WhatsApp confirmation via Rapiwa.\n  - Appends to Google Sheets with validity: ver"
      }
    },
    {
      "id": "7a599350-0eb0-4566-bd19-a3204d06e815",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        -480
      ],
      "parameters": {
        "width": 592,
        "height": 688,
        "content": "## Send WhatsApp Confirmation\n\nThe **Send Message Using Rapiwa** node sends this message to the user:\n\n\n## & Append Data to Google Sheets\nTwo separate Google Sheets nodes:\n- **Verified append row in s"
      }
    },
    {
      "id": "a31d310f-f7b6-48f9-9c5f-6fdfd30fae5d",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        240
      ],
      "parameters": {
        "width": 832,
        "height": 448,
        "content": "\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n## Append Unverified Row to Sheet\nThis node is triggered after a phone number is checked and found to be **unverified**. It appends the form submission data to the Google Sheet wi"
      }
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Send Message Using Rapiwa",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "unverified append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook": {
      "main": [
        [
          {
            "node": "Format Webhook Response Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Cleane Number": {
      "main": [
        [
          {
            "node": "Check valid whatsapp number Using Rapiwa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Cleane Number",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Message Using Rapiwa": {
      "main": [
        [
          {
            "node": "verified append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Webhook Response Data": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "verified append row in sheet": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "unverified append row in sheet": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check valid whatsapp number Using Rapiwa": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}