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

# Google Sheets

### Overview

The Google Sheets integration connects nexos.ai with your **Google Sheets** so you can reference spreadsheet data directly in your workspace. It helps you quickly answer questions about reports, metrics, project tracking, budgets, and shared datasets without manually searching through spreadsheets. You can use it to review updates, summarize information, analyze trends, and keep your team aligned using the latest data stored in Google Sheets.

### What you can do with Google Sheets

With the Google Sheets integration enabled, you can work with spreadsheet data directly in nexos.ai. For example, you can:

* read and reference data from existing sheets
* summarize reports, trackers, budgets, and datasets
* review updates and spot changes in shared spreadsheets
* analyze trends, metrics, and project data
* add or update rows and columns
* create new sheets or remove existing content
* pull spreadsheet data into your workflows and answers

Google Sheets works best for reviewing and updating structured data, such as rows, columns, and tabular information. It is especially useful for keeping reports, trackers, and shared datasets up to date.

### Setting up the integration (as an admin)

1. Click on your **Profile icon.**
2. Go to **Management** -> **Apps.**
3. Find **Google Sheets** in the list.
4. Set the integration to **Active** (enabled).

After it’s enabled here, team members can connect their own **Google Sheets** accounts.

<figure><img src="https://4112003433-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDcOhapgXnoeDvgGQ8Jm4%2Fuploads%2FSV3tcJr59HBBUKo2mEQ4%2Fg%20sheets%202.gif?alt=media&amp;token=ead11ea9-3bb0-44cd-8744-4c7c7cd95f6e" alt="" width="563"><figcaption></figcaption></figure>

### Connecting your account (as a member)

1. Click on your profile icon.
2. Go to **Get apps** -> **My apps.**
3. Find **Google Sheets** and select **Connect**.
4. You will be redirected to Google Sheets. Sign in if prompted.
5. Review the access request screen (it will list what nexos.ai can access in **Google Sheets**) and select **Accept** to approve.
6. Return to nexos.ai. **Google Sheets** should now show as connected in **My Apps**.

<figure><img src="https://4112003433-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDcOhapgXnoeDvgGQ8Jm4%2Fuploads%2F6vemKJ8MB0n7rS2DJr2c%2Fimage.png?alt=media&amp;token=10465f68-7b3e-46e2-ab88-12d478ecb3e1" alt=""><figcaption></figcaption></figure>

### Use Google Sheets in Chat (turn it on for a conversation)

1. Open **New Chat.**
2. Click on a "**+**" -> **Integrations.**
3. **Toggle on** **Google Sheets** to use it in that conversation.

<figure><img src="https://4112003433-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FDcOhapgXnoeDvgGQ8Jm4%2Fuploads%2FK7Vvz4fnRGdO8Hkp8uTP%2Fg%20sheets%20.gif?alt=media&amp;token=bc941eae-ea04-4bc0-9042-5289902d30a9" alt="" width="375"><figcaption></figcaption></figure>

### Use Google Sheets in Agents (turn it on for an agent)

1. Open **Agents** and select the agent you want to update.
2. Select the **Studio** icon (top-right), then open **Settings**.
3. Scroll to **Integrations** and turn **Google Sheets** **on**.
4. **Save** your changes, then test the agent.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

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

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.nexos.ai/workspace/integrations/google-sheets.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.