> For the complete documentation index, see [llms.txt](https://developer.konverse.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://developer.konverse.ai/platform/embedded-functions/query-a-google-sheet.md).

# Query a Google Sheet

Our platform lets you read a write to a google sheet directly. 

{% hint style="info" %}
Please note it works with only with Google Sheets, and not xlsx files hosted on google
{% endhint %}

#### Package

```
const sheets = require("@googlesheets");
```

#### Reading a sheet

{% hint style="info" %}
To allow reading from a google sheet, please write to <support@konverse.ai>, to get email ID of the chatbot to which you will need to grant permissions
{% endhint %}

```
let rows = await sheets.readSheet(workBookId, sheetId)
rows.map(row => {
  let first_name = row["First Name"]
});
```

| Parameter  | Description                                                                           |
| ---------- | ------------------------------------------------------------------------------------- |
| workbookID | The ID of the google sheet, from its URL                                              |
| sheetID    | Index of your sheet starting from 0. To read first sheet in your google sheet, pass 0 |

#### Append a row in google sheet

```
let sheet = await sheets.getSheet(workbookID, sheetID);
const larryRow = await sheet.addRow({ name: 'Larry Page', email: 'larry@google.com' });
```