> ## Documentation Index
> Fetch the complete documentation index at: https://docs-next.gallabox.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> Discover how to send broadcasts using Google Sheets in Gallabox. Follow the guide to access Google Sheets and configure your Gallabox account in Google Sheet to share messages with your contacts.

You can also use Google Sheets to send broadcasts in Gallabox, apart from using the built-in Broadcast feature.

### **Prefer watching over reading? Check out the below video.**

<iframe class="w-full aspect-video rounded-xl" src="https://www.youtube.com/embed/ZfMxo9tgJz4" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen />

### 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.

<Frame>
  <video src="https://mintcdn.com/gallabox/zLr1bn4U7TLbupvD/images/google-sheet-integration.mp4?fit=max&auto=format&n=zLr1bn4U7TLbupvD&q=85&s=4983c51f980e51f8cb0edb369a686da7" autoPlay loop muted playsInline controls className="w-full aspect-video" data-path="images/google-sheet-integration.mp4" />
</Frame>

2. 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.

<Frame>
  <video src="https://mintcdn.com/gallabox/uG1_eXMWKizfNJ6h/images/create-copy-of-the-google-sheet.mp4?fit=max&auto=format&n=uG1_eXMWKizfNJ6h&q=85&s=ccd1fc514cf1216d01e266a3e6690c12" autoPlay loop muted playsInline controls className="w-full aspect-video" data-path="images/create-copy-of-the-google-sheet.mp4" />
</Frame>

3. 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.

<Frame>
  <video src="https://mintcdn.com/gallabox/uG1_eXMWKizfNJ6h/images/click-on-broadcast-icon.mp4?fit=max&auto=format&n=uG1_eXMWKizfNJ6h&q=85&s=3cf81bd94e6b74341aeb1cb2154bbeb0" autoPlay loop muted playsInline controls className="w-full aspect-video" data-path="images/click-on-broadcast-icon.mp4" />
</Frame>

4. 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.

<Frame>
  <video src="https://mintcdn.com/gallabox/ZdZXLPQK4Igicnrh/images/sign-in-sheet-broadcast.mp4?fit=max&auto=format&n=ZdZXLPQK4Igicnrh&q=85&s=53c53bc61cb22e415b1c4a22d9f9c203" autoPlay loop muted playsInline controls className="w-full aspect-video" data-path="images/sign-in-sheet-broadcast.mp4" />
</Frame>

### 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.

<Frame>
  <video src="https://mintcdn.com/gallabox/uG1_eXMWKizfNJ6h/images/add-gallabox-credentials.mp4?fit=max&auto=format&n=uG1_eXMWKizfNJ6h&q=85&s=69153c4cc16b103ffa3982570396695e" autoPlay loop muted playsInline controls className="w-full aspect-video" data-path="images/add-gallabox-credentials.mp4" />
</Frame>

2. To configure your account with your [API Secret](https://github.com/mangoleaphq/gallabox-docs/tree/main/developer-resources/api-key-and-secret.md#api-secret) and [API Key](https://github.com/mangoleaphq/gallabox-docs/tree/main/developer-resources/api-key-and-secret.md#create-an-api-key-in-gallabox), click on Account Config. You will be prompted to choose the number and add the corresponding details.

<Frame>
  <video src="https://mintcdn.com/gallabox/uG1_eXMWKizfNJ6h/images/add-api-key-and-secret.mp4?fit=max&auto=format&n=uG1_eXMWKizfNJ6h&q=85&s=22edb94dfced81b9ec2a8c0e5e7dd760" autoPlay loop muted playsInline controls className="w-full aspect-video" data-path="images/add-api-key-and-secret.mp4" />
</Frame>

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

3. 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.

<table><thead><tr><th width="165">Action</th><th>Description</th></tr></thead><tbody><tr><td>Run Once</td><td>Select this option to send the broadcast only once.</td></tr><tr><td>Run on Edit</td><td>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.</td></tr></tbody></table>

<Frame>
  <video src="https://mintcdn.com/gallabox/zlyXiaXI2I0eCp1u/images/run-broadcast.mp4?fit=max&auto=format&n=zlyXiaXI2I0eCp1u&q=85&s=b16d23fd7cfc7c497a0a3808856c7c69" autoPlay loop muted playsInline controls className="w-full aspect-video" data-path="images/run-broadcast.mp4" />
</Frame>

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