{ "name": "Send WooCommerce cross-sell offers to customers via WhatsApp using Rapiwa API", "nodes": [ { "id": "3aa7faa0-03bf-4c72-a367-814e04c7364b", "name": "Get many customers", "type": "n8n-nodes-base.wooCommerce", "position": [ 224, 624 ] }, { "id": "c6727ef0-e304-4dfb-a5e4-8ce05b0c0292", "name": "Schedule Trigger", "type": "n8n-nodes-base.scheduleTrigger", "position": [ -64, 624 ] }, { "id": "b7688e2b-954b-4aa0-839c-16a6ae6242bc", "name": "Loop Over Items", "type": "n8n-nodes-base.splitInBatches", "position": [ 720, 624 ] }, { "id": "574cdebf-bedc-40c3-9bf1-fe63777703fa", "name": "If", "type": "n8n-nodes-base.if", "position": [ 3280, 640 ] }, { "id": "8c573bbd-192d-4db0-a59a-27bcd642d45f", "name": "Code (get paying_customer)", "type": "n8n-nodes-base.code", "position": [ 464, 624 ] }, { "id": "06fb86fe-e45e-4037-aa2c-988b6c181e0d", "name": "Code (clean data)", "type": "n8n-nodes-base.code", "position": [ 2048, 640 ] }, { "id": "b37e5fb1-8359-419a-a8d9-0030ec6ba007", "name": "Wait", "type": "n8n-nodes-base.wait", "position": [ 3776, 736 ] }, { "id": "66f15998-30e3-4469-9850-17479d133d14", "name": "get customer data", "type": "n8n-nodes-base.httpRequest", "position": [ 1024, 640 ] }, { "id": "12bbeaa6-64c2-45dc-a964-cb10763c0952", "name": "get specific product data", "type": "n8n-nodes-base.httpRequest", "position": [ 1760, 640 ] }, { "id": "346fb83b-2e7c-4d4c-a20c-e03225f367e7", "name": "get specific product recommend latest product", "type": "n8n-nodes-base.httpRequest", "position": [ 2416, 640 ] }, { "id": "335b6260-c039-4e9e-b8f2-5a25d954972a", "name": "get most buy product id & Clear Number", "type": "n8n-nodes-base.code", "position": [ 1296, 640 ] }, { "id": "dccbbc8e-1618-4e4b-b3aa-8395883ad5e2", "name": "Save State of Rows in Verified & Sent", "type": "n8n-nodes-base.googleSheets", "position": [ 3776, 512 ] }, { "id": "b8b8e6e2-d28a-4e7c-a55c-8df6ca64c4d5", "name": "Save State of Rows in Unerified & Not sent", "type": "n8n-nodes-base.googleSheets", "position": [ 3568, 736 ] }, { "id": "773f0d84-2270-4714-854e-1bfc236c2a5c", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [ -1392, 432 ], "parameters": { "width": 1168, "height": 1696, "content": "# Send WooCommerce Cross-Sell Offers to Customers via WhatsApp Using Rapiwa API\n\n## Overview\nThis n8n workflow enables **automated cross-selling** by identifying each **WooCommerce customer's** most f" } }, { "id": "0a51cbe3-e0c7-4c4a-b65b-d5536900194a", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [ 144, 272 ], "parameters": { "width": 528, "height": 688, "content": "## Get Many Customers\n**Purpose:** Retrieves all customer records from WooCommerce \n**How it works:** \n- Fetches complete customer dataset including purchase history \n**Output:** Raw customer data " } }, { "id": "91a455c8-9ad2-4390-a750-40c92683a8b3", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [ -160, 432 ], "parameters": { "width": 288, "height": 368, "content": "## Schedule Trigger\n**Purpose:** Initiates the workflow at specified intervals \n**How it works:** \n- Configured with time-based triggers (e.g., daily, weekly) \n" } }, { "id": "6ffff150-fd0e-400e-9f4f-878c23d4fc7b", "name": "Sticky Note4", "type": "n8n-nodes-base.stickyNote", "position": [ 864, 192 ], "parameters": { "width": 688, "height": 768, "content": "## Get Customer Data\n**Purpose:** Retrieves detailed order history for each customer \n**How it works:** \n- Makes API call to WooCommerce with customer ID \n- Fetches all orders associated with the c" } }, { "id": "2b4ce264-bcb6-4554-9f7a-3b90af6e407c", "name": "Sticky Note5", "type": "n8n-nodes-base.stickyNote", "position": [ 1568, 208 ], "parameters": { "width": 720, "height": 752, "content": "## Get Specific Product Data\n**Purpose:** Retrieves detailed information about the most purchased product \n**How it works:** \n- Makes an API call to WooCommerce using the product ID \n- Fetches prod" } }, { "id": "5834724b-c8eb-4c1b-9d27-8895be551bf2", "name": "Sticky Note6", "type": "n8n-nodes-base.stickyNote", "position": [ 2304, 272 ], "parameters": { "width": 448, "height": 688, "content": "## Get Specific Product Recommend Latest Product\n**Purpose:** Finds the latest product in the same category as customer's favorite\n**How it works:**\n- Makes API call to WooCommerce with category ID\n\n*" } }, { "id": "60d68dcd-39f4-4df9-9f90-1aa7f2451b87", "name": "Sticky Note7", "type": "n8n-nodes-base.stickyNote", "position": [ 2768, 416 ], "parameters": { "width": 384, "height": 544, "content": "## Check Valid WhatsApp Number Using Rapiwa\n**Purpose:** Verifies if customer's phone number is registered on WhatsApp\n**How it works:**\n- Sends POST request to Rapiwa verification endpoint\n- Uses Bea" } }, { "id": "3900ad3e-04c4-4e08-87ba-15588d3308df", "name": "Sticky Note8", "type": "n8n-nodes-base.stickyNote", "position": [ 3168, -48 ], "parameters": { "width": 784, "height": 1008, "content": "### If (Decision Node)\n**Purpose:** Routes workflow based on WhatsApp verification result \n\n## Rapiwa Sender\n**Purpose:** Sends personalized WhatsApp message with product recommendation \n**How it wo" } }, { "id": "cf625c69-6343-48bc-95f0-cccab54c8c8f", "name": "Rapiwa (verify whatsapp number)", "type": "n8n-nodes-rapiwa.rapiwa", "position": [ 2944, 640 ] }, { "id": "3af5524a-34a7-421c-9e01-d00baf27d9f7", "name": "Rapiwa (Send Message)", "type": "n8n-nodes-rapiwa.rapiwa", "position": [ 3568, 512 ] } ], "connections": { "If": { "main": [ [ { "node": "Rapiwa (Send Message)", "type": "main", "index": 0 } ], [ { "node": "Save State of Rows in Unerified & Not sent", "type": "main", "index": 0 } ] ] }, "Wait": { "main": [ [ { "node": "Loop Over Items", "type": "main", "index": 0 } ] ] }, "Loop Over Items": { "main": [ [], [ { "node": "get customer data", "type": "main", "index": 0 } ] ] }, "Schedule Trigger": { "main": [ [ { "node": "Get many customers", "type": "main", "index": 0 } ] ] }, "Code (clean data)": { "main": [ [ { "node": "get specific product recommend latest product", "type": "main", "index": 0 } ] ] }, "get customer data": { "main": [ [ { "node": "get most buy product id & Clear Number", "type": "main", "index": 0 } ] ] }, "Get many customers": { "main": [ [ { "node": "Code (get paying_customer)", "type": "main", "index": 0 } ] ] }, "Rapiwa (Send Message)": { "main": [ [ { "node": "Save State of Rows in Verified & Sent", "type": "main", "index": 0 } ] ] }, "get specific product data": { "main": [ [ { "node": "Code (clean data)", "type": "main", "index": 0 } ] ] }, "Code (get paying_customer)": { "main": [ [ { "node": "Loop Over Items", "type": "main", "index": 0 } ] ] }, "Rapiwa (verify whatsapp number)": { "main": [ [ { "node": "If", "type": "main", "index": 0 } ] ] }, "Save State of Rows in Verified & Sent": { "main": [ [ { "node": "Wait", "type": "main", "index": 0 } ] ] }, "get most buy product id & Clear Number": { "main": [ [ { "node": "get specific product data", "type": "main", "index": 0 } ] ] }, "Save State of Rows in Unerified & Not sent": { "main": [ [ { "node": "Wait", "type": "main", "index": 0 } ] ] }, "get specific product recommend latest product": { "main": [ [ { "node": "Rapiwa (verify whatsapp number)", "type": "main", "index": 0 } ] ] } } }