# Google Sheets

### How do I set it up? 

To set up the integration between Swiftsell and Google Sheets, you can follow the following steps; 

* Add an action block on Canvas by clicking on '**+**' <br>
* Choose '**Google Sheets**' <br>
* Double-click on '**Google Sheets**' to configure it on the right panel<br>
  * **Authorise the account:** \
    \
    Authorize your Google account and provide all the necessary permissions asked for, so that Swiftsell can push the data to the Google Sheet as soon as it is captured\
    \
    To authorize your Google account, you can either click on '**+ Add account**' or you can go to '**App Market -> Google Sheets -> Accounts -> Add Google Account**' <br>
  * **Select the sheet:**\
    \
    All the sheets that are shared with you will be displayed in the dropdown. You need to select the Google Sheet where you would like the chatbot to send the data<br>
  * **Select the variable:** \
    \
    Select the variables for which the value needs to be pushed to Google Sheet

{% hint style="info" %}
The header row will always contain the name of the variable \
\
A new row is created on Google Sheets as soon as the data has been captured&#x20;
{% endhint %}

{% hint style="warning" %}
Deleting the column on Google Sheet will lead to loss of data\
\
Deleting that sheet will result in a loss of data
{% 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://docs.swiftsell.biz/integrations/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.