# Sender for Google Sheets

### Source Code

In source code, the bot sends text from Google Sheets cells to the numbers specified in the cells. Records the status of the sent message, and if the client responds, records his first response in an additional cell. You can use this source code in your work or as a convenient platform to start your project.

{% embed url="<https://github.com/Whapi-Cloud/googlesheets-sender>" %}
Source Code
{% endembed %}

Here are instructions on how to customize the script from GitHub:  [WhatsApp API Google Sheets](/help-desk/source-code/whatsapp-api-google-sheets.md)&#x20;

What is the functionality of this bot?&#x20;

* Writing information to a table;&#x20;
* Reading information from the table;&#x20;
* Sending messages to numbers from the table;

{% hint style="info" %}
Using this source code will allow you to customize the bot to your needs or take it as a basis for creating any other integration.&#x20;
{% endhint %}

If you need help, just message us in the support chat on any page of the site. We can help you with bot installation or customization.

{% hint style="info" %}
Attention: This section does not describe how to work with the interface, but allows you to automate mailing via API.
{% endhint %}

### API Endpoint for Interface

{% hint style="success" %}
**POST** [*https://tools.whapi.cloud/integrations/google\_dialog\_flow/send*](https://tools.whapi.cloud/integrations/google_sheets/mailing_list)
{% endhint %}

The request will require specifying a **Header** with the name **Authorization** and the value "**Bearer {your\_channel\_token}**"

***Body:***

```json
{
    "spread_sheet_url": "Link to the Google spreadsheet"
}
```

{% hint style="warning" %}
You need to give permission to access the Link for our account as Editor sender-**<whapicloud@sender-whapicloud.iam.gserviceaccount.com>**
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.whapi.cloud/help-desk/integrations/sender-for-google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.