How to use Google Sheets for Broadcast.

Learn how to send WhatsApp broadcasts in bulk using Google Sheets and Gallabox—perfect for outreach and campaigns.

Tired of sending WhatsApp messages individually? There i s a simpler solution! This guide will demonstrate how to use Google Sheets to send messages to everyone at once using Gallabox. No more copying and pasting—just a few clicks and you’re all set.

Let's get started by accessing Google Sheets from your Gallabox account.

Access Google Sheets from your Gallabox Account

1. From the left navigation go to Integration and Click on Google Sheets from the available apps. You will be redirected to Make a Copy of the Google Sheet.

1. Click on Make a Copy and rename the Google Sheet from Copy of Gallabox WhatsApp Broadcast v221010.0 to your desired name. Then, start adding the contact details for the broadcast.

1. Once you have added the contact details like Name and the phone number, click on the Gallabox icon as shown in the below screenshot. Then click on WhatsApp Broadcast.

1. You will be prompted to authorize the Gmail account linked with your Gallabox account. Click Continue, then select Advanced. Click Gallabox WhatsApp Unsafe to proceed. Grant the necessary permissions to your Google account.

Configure the Gallabox Account in Google Sheet

1. Once you have permission, click the Gallabox icon again, then select WhatsApp Broadcast. Enter your Gallabox email and password, then click Submit.

1. To configure your account with your API Secret and API Key, click on Account Config. You will be prompted to choose the number and add the corresponding details.

If you have multiple phone numbers, they will be listed. Choose the number you want to use for the broadcast.

1. After pasting the API Key and API Secret, return to Home in the pop-up and click Run Once or Run on Edit under Run Broadcast to share messages with the contacts listed in the Google Sheet.

Action	Description
Run Once	Select this option to send the broadcast only once.
Run on Edit	Select this option if you are using Google Sheets for your broadcast campaigns. When a field, such as a WhatsApp number, is updated in the Google Sheet, the broadcast will be sent to that customer.

By following these steps, you can efficiently automate your broadcast messages using Google Sheets.