SpaGreen Creative This workflow corresponds to n8n.io template #8555 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request 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 →
{
"id": "jYSZTY25ziYwwCJF",
"name": "WhatsApp Bulk Number Verification in Google Sheets Using Unofficial Rapiwa API",
"tags": [],
"nodes": [
{
"id": "0bd3256d-9adc-4d66-a169-4cefb200429b",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1856,
560
],
"parameters": {},
"executeOnce": false,
"typeVersion": 3
},
{
"id": "af2e3fcb-4a5c-4111-b003-1a6c7b73127d",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
3776,
576
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "e1f2641c-fb40-42df-b7a7-4e1244ec47c4",
"name": "Limit",
"type": "n8n-nodes-base.limit",
"position": [
1504,
560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3f96c826-8cef-44ed-a7eb-969091b1e67d",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "40db67ed-2517-48c3-8c30-625d5327977e",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
2672,
464
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "31ebd467-6231-4613-b2d0-cebc12bce6f5",
"name": "Fetch All Pending Contacts for Verifing",
"type": "n8n-nodes-base.googleSheets",
"position": [
1280,
560
],
"parameters": {},
"notesInFlow": false,
"retryOnFail": false,
"typeVersion": 4.6
},
{
"id": "3c05f88c-b4aa-47f8-99b7-ef7b99569df9",
"name": "Change State of Rows in Checked",
"type": "n8n-nodes-base.googleSheets",
"position": [
3472,
480
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "a1068fdc-52d1-4303-9abe-0bc19a6c6cea",
"name": "Set Status Verified",
"type": "n8n-nodes-base.code",
"position": [
3056,
384
],
"parameters": {},
"typeVersion": 2
},
{
"id": "87ce468d-670a-488e-911e-0202146b8959",
"name": "Set Status Unverified",
"type": "n8n-nodes-base.code",
"position": [
3056,
576
],
"parameters": {},
"typeVersion": 2
},
{
"id": "90480647-7d8c-427d-a53b-7e9a6e0ddcb0",
"name": "Clean WhatsApp Number",
"type": "n8n-nodes-base.code",
"position": [
2144,
480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "abde1a8c-9505-4ad0-a31f-1b85938abcee",
"name": "Verify WhatsApp Number Using Rapiwa",
"type": "n8n-nodes-base.httpRequest",
"position": [
2368,
480
],
"parameters": {},
"executeOnce": false,
"typeVersion": 4.2
},
{
"id": "6d75fb8a-4d5a-4e5f-8967-2cbe2b9a7a9f",
"name": "Trigger Every 10 Minute",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
944,
560
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "61e401e3-7b43-45de-9eed-bf5850d84159",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
736,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2ba45f56-e064-4995-b064-dbc51eb61ecb",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1168,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "dc3e5c48-ad64-4872-97af-5f195a279b9c",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2048,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1b5e6c32-baf7-468a-9a46-d8c2c3d94e77",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1712,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f512bef9-a564-46c6-9736-455ff03edcbe",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2624,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "45d902d9-8d53-4cd4-868b-cc4ed6842011",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
3360,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "25dd2565-5d97-4656-998e-fa8d57051e48",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
3712,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "e20888ed-0c6c-4156-8f2f-c35fac335983",
"connections": {
"If": {
"main": [
[
{
"node": "Set Status Verified",
"type": "main",
"index": 0
}
],
[
{
"node": "Set Status Unverified",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Clean WhatsApp Number",
"type": "main",
"index": 0
}
]
]
},
"Set Status Verified": {
"main": [
[
{
"node": "Change State of Rows in Checked",
"type": "main",
"index": 0
}
]
]
},
"Clean WhatsApp Number": {
"main": [
[
{
"node": "Verify WhatsApp Number Using Rapiwa",
"type": "main",
"index": 0
}
]
]
},
"Set Status Unverified": {
"main": [
[
{
"node": "Change State of Rows in Checked",
"type": "main",
"index": 0
}
]
]
},
"Trigger Every 10 Minute": {
"main": [
[
{
"node": "Fetch All Pending Contacts for Verifing",
"type": "main",
"index": 0
}
]
]
},
"Change State of Rows in Checked": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Verify WhatsApp Number Using Rapiwa": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Fetch All Pending Contacts for Verifing": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow is for marketers, small business owners, freelancers, and support teams who want to automate WhatsApp messaging using a Google Sheet without the official WhatsApp Business API. It’s suitable when you need a budget-friendly, easy-to-maintain solution that uses your…
Source: https://n8n.io/workflows/8555/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Elevate your shopping experience with an AI-driven personal assistant that lives right in your WhatsApp. This template automates the entire lifecycle of a shopping list—from intelligent intake and liv
This workflow automates plant care reminders and records using Google Sheets, Telegram, and OpenWeather API.
Apollo Data Enrichment Using Company Id to automatically finds contacts for companies listed in your Google Sheet, enriches each person with emails and phone numbers via Apollo’s API, and writes verif
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generat