AutomationFlowsAI & RAG › Automate Shopify New Product Promotions via Whatsapp From Sheets

Automate Shopify New Product Promotions via Whatsapp From Sheets

BySpaGreen Creative @spagreen on n8n.io

This workflow is designed for e-commerce store owners, digital marketers, and Shopify merchants who want to automate their product announcement and marketing campaigns. It's particularly useful for businesses that rely on WhatsApp marketing to inform customers about new products…

Event trigger★★★★☆ complexityAI-powered22 nodesShopify TriggerGoogle SheetsOpenAI ChatN8N Nodes RapiwaAgent
AI & RAG Trigger: Event Nodes: 22 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #13415 — we link there as the canonical source.

This workflow follows the Agent → Google Sheets 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 →

Download .json
{
  "id": "XWBO7ZxpM8lQRgiP",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Automate Shopify New Product Promotions via WhatsApp from Sheets",
  "tags": [],
  "nodes": [
    {
      "id": "25f1ee9f-8954-4c08-be4b-222a5834e28c",
      "name": "Shopify Trigger",
      "type": "n8n-nodes-base.shopifyTrigger",
      "position": [
        -1824,
        704
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "71bd3f15-2eba-4068-9940-ccd56a6f79f6",
      "name": "File image quality detect switch",
      "type": "n8n-nodes-base.code",
      "position": [
        -1616,
        704
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "12570cf4-5fac-4616-990e-bb7485bda4c5",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -1152,
        688
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "7f8e92c0-a3fa-495e-8997-e9ff35df2764",
      "name": "Create Product URL",
      "type": "n8n-nodes-base.set",
      "position": [
        -912,
        704
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "c1d6927d-b069-488c-abb4-719dcea8bd8c",
      "name": "Fetch All Pending Queries for Messaging",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -320,
        704
      ],
      "parameters": {},
      "notesInFlow": false,
      "retryOnFail": false,
      "typeVersion": 4.6
    },
    {
      "id": "2b01adaa-ad7f-447a-9787-fbd6dbdc1da4",
      "name": "Limit",
      "type": "n8n-nodes-base.limit",
      "position": [
        -176,
        704
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6227ea33-9821-4468-9409-e8e7ac98b4a9",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        656
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9fe54f6f-9072-4f5c-a7d8-8df2814bd491",
      "name": "Sticky Note12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1104,
        944
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a2c59525-cce9-48cf-974e-df6647602ce6",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        1344
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7bb5c360-516a-47f0-8748-9f9889a61a6b",
      "name": "Loop Over Items1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -1808,
        1184
      ],
      "parameters": {},
      "executeOnce": false,
      "typeVersion": 3
    },
    {
      "id": "cf52e426-0eff-47f8-b648-20759f05b64a",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -704,
        832
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "202c6093-c2d8-4c1c-9092-aca9474f3628",
      "name": "Verify WhatsApp Numbers Using Rapiwa",
      "type": "n8n-nodes-rapiwa.rapiwa",
      "position": [
        -1552,
        1200
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4a921f50-a230-4886-8a1e-937d737dfc39",
      "name": "If (Check Valid Image Links)",
      "type": "n8n-nodes-base.if",
      "position": [
        -1408,
        704
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "f3916892-eba0-4ded-81bc-6d91cbbc6bf0",
      "name": "If (Check Verify & Unverified Number)",
      "type": "n8n-nodes-base.if",
      "position": [
        -1328,
        1200
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "0b9197e6-b552-45c2-b292-6a5c71e09172",
      "name": "Rapiwa (Sent WhatsApp Message)",
      "type": "n8n-nodes-rapiwa.rapiwa",
      "position": [
        -1056,
        1040
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "27c49775-4d6b-498a-87bb-160dd75c4eee",
      "name": "Wait (5s)",
      "type": "n8n-nodes-base.wait",
      "position": [
        -800,
        1344
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "07ba8fb6-3d2f-44ed-b7b7-b75adafc91eb",
      "name": "Update Status of Rows Verified & Sent",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -800,
        1040
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "5d4c4d4f-3b26-41ff-8a59-3b5bc22249df",
      "name": "Update Status of Rows Unverified & Not Sent",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1040,
        1344
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "c0976998-f7cd-4e57-8f44-a30597b9241b",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1840,
        640
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6480e5a6-668e-411e-90ae-a1a085c2287f",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2336,
        608
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a85adf3d-ffb2-49bd-8962-bd32beca6d61",
      "name": "Create the product\u2019s HTML description",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -704,
        704
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "98665a28-ea79-40a2-9727-1f0254615062",
      "name": "Rapiwa (WhatsApp Notify No images found for the product)",
      "type": "n8n-nodes-rapiwa.rapiwa",
      "position": [
        -1408,
        928
      ],
      "parameters": {},
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "aa2cacfb-89cc-4f7e-baf6-65c390f8946e",
  "connections": {
    "Limit": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait (5s)": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Create Product URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Shopify Trigger": {
      "main": [
        [
          {
            "node": "File image quality detect switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items1": {
      "main": [
        [],
        [
          {
            "node": "Verify WhatsApp Numbers Using Rapiwa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Create the product\u2019s HTML description",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Create Product URL": {
      "main": [
        [
          {
            "node": "Create the product\u2019s HTML description",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If (Check Valid Image Links)": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Rapiwa (WhatsApp Notify No images found for the product)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Rapiwa (Sent WhatsApp Message)": {
      "main": [
        [
          {
            "node": "Update Status of Rows Verified & Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "File image quality detect switch": {
      "main": [
        [
          {
            "node": "If (Check Valid Image Links)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Verify WhatsApp Numbers Using Rapiwa": {
      "main": [
        [
          {
            "node": "If (Check Verify & Unverified Number)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If (Check Verify & Unverified Number)": {
      "main": [
        [
          {
            "node": "Rapiwa (Sent WhatsApp Message)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Update Status of Rows Unverified & Not Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Status of Rows Verified & Sent": {
      "main": [
        [
          {
            "node": "Wait (5s)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create the product\u2019s HTML description": {
      "main": [
        [
          {
            "node": "Fetch All Pending Queries for Messaging",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch All Pending Queries for Messaging": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Status of Rows Unverified & Not Sent": {
      "main": [
        [
          {
            "node": "Wait (5s)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This workflow is designed for e-commerce store owners, digital marketers, and Shopify merchants who want to automate their product announcement and marketing campaigns. It's particularly useful for businesses that rely on WhatsApp marketing to inform customers about new products…

Source: https://n8n.io/workflows/13415/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

This n8n workflow creates an intelligent WhatsApp customer support bot that can handle text, image, audio, and document messages. The workflow automatically processes incoming messages through differe

HTTP Request, N8N Nodes Rapiwa, Agent Tool +9
AI & RAG

This n8n workflow is designed for e-commerce businesses, digital marketers, and content creators who want to automatically generate professional 3D product videos from product images. It's perfect for

Form Trigger, Google Drive, HTTP Request +9
AI & RAG

K&S-Media Downloadliste SQL. Uses httpRequest, agent, googleSheets, lmChatOpenAi. Event-driven trigger; 97 nodes.

HTTP Request, Agent, Google Sheets +3
AI & RAG

🎯 Create viral TikToks, Shorts, Reels, podcasts, and ASMR videos in minutes — all on autopilot.

OpenAI, HTTP Request, Form Trigger +7
AI & RAG

Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato 2. Uses @blotato/n8n-nodes-blotato, googleSheets, lmChatOpenAi, toolThink. Event-driven trigger; 94 nodes.

@Blotato/N8N Nodes Blotato, Google Sheets, OpenAI Chat +9