January 22, 2026

WooCommerce + WhatsApp promos, logged in Google Sheets

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Creating a new coupon should feel like progress. Instead, it often turns into a mini project: export customers, copy coupon details, clean phone numbers, send messages one-by-one, then try to remember what you actually sent.

This is the kind of mess that drains eCommerce managers first, but store owners and marketing leads feel it too. With WooCommerce WhatsApp promos running automatically, you stop missing customers and you stop guessing what happened.

This workflow triggers on coupon creation, verifies WhatsApp numbers before messaging, then logs every outcome in Google Sheets so you can measure and improve the next campaign.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: WooCommerce + WhatsApp promos, logged in Google Sheets

Click to explore

flowchart LR

    subgraph sg0["WooCommerce Flow"]
        direction LR
        n0@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
        n1@{ icon: "mdi:cog", form: "rounded", label: "Wait", pos: "b", h: 48 }
        n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/wooCommerce.svg' width='40' height='40' /></div><br/>WooCommerce Trigger"]
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Clean WhatsApp Number"]
        n5@{ icon: "mdi:database", form: "rounded", label: "Save State of Rows in Verifi..", pos: "b", h: 48 }
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Format WooCommerce Trigger R.."]
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/wooCommerce.svg' width='40' height='40' /></div><br/>Get many customers"]
        n8@{ icon: "mdi:database", form: "rounded", label: "Save State of Rows in Unerif..", pos: "b", h: 48 }
        n9@{ icon: "mdi:web", form: "rounded", label: "Rapiwa", pos: "b", h: 48 }
        n10@{ icon: "mdi:web", form: "rounded", label: "Rapiwa (send message)", pos: "b", h: 48 }
        n0 --> n10
        n0 --> n8
        n1 --> n2
        n9 --> n0
        n2 --> n4
        n7 --> n2
        n3 --> n6
        n4 --> n9
        n10 --> n5
        n5 --> n1
        n6 --> n7
        n8 --> n1
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n3 trigger
    class n0 decision
    class n5,n8 database
    class n9,n10 api
    class n4,n6 code
    classDef customIcon fill:none,stroke:none
    class n3,n4,n6,n7 customIcon

The Problem: Coupon promos are easy to launch, hard to track

Coupon promos usually break in the same spot: the handoff between “coupon created” and “customers actually notified.” Someone exports a list, someone cleans phone numbers, someone sends messages, and then a week later you are trying to figure out which customers got the offer (and which didn’t). It’s not just time. It’s confidence. When attribution is fuzzy, you end up blasting the same people again or avoiding WhatsApp altogether because the admin work is frankly annoying.

It adds up fast. Here’s where it breaks down in real stores.

Customer phone numbers come in messy formats, so messages fail silently and you only notice after sales don’t move.
Manual sending turns “quick promo” into about 2 hours of repetitive work when you have a few hundred customers.
You can’t segment cleanly because there’s no reliable record of who was verified, who was messaged, and who bounced.
Without a log, it’s hard to prove performance or learn anything from the campaign.

The Solution: Auto-send verified WhatsApp coupon messages and log everything

This n8n workflow listens for a new WooCommerce coupon being created, then immediately prepares a clean “coupon payload” you can safely reuse in messages and reporting. Next, it pulls your customer list from WooCommerce and processes customers in controlled batches, so you don’t hammer your API limits. For each customer, it normalizes the billing phone number (removes spaces, plus signs, and other non-digits), checks whether that number is registered on WhatsApp using the Rapiwa API, and only sends the promo message when the number is verified. Every attempt is logged to Google Sheets, split into verified/sent and unverified/not sent, which gives you an instant campaign ledger you can filter, audit, and reuse for follow-ups.

The workflow starts the moment your coupon exists in WooCommerce. It then cleans customer phone data, verifies WhatsApp eligibility, sends a personalized promo, and writes a row to Google Sheets with coupon details and status. A short wait between batches keeps the whole run stable.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Detects new WooCommerce coupons the second they’re created.
Fetches your customer list and processes it in batches with a built-in delay.
Cleans and standardizes billing phone numbers before any WhatsApp checks.
Verifies WhatsApp registration, sends the promo, then logs verified and unverified outcomes to separate Google Sheets tabs.

