--- title: Google Sheets summary: Connect a Google Sheets account so your AI agents can find spreadsheets, read and search rows, append records, and update cells under permissions you control. category: integrations slug: googlesheets --- ## What Google Sheets in Kronos lets your agents do Once a Google Sheets account is connected to Kronos, your agents can — within the permissions you grant — work with your spreadsheets the way you would yourself: **Read actions** (available when an agent has "Read only" or higher): - Search for spreadsheets across your account. - Open a spreadsheet and read its overall info (title, sheet tabs, sizes). - List the sheet (tab) names inside a spreadsheet. - Read values from a range, or pull several ranges at once. - Find a worksheet by its title. - Look up a specific row by matching a value. - Read tables inside a spreadsheet, get a table's column layout, and run read-only queries against a table. **Write actions** (available only when an agent has "Read and write"): - Create a brand-new spreadsheet, or build a sheet from structured data. - Add, copy, or delete sheet tabs. - Append a new row or column of data. - Update cells, or update many cells at once in a batch. - Insert or delete rows and columns. - Clear the values in a range. - Format cells, create charts, and set or clear filters. - Rename a spreadsheet or change a tab's properties. You decide which agent gets which level, and you can switch any permission off in one click without disconnecting the account. ## Connecting Google Sheets 1. Open Kronos → **Connect** in the sidebar → **Applications** tab. 2. Click the **Google Sheets** card to open the detail dialog, then click the green **Connect** button. 3. You land on Google's screen — pick the Google account that owns the spreadsheets you want your agents to work with. 4. Confirm the chosen account on Google's summary screen. 5. Review the access Kronos is requesting (read and edit your spreadsheets) and continue. Leave the access checked — some actions stop working if you uncheck a category. 6. You're sent back to Kronos at the **Already connected** tab with the new Google Sheets entry pre-selected. You can connect more than one Google account, and each appears as its own connection. ## Naming the connection The Google Sheets management page shows the connection with an optional **Your note for this connection** field. Because spreadsheets live inside a Google account rather than under a single account label, the note is the clearest way to tell connections apart — give each one a short label like "Company Drive", "Finance", or "Ops Tracker" so a long list stays scannable. The note is yours only; it does not change what the agent can access. ## Giving an agent access On the management page click **+ Add AI Agent**, pick the agent from the dropdown, then choose: - **Off** — the agent cannot touch this Google Sheets account. - **Read only** — the agent can search, open, and read spreadsheets and rows, but cannot create, edit, or delete anything. - **Read and write** — the agent can do all of the above plus create spreadsheets, append and update rows, format cells, and delete sheets or data. The same controls are available inside the AI Agent editor — scroll to the **Connected Apps** section. ## Fine-grained overrides Inside the permissions modal (the gear icon next to a Google Sheets account in the agent editor or on the management page) you'll see the full list of actions grouped by **Read tools** and **Write tools**. Toggle individual actions on or off to override the preset. Common combinations: - **Reporting agent**: preset Read only, no overrides. The agent reads and summarizes your data but can never change a cell. - **Data-logging agent**: preset Read only, override `Append Values to Spreadsheet` and `Create spreadsheet row` ON. The agent can read your sheets and add new rows, but cannot edit or delete existing data. - **Editor without deletes**: preset Read and write, override `Delete Sheet` and `Delete Dimension (Rows/Columns)` OFF. The agent can edit freely but cannot remove tabs, rows, or columns. - **Full assistant**: preset Read and write, no overrides. Click Save to apply. Changes take effect on the next message the agent processes. ## Multiple Google Sheets accounts on the same agent If an agent has access to two or more Google Sheets connections, it picks which one to use on every action based on context. When the request is ambiguous, the agent will ask which account to use. You can cut ambiguity by turning the agent's access to one connection off, or by giving each connection an obviously distinct note. ## When something goes wrong - **"Needs reconnect"** badge — Google revoked or expired the connection. Open `/app/connect`, click Google Sheets, and walk through Connect again. Permissions are preserved. - **Agent says "I can't edit that spreadsheet"** — that agent's permission preset is Off or Read only without the matching write override. Open the permissions modal and adjust. - **Agent can't find a spreadsheet** — the connected Google account may not have access to that file, or it lives in a different account. Confirm the spreadsheet is shared with the connected account. - **Agent says the connected app is temporarily unavailable** — Google or the connection had a transient hiccup. Ask the user to retry in a moment. If it persists, check the management page for a "Needs reconnect" badge. ## Privacy Kronos does NOT store the contents of your spreadsheets. Each time an agent uses a Google Sheets action, it fetches just-in-time through the connection, uses what it needs to complete the task, and discards the result. The audit log records that the action happened (which agent, which action, when, and whether it succeeded), but not the cell data. When you disconnect Google Sheets or cancel your Kronos subscription, the connection and all per-agent permissions are deleted immediately.