Send bulk WhatsApp messages from Google Sheets using Rapiwa API

Bulk WhatsApp Campaign Automation with Rapiwa API (Unofficial Integration)

Who’s it for This n8n workflow lets you send bulk WhatsApp messages using your own number through Rapiwa API, avoiding the high cost and limitations of the official WhatsApp API. It integrates seamlessly with Google Sheets, where you can manage your contacts and messages with ease. Ideal for easy-to-maintain bulk messaging solution using their own personal or business WhatsApp number. This solution is perfect for small businesses, marketers, or teams looking for a cost-effective way to manage WhatsApp communication at scale.

How it Works / What It Does - Reads data from a Google Sheet where the Status column is marked as "pending". - Cleans each phone number (removes special characters, spaces, etc.). - Verifies if the number is a valid WhatsApp user using the Rapiwa API. - If valid: - Sends the message via Rapiwa. - Updates Status = sent and Verification = verified. - If invalid: - Skips message sending. - Updates Status = not sent and Verification = unverified. - Waits for a few seconds (rate-limiting). - Loops through the next item. - The entire process is triggered automatically every 5 minutes.

---

How to Set Up 1. Duplicate the Sample Sheet: Use [this format](https://docs.google.com/spreadsheets/d/1Ui4TzzI-Gq-bsEsrZELwW1Kyddw0IU9L1wxlHikktqw/edit?usp=sharing). 2. Fill Contacts: Add columns like WhatsApp No, Name, Message, Image URL, and set Status = pending. 3. Connect Google Sheets: Authenticate and link Google Sheets node inside n8n. 4. Subscribe to Rapiwa: Go to [Rapiwa.com](https://app.rapiwa.com) and get your API key. 5. Paste API Key: Use the HTTP Bearer token credential in n8n. 6. Activate the Workflow: Let n8n take care of the automation.

---

Requirements - Google Sheets API credentials - Configured Google Sheet (template linked above) - WhatsApp (Personal or Business) - n8n instance with credentials setup

---