SpaGreen Creative This workflow corresponds to n8n.io template #9292 — 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": "TZh5DGrhbMLuufLR",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Shopify Auto Send WhatsApp Thank-You Messages & Loyalty Coupon Using Rapiwa API",
"tags": [],
"nodes": [
{
"id": "b520df6b-3acf-4fb0-929e-77446e6eaefc",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-448,
672
],
"parameters": {},
"typeVersion": 3
},
{
"id": "652b65b5-f5f0-4d15-99e4-41c0976ad8e2",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
224,
928
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f187821c-cd12-455f-b41e-91a851d62d78",
"name": "Clean WhatsApp Number",
"type": "n8n-nodes-base.code",
"position": [
-176,
800
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1f5eefb7-8c49-4f53-a621-1f6628856964",
"name": "Check valid whatsapp number Using Rapiwa",
"type": "n8n-nodes-base.httpRequest",
"position": [
16,
800
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "3700e098-7168-4752-99e8-1656d8689ab7",
"name": "Append Rows in Sheet Verified & Sent",
"type": "n8n-nodes-base.googleSheets",
"position": [
672,
800
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "1eda2f14-4088-4ced-9304-23868a0763e3",
"name": "Append Rows in Sheet Unverified & Not sent",
"type": "n8n-nodes-base.googleSheets",
"position": [
464,
1024
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "4e8f8880-393d-4148-a43a-6b45dedae0fd",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
704,
1024
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "e6b244a0-9082-4dd9-979d-123c76b3d2b4",
"name": "Send Message Using Rapiwa",
"type": "n8n-nodes-base.httpRequest",
"position": [
464,
800
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "c964d973-17c1-4da3-903c-2ce26d8074ea",
"name": "Get All Customer Data In Store",
"type": "n8n-nodes-base.httpRequest",
"position": [
-896,
608
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "30f9176f-6e91-4990-ac1b-fa8333ef09db",
"name": "Clean HTTP Request Data",
"type": "n8n-nodes-base.code",
"position": [
-672,
608
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7616b409-a957-4e18-9247-88b6e8181dfb",
"name": "Clicki",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1104,
608
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ffe3dd46-960c-42a1-90ea-5bc5b69ae8cb",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1248,
208
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fffcb6eb-2a09-4285-bbf7-a4530ef6949e",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-944,
208
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c75fac79-51eb-44f7-8bf5-13ddb622884f",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-528,
208
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "13e6b28d-ea71-42ba-a614-1e843dccbb2f",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-256,
208
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bb30d9ea-0826-4aaa-aa95-7d1e1be71a3c",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
176,
208
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "53d0c208-8d90-4503-8fd5-49057a65c93d",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2128,
208
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "cbabfc7c-e86f-4f5d-a3ab-3eee077691d4",
"connections": {
"If": {
"main": [
[
{
"node": "Send Message Using Rapiwa",
"type": "main",
"index": 0
}
],
[
{
"node": "Append Rows in Sheet Unverified & Not sent",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Clicki": {
"main": [
[
{
"node": "Get All Customer Data In Store",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Clean WhatsApp Number",
"type": "main",
"index": 0
}
]
]
},
"Clean WhatsApp Number": {
"main": [
[
{
"node": "Check valid whatsapp number Using Rapiwa",
"type": "main",
"index": 0
}
]
]
},
"Clean HTTP Request Data": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Send Message Using Rapiwa": {
"main": [
[
{
"node": "Append Rows in Sheet Verified & Sent",
"type": "main",
"index": 0
}
]
]
},
"Get All Customer Data In Store": {
"main": [
[
{
"node": "Clean HTTP Request Data",
"type": "main",
"index": 0
}
]
]
},
"Append Rows in Sheet Verified & Sent": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Check valid whatsapp number Using Rapiwa": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Append Rows in Sheet Unverified & Not sent": {
"main": [
[
{
"node": "Wait",
"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 Shopify store owners, marketers, and support teams who want to automatically message their high-value customers on WhatsApp when new discount codes are created. Fetches customer data from Shopify Filters customers where Cleans phone numbers (removes…
Source: https://n8n.io/workflows/9292/ — 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.
checkProcess(old). Uses googleSheets, httpRequest, telegram, @n-octo-n/n8n-nodes-json-database. Event-driven trigger; 40 nodes.
checkProcess. Uses googleSheets, httpRequest, telegram, @n-octo-n/n8n-nodes-json-database. Event-driven trigger; 40 nodes.
Transform your lead list into an AI-powered calling machine. This workflow automates your entire cold calling process using Vapi's conversational AI to initiate calls, qualify leads, capture detailed
Type in Slack. Walk away. Get a professional PDF report and a structured Excel fix sheet delivered to Google Drive and posted back in your Slack thread — fully automated, zero manual work.
This template monitors Google Drive folder for new files, extracts text from PDFs, images, text files, CSVs, and Google Docs., reads images with meta/llama-3.2-11b-vision-instruct, structures the resu