Most teams get about 2 hours back on every campaign send.
Fewer wasted sends because unverified numbers are filtered out before messaging.
A clean Google Sheets log you can sort by coupon, date, status, or customer email.
More consistent messaging because the coupon details are formatted the same way every time.
Easier follow-ups, since “not sent” becomes a ready-made re-targeting list.

Example: What This Looks Like

Say you run a weekend promo and you have about 600 customers in WooCommerce. Manually, even a quick process (export, clean numbers, send, and log) is often 10 minutes per 25 customers, which is around 4 hours of tedious work. With this workflow, you create the coupon once, then the automation runs in batches in the background with short waits to avoid rate limits. You still spend a few minutes spot-checking the Google Sheet, but the send itself is handled for you.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
WooCommerce for coupon events and customer data
Rapiwa to verify WhatsApp numbers and send messages
Google Sheets access (connect a Google account in n8n)

Skill level: Intermediate. You’ll connect accounts, map a few fields, and paste API credentials, but you won’t be writing an app.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A coupon is created in WooCommerce. The workflow triggers on the coupon.created event, then captures the coupon code, title, type, amount, and key dates.

Customer records are pulled and paced. It retrieves your WooCommerce customers, then processes them in batches with a short delay between cycles so the APIs don’t get overloaded.

Numbers are cleaned and verified before messaging. Each billing phone number is normalized (digits only), checked against WhatsApp via Rapiwa, and routed based on the verification result using an IF branch.

Messages and logs are written consistently. Verified customers receive the WhatsApp promo message, and the workflow logs the full record to Google Sheets with a “verified/sent” status. Unverified customers are still logged, just marked “unverified/not sent,” so you don’t lose visibility.

You can easily modify the message template to match your brand voice based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the WooCommerce Trigger

Set up the workflow to start whenever a new coupon is created in WooCommerce.

Add the Commerce Coupon Trigger node to your workflow.
Set Event to coupon.created.
Credential Required: Connect your wooCommerceApi credentials.

Step 2: Shape Coupon Data and Load Customers

Format the coupon payload and fetch all customers for distribution.

Add Shape Coupon Payload after Commerce Coupon Trigger and keep the provided JavaScript to format coupon fields.
Add Retrieve Customer List after Shape Coupon Payload.
Set Resource to customer and Operation to getAll.
Enable Return All.
Credential Required: Connect your wooCommerceApi credentials.

Step 3: Batch and Normalize Customer Numbers

Process customers in batches and sanitize phone numbers before verification.

Add Iterate Records after Retrieve Customer List to enable batch processing.
Add Normalize WhatsApp Number after Iterate Records.
Keep the JavaScript in Normalize WhatsApp Number to strip non-digit characters from number.

If your WooCommerce data uses billing.phone instead of number, update the normalization script to read the correct field.

Step 4: Verify WhatsApp and Route the Flow

Check WhatsApp availability and route verified and unverified numbers.

Add Verify WhatsApp via Rapiwa after Normalize WhatsApp Number.
Set Operation to verifyWhatsAppNumber.
Set Number to {{ $json.billing.phone }}.
Credential Required: Connect your rapiwaApi credentials.
Add Branch Verification after Verify WhatsApp via Rapiwa and set the condition to {{ $json.data.exists }} is true.

⚠️ Common Pitfall: The verification response must include data.exists and data.number. If your Rapiwa response differs, update the condition and message fields accordingly.

Step 5: Send WhatsApp Messages and Log Outcomes

Dispatch WhatsApp coupons for verified numbers and log both verified and unverified results to Google Sheets.

From the “true” path of Branch Verification, connect to Dispatch WhatsApp Promo.
Set Number to {{ $json.data.number }}.
Set Message to the multi-line template that references {{ $('Normalize WhatsApp Number').item.json.first_name }} and {{ $('Shape Coupon Payload').item.json.data.coupons[0].couponCode }}.
Credential Required: Connect your rapiwaApi credentials.
Connect Dispatch WhatsApp Promo to Log Verified Dispatch and set Operation to append.
Set Document ID in Log Verified Dispatch to [YOUR_ID] and Sheet Name to gid=0.
Credential Required: Connect your googleSheetsOAuth2Api credentials for Log Verified Dispatch.
From the “false” path of Branch Verification, connect to Log Unverified Status with Operation set to append, Document ID to [YOUR_ID], and Sheet Name to gid=0.
Credential Required: Connect your googleSheetsOAuth2Api credentials for Log Unverified Status.

