# 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="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2Fol43Q70xZxLqF2fkWD5y%2FGoogle%20Sheet%20Integration.gif?alt=media&#x26;token=0a122154-c00b-436e-bb4e-dfb3a19a349d" 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="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2Fi17LchMZzt8Eyo3g3VMM%2FCreate%20Copy%20of%20the%20google%20Sheet.gif?alt=media&#x26;token=05db8f58-a2ac-4a86-9be2-e6c2eaa78603" 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="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FHcIJBr6Hych6PUCy92pj%2FClick%20on%20Broadcast%20Icon.gif?alt=media&#x26;token=b4cf9a6c-bf4d-49b5-95e4-dd6e27146451" 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="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FslOGYzRuOW2ubjvYEG7o%2FSign-in-Sheet-Broadcast.gif?alt=media&#x26;token=322acc0c-91b7-4f5e-a5b2-9e52f4405884" 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="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FgkgdZJMkEFA4ZJPS7ymh%2FAdd%20Gallabox%20credentials.gif?alt=media&#x26;token=431b2c77-7e62-4266-a25e-26f89e1788f6" alt=""><figcaption></figcaption></figure>

2. To configure your account with your [API Secret](https://docs.gallabox.com/developer-resources/api-key-and-secret#api-secret) and [API Key](https://docs.gallabox.com/developer-resources/api-key-and-secret#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="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FXmCghNjaJtcOk9GhBOdc%2FAdd%20API%20key%20and%20Secret.gif?alt=media&#x26;token=cf56d840-817e-4201-9dc5-eb7dc1faffcc" 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="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FfzgrhRs5ZRnaTc0A3IYF%2FRun%20Broadcast.gif?alt=media&#x26;token=e94ced91-8981-427b-8c34-78e020569f82" alt=""><figcaption></figcaption></figure>

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