Scheduled WhatsApp Broadcast from Google Sheets

# 📘 n8n Workflow: WhatsApp Bulk Message Broadcast via Google Sheets

## 📌 Overview

This **n8n automation workflow** enables you to send **bulk WhatsApp messages** directly from a **Google Sheet** using the **WhatsApp Business Cloud API**. It ensures efficient delivery and status tracking of each message, making it ideal for marketing, updates, or client communication.

---

## 🔍 Key Features

- 📥 Fetches live rows from a connected Google Sheet  
- 📤 Sends personalized WhatsApp messages to each number  
- 📝 Updates the message delivery status back to the sheet  
- 🕒 Supports batching and delays to comply with rate limits

---

## 🧰 Requirements

Before setting up the workflow, ensure you have:

- ✅ Access to the **WhatsApp Business Cloud API** (via Meta Developer account)  
- ✅ Google Sheets integration configured in n8n  
- ✅ A properly formatted Google Sheet (see below)  

📄 [Sample Google Sheet Template](https://docs.google.com/spreadsheets/d/1nI-AwIR3Y1FYzV0lwjr9iK6Ia4WuD5eRtgJH819rIIc/edit?usp=sharing)

---

## 📄 Google Sheet Structure

| WhatsApp No  | Message                     | Status  |
|--------------|-----------------------------|---------|
| +8801XXXXXXX | Hello, this is a test msg.  | (empty) |

> ℹ️ Keep the `Status` column blank for rows that need to be processed.

---

## ⚙️ Workflow Configuration Steps

### 1. 🔗 Connect to Google Sheets

- Add the **Google Sheets** node  
- Authenticate with your Google account  
- Select the appropriate spreadsheet and worksheet  
- Apply a filter: `Status is empty`

### 2. 🔁 Loop Through Data in Batches

- Use **SplitInBatches** or a **Code** node to process a defined number of rows (e.g., 5 per batch)  
- Include a **Wait** node to delay (e.g., 0.1–0.5 seconds) between each request to avoid hitting rate limits

### 3. 🛠 Configure WhatsApp Business API

- Add an **HTTP Request** node  
- Authenticate using your Meta (Facebook) developer credentials  
- Use a pre-approved **message template ID**  
- Map Google Sheet columns to dynamic variables in the message payload

### 4. 📋 Update Message Status

- After successfully sending each message, use the **Google Sheets Update** node  
- Update the `Status` column to `Sent` or `Failed` based on the API response

---

## 🎯 WhatsApp Template Requirements

Make sure your template:

- ✅ Is approved by Meta  
- ✅ Uses variables (e.g., `{{1}}`, `{{2}}`) for dynamic values  
- ✅ Matches the message content format being sent

---