Step 6: Configure the Delay Loop

Add a wait cycle to pace processing and loop back for batch handling.

Connect both Log Verified Dispatch and Log Unverified Status to Delay Cycle.
Connect Delay Cycle back to Iterate Records to process the next batch.
Adjust Delay Cycle settings if you need throttling or a specific wait duration.

Step 7: Test and Activate Your Workflow

Run a manual test to confirm WhatsApp delivery and logging before enabling production automation.

Click Execute Workflow and create a test coupon in WooCommerce to trigger Commerce Coupon Trigger.
Verify that Dispatch WhatsApp Promo sends a message for verified numbers and Log Verified Dispatch appends a row.
Confirm that unverified numbers route to Log Unverified Status with status not sent and validity unverified.
When the test succeeds, toggle the workflow to Active to enable live automation.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

WooCommerce API permissions can block customer retrieval. If the run stops early, check the WooCommerce REST API keys and read access for customers in your WooCommerce settings first.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Rapiwa credentials and sender settings matter more than people expect. If verification works but sending fails, re-check your Rapiwa API token and the WhatsApp sending configuration inside your Rapiwa dashboard.

Frequently Asked Questions

How long does it take to set up this WooCommerce WhatsApp promos automation?

About 30 minutes if your accounts and API access are ready.

Do I need coding skills to automate WooCommerce WhatsApp promos?

No. You will connect WooCommerce, Rapiwa, and Google Sheets, then map a few fields.

Is n8n free to use for this WooCommerce WhatsApp promos workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Rapiwa API costs based on your WhatsApp verification and message volume.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this WooCommerce WhatsApp promos workflow for different message templates?

Yes, and you should. Update the message body in the “Dispatch WhatsApp Promo” step, and adjust the “Shape Coupon Payload” code so the fields match your copy style. Common tweaks include adding minimum spend rules, inserting a short URL, and switching languages by customer country. If you run multiple coupons at once, you can also change the logic so it doesn’t only reference the first coupon.

Why is my Rapiwa connection failing in this workflow?

Usually it’s an expired or incorrect API token in n8n. Update the Rapiwa credentials, then re-run a single test customer to confirm verification and sending both work. If it still fails, check your Rapiwa account settings for sending permissions, and slow the workflow down with a longer wait if you’re hitting rate limits.

How many customers can this WooCommerce WhatsApp promos automation handle?

Thousands, as long as you batch them and respect API limits.

Is this WooCommerce WhatsApp promos automation better than using Zapier or Make?

Often, yes, because the “verify then branch then log” pattern is where simpler tools get clunky or expensive. n8n makes batching, waits, and conditional routing straightforward, which matters when you’re processing a whole customer list. Self-hosting also changes the economics if you run frequent campaigns. Zapier or Make can still be fine for very small lists and simple triggers, especially if your team hates managing anything. Talk to an automation expert if you want a quick recommendation for your volume and budget.

