
Curated by n8n Markets team
Last updated: March 8, 2026
# 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 --- ## How to Customize the Workflow - Add or increase delay between messages using the Wait node (e.g., 5–10 seconds). - Change message content or include media by editing the HTTP Request body. - Personalize messages using sheet columns (Name, product details, coupon codes). - Add error handling nodes to retry failed sends or log errors. - Adjust the Limit node to control how many rows are processed per run. --- ## Workflow Highlights - Triggered every 5 minutes using the Schedule Trigger node. - Filters sheet rows where Status = pending. - Cleans numbers and verifies WhatsApp existence before sending. - Sends messages via Rapiwa (unofficial API). - Updates Google Sheet rows with Status = sent/not sent and Verification = verified/unverified. - Uses a Wait node to prevent rapid-fire sending. --- ## Setup in n8n ### 1. Connect Google Sheets - Add a Google Sheets node. - Authenticate with your Google account. - Select the document and worksheet. - Use a filter or query to fetch rows with `Status = pending`. ### 2. Loop Through Rows - Use SplitInBatches to process rows in small chunks (e.g., 5 rows per batch). - Add a Code node to clean phone numbers (remove non-digits). - Add a Wait node to pause between individual sends (recommended 5 seconds). ### 3. Send Message via HTTP Node - Configure an HTTP Request node to POST to: `https://app.rapiwa.com/api/send-message` - Use Bearer Token authentication with your Rapiwa API key. - Example JSON body: ``` { "number": "{{ $json['WhatsApp No'] }}", "message": "{{ $json['Message'] }}" } ``` - After the send, update the row in Google Sheets with the result. --- ## Sample Google Sheet Structure - A Google Sheet formatted like this ➤ [sample](https://docs.google.com/spreadsheets/d/1zsVzniJTeiFOafCI_V0B3_7VnlAPQ2CTWQa-N30qCqs/edit?usp=sharing) | name | number | order id | item name | coupon | item link | total price | validity | status | | -------------- | ------------- | -------------- | --------------------------------- | ------ | -------------------------------------------------------------------------------- | ------------ | ---------- | -------- | | Abdul Mannan | 8801400620056 | 39248398811454 | S25 Ultra 5XXXXX Price Cell Phone | | [Product Link](https://your-shop-domain.myshopify.com/946181xxxxxx&locale=en-BD) | 11500.00 BDT | unverified | not sent | | Abdul Mannan | 8801400620055 | 39248402153790 | S25 Ultra 5XXXXX Price Cell Phone | | [Product Link](https://your-shop-domain.myshopify.com/946181xxxxxx&locale=en-BD) | 11500.00 BDT | verified | sent | | Abdul Mannan | 8801400620055 | 39248403431742 | S25 Ultra 5XXXXX Price Cell Phone | | [Product Link](https://your-shop-domain.myshopify.com/946181xxxxxx&locale=en-BD) | 11500.00 BDT | verified | sent | --- ## Tips - Ensure numbers are in proper format (e.g., 8801XXXX
n8n instance (self-hosted or cloud). credentials.
1. Download the workflow JSON 2. Import into your n8n instance 3. Configure credentials for 4. Activate and enjoy automation
Included in Builder Pro — $19/mo, 4,177 premium workflows
Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.
100% Secure Checkout
Refund requests within 7 days of a new subscription
⚠️ 1 service require credentials. Make sure you have accounts set up before importing.
0 reviews
No reviews yet.
Log in to ask a question.
No questions yet. Be the first to ask!