---
title: "Google Sheets connector for agents — authorization and setup — AgentSky"
description: "Use a defined spreadsheet range in your agent workflow. Connect Google Sheets to AgentSky with managed OAuth."
url: https://agentsky.dev/connectors/google-sheets
---

# Google Sheets

Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device. Connect your account through managed OAuth to use the available operations in an agent task.

[Repo](https://agentsky.dev/auth/start?returnTo=%2Fconnectors%2Fgoogle-sheets%3Fresume%3D1)

Connect Google Sheets using the Connectors control before sending. Authorization opens separately and your draft stays here.

Setup

## Connect Google Sheets with an explicit scope.

You need an AgentSky account and authority to connect the application account. Start with a read-only task before allowing changes.

01

### Find the application

Open connector settings and search for Google Sheets. If the catalog is unavailable, retry its load; an unavailable list is not proof the app is unsupported.

02

### Review authorization

Select the intended Google account and review the requested scopes. Your account must be able to access the spreadsheet; Sheets API permissions apply to spreadsheet files, not a single tab.

03

### Verify a bounded task

Ask the agent to summarize a named spreadsheet tab and range. Specify whether the first row is a header and request a read-only result.

Verify access and results

## A connected account is the start of the workflow.

Compare totals and sample rows against the sheet. For later writes, use a disposable copy first and inspect formulas as well as displayed values.

- Access troubleshooting Check the signed-in Google account, spreadsheet sharing, exact tab name and range. Do not mistake a permission error for an empty sheet.
- Available actions The runtime discovers the connector's current operations and input requirements. Do not assume every feature in the application's website is available as an agent action.
- Authorize changes explicitly For writes, specify the target and the allowed change. An instruction to draft or analyze is not permission to publish, send or delete.

## Google Sheets connector questions

## Related resources

[Claude Code + Google SheetsUse Google Sheets with Claude Code in the shared Composer.](https://agentsky.dev/agents/claude-code/connectors/google-sheets) [Codex + Google SheetsUse Google Sheets with Codex in the shared Composer.](https://agentsky.dev/agents/codex/connectors/google-sheets) [OpenClaw + Google SheetsUse Google Sheets with OpenClaw in the shared Composer.](https://agentsky.dev/agents/openclaw/connectors/google-sheets) [OpenCode + Google SheetsUse Google Sheets with OpenCode in the shared Composer.](https://agentsky.dev/agents/opencode/connectors/google-sheets) [Hermes + Google SheetsUse Google Sheets with Hermes in the shared Composer.](https://agentsky.dev/agents/hermes/connectors/google-sheets) [Kimi Code + Google SheetsUse Google Sheets with Kimi Code in the shared Composer.](https://agentsky.dev/agents/kimi-code/connectors/google-sheets) [DeepSeek Harness + Google SheetsUse Google Sheets with DeepSeek Harness in the shared Composer.](https://agentsky.dev/agents/dsh/connectors/google-sheets) [pi + Google SheetsUse Google Sheets with pi in the shared Composer.](https://agentsky.dev/agents/pi/connectors/google-sheets) [All connectorsUnderstand managed application access.](https://agentsky.dev/connectors) [ChannelsChoose where the agent conversation happens.](https://agentsky.dev/channels) [PricingReview charges before running work.](https://agentsky.dev/pricing)

## Connect the right Google Sheets account.

[Open connector settings](https://agentsky.dev/connectors)

## Frequently asked questions

### How does AgentSky access a Google spreadsheet?

Use the Google account that can access the file and authorize the required connector scopes. A spreadsheet link alone does not grant private-file access.

### Can I restrict OAuth access to one tab or cell range?

Sheets API scopes apply to spreadsheet files, not individual tabs or ranges. Naming a range limits the task instruction; it does not create a narrower OAuth boundary.

### Does read-only access allow cell updates?

No. Read-only and write scopes are different. Verify the granted permissions and intended edit before asking the agent to change a sheet.

### What should I include in a spreadsheet task?

Provide the file URL, exact tab name, A1 range and desired result. State whether the agent should analyze values or write changes, and identify formulas that must be preserved.

### Why is a sheet inaccessible or a range invalid?

Check the authorized Google account, file sharing, tab spelling and A1 notation. These are different failure causes and should be corrected separately.

### How can I verify a spreadsheet update?

Inspect the target cells in the original file and confirm that surrounding data and formulas remain correct. A written summary of the edit is not the edit itself.

### Does connecting the app make agent tasks free?

No. Connection permissions and usage billing are separate. The agent’s model, tools and runtime remain subject to the applicable AgentSky charges.

### How should I identify an exact range in my request?

Include the spreadsheet URL, tab name and A1 range, such as Sales!A1:F200. Say whether the first row contains headers and whether the task should read values or make edits.

### How can I ask for analysis without overwriting formulas?

Make the source range read-only and request the analysis in the agent’s reply or a separately named destination. If edits are needed later, identify writable cells and formulas that must remain intact.

### Can I compare two tabs in one task?

Provide both tab names and ranges, and define the matching key, such as customer ID. Ask for added, missing and changed rows separately so differences are interpretable. Access still depends on the spreadsheet file’s permissions.

---

Markdown copy of https://agentsky.dev/connectors/google-sheets. Every agentsky.dev page has one: add `.md` to its address or send `Accept: text/markdown`. Start from https://agentsky.dev/llms.txt.