You set the coupon once, and the workflow handles the outreach and the record-keeping. The Google Sheet becomes your single source of truth for what actually happened.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"versionId": "",
"meta": {
"instanceId": "6b4053c28a083f96b3cbf278834bfb317c6491e7413ba1ab4e6a4845c9fbf501",
"templateCredsSetupCompleted": null,
"templateId": null
},
"name": "Automated Coupon WhatsApp Delivery",
"nodes": [
{
"id": "flowpast-topbar-10140",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
30,
40
],
"parameters": {
"color": 7,
"width": 1105,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "3a8e2e8e-faa4-4f84-ad98-855f22d74a52",
"name": "Commerce Coupon Trigger",
"type": "n8n-nodes-base.wooCommerceTrigger",
"position": [
790,
140
],
"webhookId": "5530612b-221d-4418-9a9a-ffbe24957be7",
"parameters": {
"event": "coupon.created"
},
"credentials": {
"wooCommerceApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "bdd3c281-cc39-441c-8275-e0b95390429b",
"name": "Shape Coupon Payload",
"type": "n8n-nodes-base.code",
"position": [
470,
215
],
"parameters": {
"jsCode": "// Access the input data (from previous node)\nconst coupons = items[0].json;\n\n// If input is not an array, wrap it\nconst couponsArray = Array.isArray(coupons) ? coupons : [coupons];\n\n// Format coupon data\nconst formattedCoupons = couponsArray.map(coupon => {\n  const amountWithSymbol = coupon.discount_type === \"percent\" \n    ? coupon.amount + \"%\" \n    : coupon.amount;\n\n  return {\n    couponCode: coupon.code,\n    discountAmount: amountWithSymbol,\n    discountType: coupon.discount_type,\n    description: coupon.description,\n    dateCreate: coupon.date_modified,\n    dateExpires: coupon.date_expires,\n    freeShipping: coupon.free_shipping,\n  };\n});\n\n// Return as a **single item** with the array in a `coupons` field\nreturn [\n  {\n    json: {\n      data: {\n        coupons: formattedCoupons\n      }\n    }\n  }\n];\n"
},
"typeVersion": 2
},
{
"id": "e87d5c95-b176-4062-897d-3eb15bd6c5e1",
"name": "Retrieve Customer List",
"type": "n8n-nodes-base.wooCommerce",
"position": [
270,
150
],
"parameters": {
"filters": [],
"resource": "customer",
"operation": "getAll",
"returnAll": true
},
"credentials": {
"wooCommerceApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "2a78cc95-9c6f-484d-913a-de3d708bc35e",
"name": "Iterate Records",
"type": "n8n-nodes-base.splitInBatches",
"position": [
35,
170
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "e421bbaa-b283-417d-8dc3-c8715c855518",
"name": "Normalize WhatsApp Number",
"type": "n8n-nodes-base.code",
"position": [
30,
405
],
"parameters": {
"jsCode": "const items = $input.all();\nconst updatedItems = items.map((item) => {\n  let rawNumber = item?.json[\"number\"];\n  rawNumber = rawNumber ? String(rawNumber) : \"\";\n  const cleanedNumber = rawNumber.replace(/\\D/g, \"\");\n  item.json[\"number\"] = cleanedNumber;\n  return item;\n});\nreturn updatedItems;"
},
"typeVersion": 2
},
{
"id": "fc197945-5c13-4a08-aed9-79cf3d9c3c83",
"name": "Verify WhatsApp via Rapiwa",
"type": "n8n-nodes-rapiwa.rapiwa",
"position": [
330,
305
],
"parameters": {
"number": "={{ $json.billing.phone }}",
"operation": "verifyWhatsAppNumber"
},
"credentials": {
"rapiwaApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "70fcfcfc-a653-4d5b-92db-01951eb416da",
"name": "Branch Verification",
"type": "n8n-nodes-base.if",
"position": [
525,
400
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3ab8725a-9268-45fd-b91c-0e055fe6fa7c",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.data.exists }}",
"rightValue": "=\"true\""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "8929aa8f-78c2-4880-8aab-84ae6a3fc064",
"name": "Dispatch WhatsApp Promo",
"type": "n8n-nodes-rapiwa.rapiwa",
"position": [
905,
330
],
"parameters": {
"number": "={{ $json.data.number }}",
"message": "=Hi {{ $('Normalize WhatsApp Number').item.json.first_name }} {{ $('Normalize WhatsApp Number').item.json.last_name }},\n\n\ud83c\udf89 {{ $('Shape Coupon Payload').item.json.data.coupons[0].description }} from SpaGreen Creative! \ud83c\udf89  \nCelebrate with *{{ $('Shape Coupon Payload').item.json.data.coupons[0].discountAmount }}* OFF \u2014 use code *{{ $('Shape Coupon Payload').item.json.data.coupons[0].couponCode }}* at checkout.  \nThis special offer is valid until *{{ $('Shape Coupon Payload').item.json.data.coupons[0].dateExpires }}* \u2014 don\u2019t miss out!\n\nThanks for being with us!\n"
},
"credentials": {
"rapiwaApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "13e94fe4-66dd-42d2-85a8-e291fb7dee28",
"name": "Log Verified Dispatch",
"type": "n8n-nodes-base.googleSheets",
"position": [
1035,
510
],
"parameters": {
"columns": {
"value": {
"name": "={{ $('Normalize WhatsApp Number').item.json.first_name }} {{ $('Normalize WhatsApp Number').item.json.first_name }}",
"email": "={{ $('Normalize WhatsApp Number').item.json.billing.email }}",
"number": "={{ $('Normalize WhatsApp Number').item.json.billing.phone }}",
"status": "sent",
"address1": "={{ $('Normalize WhatsApp Number').item.json.billing.address_1 }}",
"validity": "verified",
"couponCode": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].couponCode }}",
"couponType": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].discountType }}",
"createDate": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].dateCreate }}",
"expireDate": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].dateExpires }}",
"couponTitle": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].description }}",
"aouponAmount": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].discountAmount }}"
},
"schema": [
{
"id": "name",
"type": "string",
"display": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "number",
"type": "string",
"display": true,
"required": false,
"displayName": "number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address1",
"type": "string",
"display": true,
"required": false,
"displayName": "address1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "couponCode",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "couponCode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "couponTitle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "couponTitle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "couponType",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "couponType",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "aouponAmount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "aouponAmount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "createDate",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "createDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "expireDate",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "expireDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "validity",
"type": "string",
"display": true,
"required": false,
"displayName": "validity",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Coupon Log Sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6
},
{
"id": "8e804acd-a932-4849-bc42-428c478808cd",
"name": "Log Unverified Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
465,
540
],
"parameters": {
"columns": {
"value": {
"name": "={{ $('Normalize WhatsApp Number').item.json.first_name }} {{ $('Normalize WhatsApp Number').item.json.first_name }}",
"email": "={{ $('Normalize WhatsApp Number').item.json.billing.email }}",
"number": "={{ $('Normalize WhatsApp Number').item.json.billing.phone }}",
"status": "not sent",
"address1": "={{ $('Normalize WhatsApp Number').item.json.billing.address_1 }}",
"validity": "unverified",
"couponCode": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].couponCode }}",
"couponType": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].discountType }}",
"createDate": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].dateCreate }}",
"expireDate": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].dateExpires }}",
"couponTitle": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].description }}",
"aouponAmount": "={{ $('Shape Coupon Payload').item.json.data.coupons[0].discountAmount }}"
},
"schema": [
{
"id": "name",
"type": "string",
"display": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "number",
"type": "string",
"display": true,
"required": false,
"displayName": "number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address1",
"type": "string",
"display": true,
"required": false,
"displayName": "address1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "couponCode",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "couponCode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "couponTitle",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "couponTitle",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "couponType",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "couponType",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "aouponAmount",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "aouponAmount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "createDate",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "createDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "expireDate",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "expireDate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "validity",
"type": "string",
"display": true,
"required": false,
"displayName": "validity",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Coupon Log Sheet"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6
},
{
"id": "1830de6f-7291-4150-8d02-3b88bed4a49a",
"name": "Delay Cycle",
"type": "n8n-nodes-base.wait",
"position": [
860,
575
],
"webhookId": "6c474e54-eb3c-4fcd-b455-948322cd0121",
"parameters": [],
"typeVersion": 1.1
}
],
"pinData": [],
"connections": {
"Branch Verification": {
"main": [
[
{
"node": "Dispatch WhatsApp Promo",
"type": "main",
"index": 0
}
],
[
{
"node": "Log Unverified Status",
"type": "main",
"index": 0
}
]
]
},
"Delay Cycle": {
"main": [
[
{
"node": "Iterate Records",
"type": "main",
"index": 0
}
]
]
},
"Verify WhatsApp via Rapiwa": {
"main": [
[
{
"node": "Branch Verification",
"type": "main",
"index": 0
}
]
]
},
"Iterate Records": {
"main": [
[],
[
{
"node": "Normalize WhatsApp Number",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Customer List": {
"main": [
[
{
"node": "Iterate Records",
"type": "main",
"index": 0
}
]
]
},
"Commerce Coupon Trigger": {
"main": [
[
{
"node": "Shape Coupon Payload",
"type": "main",
"index": 0
}
]
]
},
"Normalize WhatsApp Number": {
"main": [
[
{
"node": "Verify WhatsApp via Rapiwa",
"type": "main",
"index": 0
}
]
]
},
"Dispatch WhatsApp Promo": {
"main": [
[
{
"node": "Log Verified Dispatch",
"type": "main",
"index": 0
}
]
]
},
"Log Verified Dispatch": {
"main": [
[
{
"node": "Delay Cycle",
"type": "main",
"index": 0
}
]
]
},
"Shape Coupon Payload": {
"main": [
[
{
"node": "Retrieve Customer List",
"type": "main",
"index": 0
}
]
]
},
"Log Unverified Status": {
"main": [
[
{
"node": "Delay Cycle",
"type": "main",
"index": 0
}
]
]
}
}
}