Bulk WhatsApp Campaign Management from Google Sheets using Rapiwa API - n8n Workflow

Marketing professionals seeking cost-effective bulk messaging solutions.
Users who need to automate communication without relying solely on the expensive official WhatsApp Business API.
Developers looking for a robust n8n template for scheduled data processing and external API calls.
Anyone managing large contact lists in Google Sheets that require periodic WhatsApp outreach.

This powerful n8n workflow provides a reliable, scheduled solution for managing bulk WhatsApp campaigns directly from a Google Sheet. It solves the pain points of manual sending, data formatting errors, and rate limit management.

The automation starts on a schedule, pulls only pending contacts, cleans the phone numbers via an n8n node for compliance, verifies the number's WhatsApp status using Rapiwa, sends the message, and crucially, updates the Google Sheet with the final delivery and verification status. This ensures that the entire process is safe, controlled (via the Limit and Wait n8n nodes), and fully auditable, offering superior control compared to simple API calls. If you need a scheduled, high-volume communication n8n template, this structure is ideal.

The entire process is managed automatically by the scheduled n8n trigger and executes every five minutes:

1. Trigger & Fetch: The n8n workflow is initiated by the Trigger Every 5 Minute n8n trigger. It then uses the Google Sheets n8n node to fetch rows where the Status column is set to 'pending'.


2. Rate Limiting: A dedicated Limit n8n node restricts processing to a safe batch size (e.g., 60 items) per cycle to manage load and API limits effectively.


3. Iteration & Cleaning: The Loop Over Items n8n node processes each pending message individually. The Clean WhatsApp Number Code n8n node ensures that the phone number is correctly formatted (stripping non-numeric characters).


4. Verification: An HTTP Request n8n node calls the Rapiwa API to verify if the cleaned number is an active WhatsApp account.


5. Conditional Sending: An If n8n node checks the verification result.

1. Status Update: Two separate Google Sheets n8n nodes update the status of the original row: 'verified & sent' for successful deliveries, and 'unverified & not sent' for failed verifications.


2. Safe Delay: A Wait n8n node introduces a short delay (e.g., 5 seconds) before processing the next item in the loop, maintaining a controlled sending speed to avoid blocks. The loop then continues until all items in the batch are processed.

To set up this powerful n8n workflow, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and paste it into your n8n instance using the 'New' -> 'Import from JSON' function.


2. Google Sheets Credentials: Configure the Google Sheets OAuth2 credential in your n8n setup. You must grant access to the specific spreadsheet used for the queue.


3. Rapiwa API Credentials: This n8n workflow requires a Bearer Token. Create a new HTTP Bearer Auth credential in n8n and input your Rapiwa API token.


4. Configure Nodes:

1. Activate: Set the main n8n trigger node (Trigger Every 5 Minute) to Active and save the n8n workflow.

This n8n template relies on several specialized n8n node configurations:

Trigger Every 5 Minute (Schedule Trigger n8n node):
Function: Serves as the primary n8n trigger, initiating the bulk message check every five minutes.
Key Configuration: Recurrence set to run every 5 minutes.

Fetch All Pending Queries for Messaging (Google Sheets n8n node):
Function: Reads data from the specified 'Message Queue' sheet, filtering rows where the Status column equals 'pending'.
Key Configuration: Operation set to 'Read', with a filter applied to the 'Status' column.

Clean WhatsApp Number (Code n8n node):
Function: Custom JavaScript logic is executed to sanitize phone numbers by removing all non-digit characters (waNoStr.replace(/\D/g, "")), ensuring the correct format for the Rapiwa API.

Check valid whatsapp number Using Rapiwa1 (HTTP Request n8n node):
Function: Performs a POST request to Rapiwa's verification endpoint to validate the cleaned number.
Key Configuration: Uses HTTP Bearer Authentication linked to Rapiwa credentials.

Send Message Using Rapiwa (HTTP Request n8n node):
Function: The core communication n8n node that sends the WhatsApp message.
Key Configuration: Dynamic query parameters map the cleaned number ({{ $json.data.number }}), message, and optional image URL directly from the Google Sheet item data.

Change State of Rows in Verified & Sent (Google Sheets n8n node):
Function: Updates the Google Sheet row status to 'sent' and 'verified' upon successful message delivery.
Key Configuration: Operation set to 'Update', using the row_number field for matching the row to modify.

Wait (Wait n8n node):
* Function: Enforces necessary inter-message delay (5 seconds default) crucial for safe rate limiting compliance during bulk sending. This n8n node ensures the stability of the overall n8n workflow.