Automate Shopify abandoned cart WhatsApp reminders with product links via Rapiwa

Automate Shopify Abandoned Cart WhatsApp Reminders with Product Links via Rapiwa

Who’s it for This n8n workflow automatically identifies customers who have abandoned their carts on your Shopify store, cleans and verifies their WhatsApp numbers, and sends them personalized reminders via the Rapiwa API. It also logs each interaction—whether the number was valid or not—into a connected Google Sheet. Designed for marketers, small business owners, freelancers, and support teams, this solution makes it easy to run bulk WhatsApp campaigns using just a Google Sheet and your own WhatsApp number—no need for the official WhatsApp Business API. It’s a budget-friendly, scalable, and easy-to-manage alternative for anyone looking to automate WhatsApp follow-ups without the tech hassle.

How it Works / What It Does - Reads rows from a Google Sheet where the Status column is marked as "pending". - Cleans each phone number (removes special characters, spaces, etc.). - Verifies whether the number is a WhatsApp user using the Rapiwa API. - If valid: - Sends the message via Rapiwa. - Updates Status = sent and Verification = verified. - If invalid: - Skips sending. - Updates Status = not sent and Verification = unverified. - Waits a configurable delay between sends to avoid rate limits. - Processes rows in small batches and repeats on schedule (default every 5 minutes).

---

How to Set Up 1. Duplicate the sample Google Sheet format and populate it with contacts and messages. 2. Fill required columns such as WhatsApp No, Name, Message, Image URL, and set Status = pending. 3. Connect Google Sheets in n8n and grant the required OAuth scopes. 4. Create an HTTP Bearer credential in n8n and paste your Rapiwa API key. 5. Configure the workflow nodes (Trigger, Google Sheets, Limit, SplitInBatches, Code, HTTP Request, If, Update Google Sheets, Wait). 6. Enable the workflow in n8n.

---

Requirements - Google Sheets API credentials (OAuth2) configured in n8n - Google Sheet matching the template (WhatsApp No, Name, Message, Status, Verification) - Rapiwa account and Bearer token - n8n instance with HTTP Request and Google Sheets nodes enabled

---