> For the complete documentation index, see [llms.txt](https://docs.gallabox.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gallabox.com/integration/other-integrations/google-sheets.md).

# Google Sheets

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

{% embed url="<https://www.youtube.com/watch?t=75s&v=ZfMxo9tgJz4>" %}

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

<figure><img src="/files/HNLruryAbOLrwf45lZIc" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="/files/7rWAzEDjxzpI74gXVQi2" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="/files/p2PNz6wjHCm8iacIkAwS" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="/files/GTSx83fAHZ835Z7K04Xa" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/ndrt5bdm5JznlAOksOSp" alt=""><figcaption></figcaption></figure>

2. To configure your account with your [API Secret](/developer-resources/api-key-and-secret.md#api-secret) and [API Key](/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.

<figure><img src="/files/DrZEMwUKH2DVTdNhjFId" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
If you have multiple phone numbers, they will be listed. Choose the number you want to use for the broadcast.
{% endhint %}

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>

<figure><img src="/files/tblP1yCdzln95VLUNlrM" alt=""><figcaption></figcaption></figure>

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