Rahi Uppal This workflow corresponds to n8n.io template #7064 — we link there as the canonical source.
This workflow follows the HTTP Request → Supabase 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 →
{
"nodes": [
{
"id": "6ec52292-4a05-46b5-82eb-765560b1dfe7",
"name": "Get many rows1",
"type": "n8n-nodes-base.supabase",
"position": [
-1080,
960
],
"parameters": {
"tableId": "contacts_ampere",
"operation": "getAll",
"returnAll": true,
"filterType": "none"
},
"credentials": {
"supabaseApi": {
"name": "<your credential>"
}
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "72553947-b418-4884-9eb6-1b73947892b1",
"name": "Switch2",
"type": "n8n-nodes-base.switch",
"position": [
-40,
1160
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fa84be36-be05-49c9-9328-7a311b067f1a",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 0
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "630a27f9-82f5-4fdc-90c5-d1f4f5554f8b",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 1
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b0bc9bf3-1215-4c79-871e-f588c5b22e82",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 2
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fa57ae02-ba8a-4479-990d-7f622263ad81",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 3
}
]
}
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "e0543edc-b6ba-4067-8b08-59b07e34f566",
"name": "Switch3",
"type": "n8n-nodes-base.switch",
"position": [
-60,
1400
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fa84be36-be05-49c9-9328-7a311b067f1a",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 0
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "630a27f9-82f5-4fdc-90c5-d1f4f5554f8b",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 1
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b0bc9bf3-1215-4c79-871e-f588c5b22e82",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 2
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fa57ae02-ba8a-4479-990d-7f622263ad81",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 3
}
]
}
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "a62b4cdd-8f2e-4b34-95b6-1889be9194bc",
"name": "Switch4",
"type": "n8n-nodes-base.switch",
"position": [
-40,
1580
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fa84be36-be05-49c9-9328-7a311b067f1a",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 0
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "630a27f9-82f5-4fdc-90c5-d1f4f5554f8b",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 1
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b0bc9bf3-1215-4c79-871e-f588c5b22e82",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 2
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fa57ae02-ba8a-4479-990d-7f622263ad81",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 3
}
]
}
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "e47cf7ed-0e09-49a5-8746-14c52185e3d5",
"name": "Switch5",
"type": "n8n-nodes-base.switch",
"position": [
-60,
1720
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fa84be36-be05-49c9-9328-7a311b067f1a",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 0
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "630a27f9-82f5-4fdc-90c5-d1f4f5554f8b",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 1
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b0bc9bf3-1215-4c79-871e-f588c5b22e82",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 2
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fa57ae02-ba8a-4479-990d-7f622263ad81",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 3
}
]
}
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "e692da70-6ab3-47e0-b30f-9579571ac13d",
"name": "Loop Over Items1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
0,
0
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "c1f44338-df6e-47b6-896c-00cca3ae83d0",
"name": "Schedule Trigger3",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1340,
960
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "9e664dac-592e-4087-b412-0c6f5a5c247c",
"name": "Create Logs",
"type": "n8n-nodes-base.supabase",
"onError": "continueRegularOutput",
"position": [
700,
20
],
"parameters": {
"tableId": "logs_nurture_ampere",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "message_id",
"fieldValue": "={{ $json.body.id }}"
},
{
"fieldId": "phone",
"fieldValue": "={{ $('Count Switch').item.json.phone }}"
},
{
"fieldId": "disposition",
"fieldValue": "={{ $('Count Switch').item.json.Disposition }}"
},
{
"fieldId": "mes_count",
"fieldValue": "={{ $('Count Switch').item.json.Count + 1}}"
},
{
"fieldId": "last_sent",
"fieldValue": "={{ $('Count Switch').item.json.last_message_sent }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.statusCode }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.statusMessage }}"
},
{
"fieldId": "name",
"fieldValue": "={{ $('Count Switch').item.json.name }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.error.status }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.error.message }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.statusCode }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.statusMessage }}"
}
]
}
},
"typeVersion": 1
},
{
"id": "f9bbae85-3938-4421-b7e6-a2b6c3fdfe8b",
"name": "new_lead_0",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
420,
20
],
"parameters": {
"url": "https://server.gallabox.com/devapi/messages/whatsapp",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"jsonBody": "=\n{\n \"channelId\": \"\",\n \"channelType\": \"whatsapp\",\n \"recipient\": {\n \"name\": \"{{ $json.name }}\",\n \"phone\": \"91{{ $json.phone }}\"\n },\n \"whatsapp\": {\n \"type\": \"template\",\n \"template\": {\n \"templateName\": \"testing_rahi_1\",\n \"bodyValues\": {\n \"Name\": \"{{ $json.name }}\",\n \"Details\": \"\"\n },\n \"buttonValues\": [\n {\n \"index\": 0,\n \"sub_type\": \"quick_reply\",\n \"parameters\": {\n \"type\": \"payload\",\n \"payload\": \"Show me Brochure\"\n }\n }\n ]\n }\n }\n}",
"sendBody": true,
"jsonHeaders": "write your api key and api secret ",
"sendHeaders": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"specifyHeaders": "json",
"genericAuthType": "httpCustomAuth"
},
"typeVersion": 4.1
},
{
"id": "09e6fe06-73d7-4781-8cb2-e295a28b7eeb",
"name": "Update a row1",
"type": "n8n-nodes-base.supabase",
"onError": "continueRegularOutput",
"position": [
1140,
20
],
"parameters": {
"filters": {
"conditions": [
{
"keyName": "phone",
"keyValue": "={{ $json.phone }}",
"condition": "eq"
}
]
},
"tableId": "contacts_ampere",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "Count",
"fieldValue": "={{ $('Loop Over Items1').item.json.Count + 1}}"
},
{
"fieldId": "last_message_sent",
"fieldValue": "={{ $('new_lead_0').item.json.headers.date }}"
}
]
},
"matchType": "allFilters",
"operation": "update"
},
"typeVersion": 1
},
{
"id": "fd387290-fffb-4230-99c4-05fed3e98db2",
"name": "Loop Over Items2",
"type": "n8n-nodes-base.splitInBatches",
"position": [
0,
260
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "ccf4ea81-c12a-4f21-996d-623278916342",
"name": "Create Logs1",
"type": "n8n-nodes-base.supabase",
"onError": "continueRegularOutput",
"position": [
640,
280
],
"parameters": {
"tableId": "logs_nurture_ampere",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "message_id",
"fieldValue": "={{ $json.body.id }}"
},
{
"fieldId": "phone",
"fieldValue": "={{ $('Count Switch').item.json.phone }}"
},
{
"fieldId": "disposition",
"fieldValue": "={{ $('Count Switch').item.json.Disposition }}"
},
{
"fieldId": "mes_count",
"fieldValue": "={{ $('Count Switch').item.json.Count + 1}}"
},
{
"fieldId": "last_sent",
"fieldValue": "={{ $('Count Switch').item.json.last_message_sent }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.statusCode }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.statusMessage }}"
},
{
"fieldId": "name",
"fieldValue": "={{ $('Count Switch').item.json.name }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.error.status }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.error.message }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.statusCode }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.statusMessage }}"
}
]
}
},
"typeVersion": 1
},
{
"id": "c6099d73-a727-48b4-a2df-bd07afc590c2",
"name": "Update a row2",
"type": "n8n-nodes-base.supabase",
"onError": "continueRegularOutput",
"position": [
1060,
280
],
"parameters": {
"filters": {
"conditions": [
{
"keyName": "phone",
"keyValue": "={{ $json.phone }}",
"condition": "eq"
}
]
},
"tableId": "contacts_ampere",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "Count",
"fieldValue": "={{ $('Loop Over Items2').item.json.Count + 1}}"
},
{
"fieldId": "last_message_sent",
"fieldValue": "={{ $('new_lead_').item.json.headers.date }}"
}
]
},
"matchType": "allFilters",
"operation": "update"
},
"typeVersion": 1
},
{
"id": "037e9f03-eb13-4334-b587-812a00c7161a",
"name": "Loop Over Items3",
"type": "n8n-nodes-base.splitInBatches",
"position": [
20,
560
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "d75db6e9-ec69-4a2c-b088-98c168126ee4",
"name": "Create Logs2",
"type": "n8n-nodes-base.supabase",
"onError": "continueRegularOutput",
"position": [
660,
560
],
"parameters": {
"tableId": "logs_nurture_ampere",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "message_id",
"fieldValue": "={{ $json.body.id }}"
},
{
"fieldId": "phone",
"fieldValue": "={{ $('Count Switch').item.json.phone }}"
},
{
"fieldId": "disposition",
"fieldValue": "={{ $('Count Switch').item.json.Disposition }}"
},
{
"fieldId": "mes_count",
"fieldValue": "={{ $('Count Switch').item.json.Count + 1}}"
},
{
"fieldId": "last_sent",
"fieldValue": "={{ $('Count Switch').item.json.last_message_sent }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.statusCode }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.statusMessage }}"
},
{
"fieldId": "name",
"fieldValue": "={{ $('Count Switch').item.json.name }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.error.status }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.error.message }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.statusCode }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.statusMessage }}"
}
]
}
},
"typeVersion": 1
},
{
"id": "f857408c-ad43-4e26-89a4-5ef6551465c9",
"name": "Update a row3",
"type": "n8n-nodes-base.supabase",
"onError": "continueRegularOutput",
"position": [
1080,
560
],
"parameters": {
"filters": {
"conditions": [
{
"keyName": "phone",
"keyValue": "={{ $json.phone }}",
"condition": "eq"
}
]
},
"tableId": "contacts_ampere",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "Count",
"fieldValue": "={{ $('Loop Over Items3').item.json.Count + 1}}"
},
{
"fieldId": "last_message_sent",
"fieldValue": "={{ $('new_lead_3').item.json.headers.date }}"
}
]
},
"matchType": "allFilters",
"operation": "update"
},
"typeVersion": 1
},
{
"id": "947a69eb-3ce3-4000-98e7-9a44bef47098",
"name": "Loop Over Items4",
"type": "n8n-nodes-base.splitInBatches",
"position": [
20,
800
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "de2a6bd1-9510-41cd-aff0-ba58e62759bb",
"name": "Create Logs3",
"type": "n8n-nodes-base.supabase",
"onError": "continueRegularOutput",
"position": [
660,
820
],
"parameters": {
"tableId": "logs_nurture_ampere",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "message_id",
"fieldValue": "={{ $json.body.id }}"
},
{
"fieldId": "phone",
"fieldValue": "={{ $('Count Switch').item.json.phone }}"
},
{
"fieldId": "disposition",
"fieldValue": "={{ $('Count Switch').item.json.Disposition }}"
},
{
"fieldId": "mes_count",
"fieldValue": "={{ $('Count Switch').item.json.Count + 1}}"
},
{
"fieldId": "last_sent",
"fieldValue": "={{ $('Count Switch').item.json.last_message_sent }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.statusCode }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.statusMessage }}"
},
{
"fieldId": "name",
"fieldValue": "={{ $('Count Switch').item.json.name }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.error.status }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.error.message }}"
},
{
"fieldId": "status_code",
"fieldValue": "={{ $json.statusCode }}"
},
{
"fieldId": "status_message",
"fieldValue": "={{ $json.statusMessage }}"
}
]
}
},
"credentials": {
"supabaseApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "29ee050e-d4f0-4b1a-8e57-3d9d80701114",
"name": "new_lead_2",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
480,
820
],
"parameters": {
"url": "https://server.gallabox.com/devapi/messages/whatsapp",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"jsonBody": "=\n{\n \"channelId\": \"\",\n \"channelType\": \"whatsapp\",\n \"recipient\": {\n \"name\": \"{{ $json.name }}\",\n \"phone\": \"91{{ $json.phone }}\"\n },\n \"whatsapp\": {\n \"type\": \"template\",\n \"template\": {\n \"templateName\": \"testing_rahi_1\",\n \"bodyValues\": {\n \"Name\": \"{{ $json.name }}\",\n \"Details\": \"\"\n },\n \"buttonValues\": [\n {\n \"index\": 0,\n \"sub_type\": \"quick_reply\",\n \"parameters\": {\n \"type\": \"payload\",\n \"payload\": \"Show me Brochure\"\n }\n }\n ]\n }\n }\n}",
"sendBody": true,
"jsonHeaders": "api key and secret key",
"sendHeaders": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"specifyHeaders": "json",
"genericAuthType": "httpCustomAuth"
},
"typeVersion": 4.1
},
{
"id": "b2468e08-6c41-45e7-808d-7268fec9383c",
"name": "Update a row4",
"type": "n8n-nodes-base.supabase",
"onError": "continueRegularOutput",
"position": [
1080,
820
],
"parameters": {
"filters": {
"conditions": [
{
"keyName": "phone",
"keyValue": "={{ $json.phone }}",
"condition": "eq"
}
]
},
"tableId": "contacts_ampere",
"fieldsUi": {
"fieldValues": [
{
"fieldId": "Count",
"fieldValue": "={{ $('Loop Over Items4').item.json.Count + 1}}"
},
{
"fieldId": "last_message_sent",
"fieldValue": "={{ $('new_lead_2').item.json.headers.date }}"
}
]
},
"matchType": "allFilters",
"operation": "update"
},
"credentials": {
"supabaseApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "1b0112e4-79c2-439c-a1dd-4c75f74abca7",
"name": "If StatusCode 202",
"type": "n8n-nodes-base.if",
"onError": "continueRegularOutput",
"position": [
860,
280
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "27a6fdac-1795-408c-92aa-4e452760a6fb",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status_code }}",
"rightValue": "202"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "4b710624-6f6f-4237-a17b-373eb7415a2c",
"name": "If StatusCode ",
"type": "n8n-nodes-base.if",
"onError": "continueRegularOutput",
"position": [
900,
20
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "27a6fdac-1795-408c-92aa-4e452760a6fb",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status_code }}",
"rightValue": "202"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "e6131966-9dc3-4e51-974f-d6aa37d08f8b",
"name": "If StatusCode 203",
"type": "n8n-nodes-base.if",
"onError": "continueRegularOutput",
"position": [
880,
560
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "27a6fdac-1795-408c-92aa-4e452760a6fb",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status_code }}",
"rightValue": "202"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "99d7bb37-eae9-4b9d-a79e-589e67e70c7b",
"name": "If StatusCode 204",
"type": "n8n-nodes-base.if",
"onError": "continueRegularOutput",
"position": [
880,
820
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "27a6fdac-1795-408c-92aa-4e452760a6fb",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status_code }}",
"rightValue": "202"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "1e108abd-0ebd-4f52-bca4-15ad2a4774cb",
"name": "If Interval",
"type": "n8n-nodes-base.if",
"onError": "continueRegularOutput",
"position": [
240,
280
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "95ba014b-f5e5-4099-b3a2-e11e032a211d",
"operator": {
"type": "number",
"operation": "gte"
},
"leftValue": "={{ $json.interval }}",
"rightValue": 0
}
]
}
},
"typeVersion": 2.2
},
{
"id": "be030bf2-f353-4e55-9107-c9c5dee53a73",
"name": "If Interval1",
"type": "n8n-nodes-base.if",
"onError": "continueRegularOutput",
"position": [
240,
580
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "afddef19-139e-4b73-93d9-1f5b2f6b5fce",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.interval }}",
"rightValue": 24
}
]
}
},
"typeVersion": 2.2
},
{
"id": "e369d33b-f9fd-496a-948d-c1a1b5b22145",
"name": "If2",
"type": "n8n-nodes-base.if",
"position": [
240,
840
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b24fa0b1-90e4-40a0-bf96-665231f0b653",
"operator": {
"type": "number",
"operation": "gte"
},
"leftValue": "={{ $json.interval }}",
"rightValue": 24
}
]
}
},
"typeVersion": 2.2
},
{
"id": "db8e9ab0-d329-4255-82d2-18ec5b1319e2",
"name": "Disposition Switch",
"type": "n8n-nodes-base.switch",
"position": [
-820,
900
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8aa7a00f-b0d2-40f5-a634-bd622a69773b",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Disposition }}",
"rightValue": "=new_lead"
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "79fda541-c45c-4cc4-b7e0-1a4defac93bf",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Disposition }}",
"rightValue": "test_ride"
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e552fd1c-27e5-460a-a8e2-805cbad62ddf",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Disposition }}",
"rightValue": "Booking"
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fdbafaa7-10bf-477f-a9a0-c35437d24095",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Disposition }}",
"rightValue": "walk_in"
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "259f1095-d92f-4b69-a8c1-32db69cfcfe2",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Disposition }}",
"rightValue": "Sale"
}
]
}
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "db51db6d-6e18-4939-88a6-52647efb20a7",
"name": "Count Switch",
"type": "n8n-nodes-base.switch",
"position": [
-300,
500
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fa84be36-be05-49c9-9328-7a311b067f1a",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 0
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "630a27f9-82f5-4fdc-90c5-d1f4f5554f8b",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 1
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b0bc9bf3-1215-4c79-871e-f588c5b22e82",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 2
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "fa57ae02-ba8a-4479-990d-7f622263ad81",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.Count }}",
"rightValue": 3
}
]
}
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "25c332c8-5be5-4475-9301-bd748c6326e5",
"name": "new_lead_",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
480,
280
],
"parameters": {
"url": "https://server.gallabox.com/devapi/messages/whatsapp",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"jsonBody": "=\n{\n \"channelId\": \"\",\n \"channelType\": \"whatsapp\",\n \"recipient\": {\n \"name\": \"{{ $json.name }}\",\n \"phone\": \"91{{ $json.phone }}\"\n },\n \"whatsapp\": {\n \"type\": \"template\",\n \"template\": {\n \"templateName\": \"testing_rahi_1\",\n \"bodyValues\": {\n \"Name\": \"{{ $json.name }}\",\n \"Details\": \"\"\n },\n \"buttonValues\": [\n {\n \"index\": 0,\n \"sub_type\": \"quick_reply\",\n \"parameters\": {\n \"type\": \"payload\",\n \"payload\": \"Show me Brochure\"\n }\n }\n ]\n }\n }\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"specifyHeaders": "json",
"genericAuthType": "httpCustomAuth"
},
"typeVersion": 4.1
},
{
"id": "a7bb131a-62cd-434c-9f2f-85ccecfd311c",
"name": "new_lead_3",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
460,
560
],
"parameters": {
"url": "https://server.gallabox.com/devapi/messages/whatsapp",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"jsonBody": "=\n{\n \"channelId\": \"\",\n \"channelType\": \"whatsapp\",\n \"recipient\": {\n \"name\": \"{{ $json.name }}\",\n \"phone\": \"91{{ $json.phone }}\"\n },\n \"whatsapp\": {\n \"type\": \"template\",\n \"template\": {\n \"templateName\": \"testing_rahi_1\",\n \"bodyValues\": {\n \"Name\": \"{{ $json.name }}\",\n \"Details\": \"\"\n },\n \"buttonValues\": [\n {\n \"index\": 0,\n \"sub_type\": \"quick_reply\",\n \"parameters\": {\n \"type\": \"payload\",\n \"payload\": \"Show me Brochure\"\n }\n }\n ]\n }\n }\n}",
"sendBody": true,
"jsonHeaders": "api key and api secret key",
"sendHeaders": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"specifyHeaders": "json",
"genericAuthType": "httpCustomAuth"
},
"typeVersion": 4.1
},
{
"id": "4277f565-b4fa-4c4b-8d8a-9cb43565defc",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-200
],
"parameters": {
"width": 150,
"content": "Http request if of gallabox api, that will help you to send whatsapp messages"
},
"typeVersion": 1
},
{
"id": "257a9216-8163-4c33-bd28-78b0625e319a",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-340,
280
],
"parameters": {
"width": 150,
"content": "This switch decides which drip to send means which message drip in sequence"
},
"typeVersion": 1
},
{
"id": "bc5fd705-a878-42b9-875a-1a104d01570a",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-860,
720
],
"parameters": {
"width": 150,
"content": "This Tells you about th e disposition/stage that you want to target"
},
"typeVersion": 1
}
],
"connections": {
"If2": {
"main": [
[
{
"node": "new_lead_2",
"type": "main",
"index": 0
}
]
]
},
"new_lead_": {
"main": [
[
{
"node": "Create Logs1",
"type": "main",
"index": 0
}
]
]
},
"new_lead_0": {
"main": [
[
{
"node": "Create Logs",
"type": "main",
"index": 0
}
]
]
},
"new_lead_2": {
"main": [
[
{
"node": "Create Logs3",
"type": "main",
"index": 0
}
]
]
},
"new_lead_3": {
"main": [
[
{
"node": "Create Logs2",
"type": "main",
"index": 0
}
]
]
},
"Create Logs": {
"main": [
[
{
"node": "If StatusCode ",
"type": "main",
"index": 0
}
]
]
},
"If Interval": {
"main": [
[
{
"node": "new_lead_",
"type": "main",
"index": 0
}
]
]
},
"Count Switch": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items2",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items3",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
]
]
},
"Create Logs1": {
"main": [
[
{
"node": "If StatusCode 202",
"type": "main",
"index": 0
}
]
]
},
"Create Logs2": {
"main": [
[
{
"node": "If StatusCode 203",
"type": "main",
"index": 0
}
]
]
},
"Create Logs3": {
"main": [
[
{
"node": "If StatusCode 204",
"type": "main",
"index": 0
}
]
]
},
"If Interval1": {
"main": [
[
{
"node": "new_lead_3",
"type": "main",
"index": 0
}
]
]
},
"Update a row1": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Update a row2": {
"main": [
[
{
"node": "Loop Over Items2",
"type": "main",
"index": 0
}
]
]
},
"Update a row3": {
"main": [
[
{
"node": "Loop Over Items3",
"type": "main",
"index": 0
}
]
]
},
"Update a row4": {
"main": [
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
]
]
},
"Get many rows1": {
"main": [
[
{
"node": "Disposition Switch",
"type": "main",
"index": 0
}
]
]
},
"If StatusCode ": {
"main": [
[
{
"node": "Update a row1",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[],
[
{
"node": "new_lead_0",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items2": {
"main": [
[],
[
{
"node": "If Interval",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items3": {
"main": [
[],
[
{
"node": "If Interval1",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items4": {
"main": [
[],
[
{
"node": "If2",
"type": "main",
"index": 0
}
]
]
},
"If StatusCode 202": {
"main": [
[
{
"node": "Update a row2",
"type": "main",
"index": 0
}
]
]
},
"If StatusCode 203": {
"main": [
[
{
"node": "Update a row3",
"type": "main",
"index": 0
}
]
]
},
"If StatusCode 204": {
"main": [
[
{
"node": "Update a row4",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger3": {
"main": [
[
{
"node": "Get many rows1",
"type": "main",
"index": 0
}
]
]
},
"Disposition Switch": {
"main": [
[
{
"node": "Count Switch",
"type": "main",
"index": 0
}
],
[
{
"node": "Switch2",
"type": "main",
"index": 0
}
],
[
{
"node": "Switch3",
"type": "main",
"index": 0
}
],
[
{
"node": "Switch4",
"type": "main",
"index": 0
}
],
[
{
"node": "Switch5",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
supabaseApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
WABA Message Journey Flow Documentation This document outlines the automated workflow for sending WhatsApp messages to contacts, triggered hourly and managed through disposition and message count logic. The workflow is designed to ensure contacts receive messages based on their…
Source: https://n8n.io/workflows/7064/ — 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.
Workflow A — WhatsApp Lead Intake & Qualification. Uses postgres, httpRequest, errorTrigger. Scheduled trigger; 67 nodes.
Postgres, HTTP Request, Error Trigger
Build authentic Reddit presence and generate qualified leads through AI-powered community engagement that provides genuine value without spam or promotion.
HTTP Request, Reddit
This workflow runs on scheduled weekly and monthly triggers to generate unified marketing performance reports. It processes multiple websites by collecting analytics data, paid ads performance, and CR
Gmail, Google Sheets, Google Analytics +3
Fetch Multiple Google Analytics GA4 metrics daily, post to Discord, update previous day’s entry as GA data finalizes over seven days. Automates daily traffic reporting Maintains single message per day
Google Analytics, Discord, HTTP Request
Goal: Get Reddit posts from specific subreddits, filter those mentioning freelance/gigs and n8n, extract top-level comments, remove mod replies, and store everything into Google Sheets.
HTTP Request, Reddit, Google Sheets