Gallabox APIとSupabaseを使ったWhatsAppリードをダイジェストマーケティング
上級
これはLead Nurturing分野の自動化ワークフローで、34個のノードを含みます。主にIf, Switch, Supabase, HttpRequest, SplitInBatchesなどのノードを使用。 Gallabox APIとSupabaseを使った自動化された週次WhatsAppリード育成
前提条件
- •Supabase URL と API Key
- •ターゲットAPIの認証情報が必要な場合あり
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "807c58b937f3c75f8b242bc4ac5f455a51832cabd7bcdbecd9fdc3ba6179a8c9"
},
"nodes": [
{
"id": "6ec52292-4a05-46b5-82eb-765560b1dfe7",
"name": "複数行取得1",
"type": "n8n-nodes-base.supabase",
"position": [
-1080,
960
],
"parameters": {
"tableId": "contacts_ampere",
"operation": "getAll",
"returnAll": true,
"filterType": "none"
},
"credentials": {
"supabaseApi": {
"id": "pZQPqhLMUOZIjUsR",
"name": "Supabase account"
}
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "72553947-b418-4884-9eb6-1b73947892b1",
"name": "分岐2",
"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": "分岐3",
"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": "分岐4",
"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": "分岐5",
"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": "アイテムループ1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
0,
0
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "c1f44338-df6e-47b6-896c-00cca3ae83d0",
"name": "スケジュールトリガー3",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1340,
960
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "9e664dac-592e-4087-b412-0c6f5a5c247c",
"name": "ログ作成",
"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": "行更新1",
"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": "アイテムループ2",
"type": "n8n-nodes-base.splitInBatches",
"position": [
0,
260
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "ccf4ea81-c12a-4f21-996d-623278916342",
"name": "ログ作成1",
"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": "行更新2",
"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": "アイテムループ3",
"type": "n8n-nodes-base.splitInBatches",
"position": [
20,
560
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "d75db6e9-ec69-4a2c-b088-98c168126ee4",
"name": "ログ作成2",
"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": "行更新3",
"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": "アイテムループ4",
"type": "n8n-nodes-base.splitInBatches",
"position": [
20,
800
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "de2a6bd1-9510-41cd-aff0-ba58e62759bb",
"name": "ログ作成3",
"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": {
"id": "pZQPqhLMUOZIjUsR",
"name": "Supabase account"
}
},
"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": "行更新4",
"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": {
"id": "pZQPqhLMUOZIjUsR",
"name": "Supabase account"
}
},
"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": "付箋",
"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": "付箋1",
"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": "付箋2",
"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
}
],
"pinData": {},
"connections": {
"e369d33b-f9fd-496a-948d-c1a1b5b22145": {
"main": [
[
{
"node": "29ee050e-d4f0-4b1a-8e57-3d9d80701114",
"type": "main",
"index": 0
}
]
]
},
"25c332c8-5be5-4475-9301-bd748c6326e5": {
"main": [
[
{
"node": "ccf4ea81-c12a-4f21-996d-623278916342",
"type": "main",
"index": 0
}
]
]
},
"f9bbae85-3938-4421-b7e6-a2b6c3fdfe8b": {
"main": [
[
{
"node": "9e664dac-592e-4087-b412-0c6f5a5c247c",
"type": "main",
"index": 0
}
]
]
},
"29ee050e-d4f0-4b1a-8e57-3d9d80701114": {
"main": [
[
{
"node": "de2a6bd1-9510-41cd-aff0-ba58e62759bb",
"type": "main",
"index": 0
}
]
]
},
"a7bb131a-62cd-434c-9f2f-85ccecfd311c": {
"main": [
[
{
"node": "d75db6e9-ec69-4a2c-b088-98c168126ee4",
"type": "main",
"index": 0
}
]
]
},
"9e664dac-592e-4087-b412-0c6f5a5c247c": {
"main": [
[
{
"node": "4b710624-6f6f-4237-a17b-373eb7415a2c",
"type": "main",
"index": 0
}
]
]
},
"1e108abd-0ebd-4f52-bca4-15ad2a4774cb": {
"main": [
[
{
"node": "25c332c8-5be5-4475-9301-bd748c6326e5",
"type": "main",
"index": 0
}
]
]
},
"db51db6d-6e18-4939-88a6-52647efb20a7": {
"main": [
[
{
"node": "e692da70-6ab3-47e0-b30f-9579571ac13d",
"type": "main",
"index": 0
}
],
[
{
"node": "fd387290-fffb-4230-99c4-05fed3e98db2",
"type": "main",
"index": 0
}
],
[
{
"node": "037e9f03-eb13-4334-b587-812a00c7161a",
"type": "main",
"index": 0
}
],
[
{
"node": "947a69eb-3ce3-4000-98e7-9a44bef47098",
"type": "main",
"index": 0
}
]
]
},
"ccf4ea81-c12a-4f21-996d-623278916342": {
"main": [
[
{
"node": "1b0112e4-79c2-439c-a1dd-4c75f74abca7",
"type": "main",
"index": 0
}
]
]
},
"d75db6e9-ec69-4a2c-b088-98c168126ee4": {
"main": [
[
{
"node": "e6131966-9dc3-4e51-974f-d6aa37d08f8b",
"type": "main",
"index": 0
}
]
]
},
"de2a6bd1-9510-41cd-aff0-ba58e62759bb": {
"main": [
[
{
"node": "99d7bb37-eae9-4b9d-a79e-589e67e70c7b",
"type": "main",
"index": 0
}
]
]
},
"be030bf2-f353-4e55-9107-c9c5dee53a73": {
"main": [
[
{
"node": "a7bb131a-62cd-434c-9f2f-85ccecfd311c",
"type": "main",
"index": 0
}
]
]
},
"09e6fe06-73d7-4781-8cb2-e295a28b7eeb": {
"main": [
[
{
"node": "e692da70-6ab3-47e0-b30f-9579571ac13d",
"type": "main",
"index": 0
}
]
]
},
"c6099d73-a727-48b4-a2df-bd07afc590c2": {
"main": [
[
{
"node": "fd387290-fffb-4230-99c4-05fed3e98db2",
"type": "main",
"index": 0
}
]
]
},
"f857408c-ad43-4e26-89a4-5ef6551465c9": {
"main": [
[
{
"node": "037e9f03-eb13-4334-b587-812a00c7161a",
"type": "main",
"index": 0
}
]
]
},
"b2468e08-6c41-45e7-808d-7268fec9383c": {
"main": [
[
{
"node": "947a69eb-3ce3-4000-98e7-9a44bef47098",
"type": "main",
"index": 0
}
]
]
},
"6ec52292-4a05-46b5-82eb-765560b1dfe7": {
"main": [
[
{
"node": "db8e9ab0-d329-4255-82d2-18ec5b1319e2",
"type": "main",
"index": 0
}
]
]
},
"4b710624-6f6f-4237-a17b-373eb7415a2c": {
"main": [
[
{
"node": "09e6fe06-73d7-4781-8cb2-e295a28b7eeb",
"type": "main",
"index": 0
}
]
]
},
"e692da70-6ab3-47e0-b30f-9579571ac13d": {
"main": [
[],
[
{
"node": "f9bbae85-3938-4421-b7e6-a2b6c3fdfe8b",
"type": "main",
"index": 0
}
]
]
},
"fd387290-fffb-4230-99c4-05fed3e98db2": {
"main": [
[],
[
{
"node": "1e108abd-0ebd-4f52-bca4-15ad2a4774cb",
"type": "main",
"index": 0
}
]
]
},
"037e9f03-eb13-4334-b587-812a00c7161a": {
"main": [
[],
[
{
"node": "be030bf2-f353-4e55-9107-c9c5dee53a73",
"type": "main",
"index": 0
}
]
]
},
"947a69eb-3ce3-4000-98e7-9a44bef47098": {
"main": [
[],
[
{
"node": "e369d33b-f9fd-496a-948d-c1a1b5b22145",
"type": "main",
"index": 0
}
]
]
},
"1b0112e4-79c2-439c-a1dd-4c75f74abca7": {
"main": [
[
{
"node": "c6099d73-a727-48b4-a2df-bd07afc590c2",
"type": "main",
"index": 0
}
]
]
},
"e6131966-9dc3-4e51-974f-d6aa37d08f8b": {
"main": [
[
{
"node": "f857408c-ad43-4e26-89a4-5ef6551465c9",
"type": "main",
"index": 0
}
]
]
},
"99d7bb37-eae9-4b9d-a79e-589e67e70c7b": {
"main": [
[
{
"node": "b2468e08-6c41-45e7-808d-7268fec9383c",
"type": "main",
"index": 0
}
]
]
},
"c1f44338-df6e-47b6-896c-00cca3ae83d0": {
"main": [
[
{
"node": "6ec52292-4a05-46b5-82eb-765560b1dfe7",
"type": "main",
"index": 0
}
]
]
},
"db8e9ab0-d329-4255-82d2-18ec5b1319e2": {
"main": [
[
{
"node": "db51db6d-6e18-4939-88a6-52647efb20a7",
"type": "main",
"index": 0
}
],
[
{
"node": "72553947-b418-4884-9eb6-1b73947892b1",
"type": "main",
"index": 0
}
],
[
{
"node": "e0543edc-b6ba-4067-8b08-59b07e34f566",
"type": "main",
"index": 0
}
],
[
{
"node": "a62b4cdd-8f2e-4b34-95b6-1889be9194bc",
"type": "main",
"index": 0
}
],
[
{
"node": "e47cf7ed-0e09-49a5-8746-14c52185e3d5",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は?
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか?
上級 - リードナーチャリング
有料ですか?
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。
関連ワークフロー
PostgresとGallaboxを使って、個別メッセージを自動送信するWhatsAppリードのダイジェストマーケティング
PostgresとGallaboxを使った自動化されたWhatsAppリード個別メッセージング
Code
Postgres
Http Request
+
Code
Postgres
Http Request
11 ノードRahi
リードナーチャリング
GPT-4駆動のカールドメールワークフロー(完全カスタマイズされた3本のメールフォロー付き)
GPT-4、Mailgun、Supabaseを使ってパーソナライズされたラグディ冷信Seriesを自動化
If
Set
Code
+
If
Set
Code
100 ノードPaul
リードナーチャリング
Apollo.io かつ Google スプレッドシートを使用した LinkedIn のリード豊富化パイプラインの自動化
Apollo.ioとGoogleスプレッドシートを使用した自動LinkedInリード豊富化パイプライン
If
Code
Wait
+
If
Code
Wait
33 ノードRahi Uppal
リード獲得
Airtable、OpenAI、Unipile を使用した LinkedIn リード生成と自動ダイレクトメッセージングの自動化
Airtable、OpenAI、Unipileを使用した自動LinkedInリード生成とInMail投稿
If
Set
Code
+
If
Set
Code
143 ノードRuben AI
リードナーチャリング
AI駆動型マルチチャネルリードリーチシステム - JotForm、Gemini AI、HeyReach
JotForm、Gemini AI、HeyReachを基盤としたAI駆動型マルチチャネルリードリーチシステム
If
Wait
Gmail
+
If
Wait
Gmail
19 ノードRahi Uppal
リードナーチャリング
ペットショップ 4
ペットショップ予約AIエージェント
If
Set
Code
+
If
Set
Code
187 ノードBruno Dias
人工知能