Send WhatsApp Bulk Messages from Google Sheets

This n8n workflow automates the process of sending personalized bulk WhatsApp messages to a list of contacts stored in a Google Sheet. It's designed to streamline communication for marketing campaigns, notifications, or any scenario requiring mass messaging.

What it does

This workflow simplifies sending bulk WhatsApp messages by:

1. Triggering on a Schedule: The workflow can be set to run at specific intervals (e.g., daily, weekly) to check for new messages to send.
2. Reading Data from Google Sheets: It connects to a specified Google Sheet to retrieve a list of contacts, including their phone numbers and the message content.
3. Processing Data in Batches: The workflow iterates through each row of the Google Sheet, allowing for individual message processing.
4. Formatting Phone Numbers: A Code node ensures that all phone numbers are correctly formatted for WhatsApp, adding the country code if missing.
5. Sending WhatsApp Messages: For each contact, it sends a personalized message using the WhatsApp Business Cloud API.
6. Limiting Messages (Optional): An optional "Limit" node is included, which can be used to restrict the number of messages sent in a single run, useful for testing or managing API quotas.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: A Google Sheets spreadsheet containing the contact list. The sheet should have columns for phone numbers and message content.
• WhatsApp Business Cloud Account: Access to the WhatsApp Business Cloud API with a configured phone number and message templates.
• n8n Credentials:
  • Google Sheets Credential: An OAuth2 credential for Google Sheets to allow n8n to read your spreadsheet.
  • WhatsApp Business Cloud Credential: An API key or token for your WhatsApp Business Cloud account.

Setup/Usage

1. Import the Workflow:

   • Download the provided JSON file for this workflow.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" -> "Import from JSON" and paste the workflow JSON or upload the file.

2. Configure Credentials:

   • Locate the "Google Sheets" node and click on it.
   • Under "Credentials", select an existing Google Sheets credential or click "Create New" to set one up. Ensure it has access to the spreadsheet you intend to use.
   • Locate the "WhatsApp Business Cloud" node and click on it.
   • Under "Credentials", select an existing WhatsApp Business Cloud credential or click "Create New" to set one up.

3. Configure Google Sheet Details:

   • In the "Google Sheets" node:
     • Specify the "Spreadsheet ID" of your Google Sheet.
     • Specify the "Sheet Name" where your contact data is located.
     • Ensure the "Read All Rows" operation is selected.

4. Configure the Code Node:

   • The "Code" node is responsible for formatting phone numbers. Review the JavaScript code to ensure it matches your expected phone number format (e.g., adding a specific country code if numbers in your sheet don't include it).
   • Modify the item.json.phone and item.json.message references to match the column headers in your Google Sheet. For example, if your phone number column is named ContactNumber, change item.json.phone to item.json.ContactNumber.

5. Configure WhatsApp Message:

   • In the "WhatsApp Business Cloud" node:
     • Set the "Phone Number ID" from your WhatsApp Business Account.
     • Set the "To" field to ={{ $json.phone }} to use the formatted phone number from the previous step.
     • Choose "Send Template Message".
     • Select your "Template Name" and "Language".
     • Map the "Header Parameters" and "Body Parameters" to the corresponding data from your Google Sheet (e.g., ={{ $json.message }}).

6. Configure the Schedule Trigger:

   • Open the "Schedule Trigger" node.
   • Set the desired "Interval" (e.g., every 1 hour, every day at a specific time) for when the workflow should check for and send messages.

7. Activate the Workflow:

   • Once all configurations are complete, click the "Activate" toggle in the top right corner of the n8n editor to enable the workflow.

Note on the Limit Node: The "Limit" node (ID: 1237) is currently disconnected. If you wish to limit the number of messages sent per execution (e.g., for testing or to stay within API rate limits), you can connect it between the "Loop Over Items" node and the "Code" node, and configure its settings.