> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ryvo.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect Google Sheets

> Connect your Google Sheets so your agent can look up real data and log the outcome of every conversation.

Google Sheets is the integration for teams still running on spreadsheets, and it works surprisingly well: your agent looks up an order number, reads the status of a request and answers with the real figure instead of a generic reply.

It also works the other way round: every conversation lands as a row at the end of the sheet, with nobody typing it in.

## What you need first

* A **Google** account with edit access to the sheet you want to use.
* The sheet already created, with **headers in the first row**. Your agent searches by column, so a sheet without headers makes its job harder.
* The **Starter** plan or higher in Ryvo, with the Engine module active.

## How to connect it

<Steps>
  <Step title="Open Settings › Integrations">
    In the portal, go to **Settings** and then **Integrations**. Find the **Google Sheets** card.
  </Step>

  <Step title="Click Connect app">
    Google's authorization screen opens in a new window. Meanwhile the card shows **In progress**.
  </Step>

  <Step title="Pick the account and accept the permissions">
    Select the Google account that owns the sheet and accept.
  </Step>

  <Step title="Come back to Ryvo">
    You land back on the Integrations screen on your own and the card turns to **Connected**. Google Sheets asks nothing else.
  </Step>
</Steps>

## What your agent can do once it is connected

| Action          | What it does in the conversation                                                                            |
| --------------- | ----------------------------------------------------------------------------------------------------------- |
| **Look up row** | Finds a value in the sheet, for example an order status by its number, so it answers with real information. |
| **Append row**  | Adds a record at the end of the sheet, to log the outcome of the conversation.                              |
| **Read range**  | Reads a range of cells when it needs several values at once.                                                |

Actions are turned on one by one from **View actions** and the [**Tools**](/guides/agents/tools) section of the builder, with a cap of **10 integration actions per agent**.

<Note>
  Your agent needs to know **which sheet** to work on. You tell it that in the agent's instructions, in the builder: put the spreadsheet id (the long part of its URL) and the tab name there.
</Note>

## What to do if something fails

| What you see                                          | What happened                                                                          | What to do                                                                                |
| ----------------------------------------------------- | -------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------- |
| The agent says it cannot find the sheet               | The account you authorized has no access to that sheet, or the id you gave it is wrong | Share the sheet with the connected account and check the id in the URL                    |
| **Append row** writes to the wrong tab                | The agent does not have the tab name in its instructions                               | Write it into the agent's instructions, in the builder                                    |
| **The account stopped responding. Connect it again.** | You revoked Ryvo's access from your Google account                                     | Click **Reconnect**: Ryvo revokes the old access and opens the authorization from scratch |