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.
Deal-Finder. Uses executeWorkflowTrigger, googleSheets, perplexity, httpRequest. Event-driven trigger; 49 nodes.
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.
This workflow collects a blog brief via an n8n form, uses Anthropic Claude to generate an outline and write each section, saves both outline and article as formatted Google Docs in Google Drive, then
This workflow runs a SEEK.com.au job search via Apify on a daily schedule or on-demand form submission, deduplicates new listings, and routes results to Google Sheets, Airtable, a webhook endpoint, an