Docs · Connector reference

Google Sheets connector reference

Operations, inputs, troubleshooting, and questions for the Google Sheets connection. Policy decides each change before the credential is resolved, and the action record carries the result.

Set up and verify the Google Sheets connection

Choose one task and its account, and match the reads and actions on the overview page to it before granting provider permissions.
Prepare the connection settings from the overview page, connect the provider in Deixic, and choose which tools your agent can use.
Try a small task with a known result, and compare the returned identity and resource with what the account owner expects.
Configure approval for sensitive changes, review the destination and inputs, and check the result in the provider before expanding the workflow.

Information your agent can use

Resource	Record identity	Start with	Page coverage
Spreadsheets	`id`	Top level	Cursor

Record identity: Match on these fields before joining or deduplicating results; where none is specified, check the returned record first.
Start with: Resolve the parent identifier first.
Cursor: Cursor pagination. Continue from the returned cursor; an initial page is not a complete inventory.

Supported operations

Review the inputs before granting an action to an agent. Required inputs must be supplied, optional inputs narrow the request, and provider permissions apply in addition to Deixic policy.

Read: Retrieves information; check the returned scope and identifiers before use.
Action: Can change provider state; review the target and inputs, then retain the result to avoid repeating completed work.

Operation	Effect	Approval	Provider permissions	Inputs
Sheets Get Values	Read	By policy	https://www.googleapis.com/auth/spreadsheets.readonly	4
Sheets Update Values	Action	Approval required	https://www.googleapis.com/auth/spreadsheets	3
Sheets Batch Update	Action	Approval required	https://www.googleapis.com/auth/spreadsheets	2
Sheets Spreadsheets Get	Read	By policy	https://www.googleapis.com/auth/spreadsheets.readonly	1

Inputs by operation

Sheets Get Values Read

Inputs for Sheets Get Values
Input	Requirement	Accepted value
`major_dimension`	Optional	string; one of: ROWS, COLUMNS
`range`	Required	stringMinimum characters: 1Maximum characters: 512
`spreadsheet_id`	Required	stringMinimum characters: 1Maximum characters: 1024
`value_render_option`	Optional	string; one of: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA

Sheets Update Values Action · approval required

Inputs for Sheets Update Values
Input	Requirement	Accepted value
`range`	Required	stringMinimum characters: 1Maximum characters: 512
`spreadsheet_id`	Required	stringMinimum characters: 1Maximum characters: 1024
`values`	Required	arrayMinimum items: 1Maximum items: 1000

Sheets Batch Update Action · approval required

Inputs for Sheets Batch Update
Input	Requirement	Accepted value
`requests`	Required	arrayMinimum items: 1Maximum items: 100
`spreadsheet_id`	Required	stringMinimum characters: 1Maximum characters: 1024

Sheets Spreadsheets Get Read

Inputs for Sheets Spreadsheets Get
Input	Requirement	Accepted value
`spreadsheet_id`	Required	stringMinimum characters: 1Maximum characters: 1024

When the Google Sheets task does not produce the expected result

Connected, but the expected data is missing

Check the identity behind the oauth connection and its access to the specific resource; a successful connection does not establish access to every object.

Compare the lookup against one known record first, and keep an empty response separate from a permissions error.

The answer covers only part of the data

Check the resource’s page coverage, query filters, and result limit, and have the agent state the account and time window it inspected, so a partial response yields a scoped answer.

The agent keeps doing the same work

Inspect the action history for repeated targets and inputs, keep the successful result’s identifiers with the task, and refresh a lookup only when the information changed.

A change is waiting or failed

Check whether the call awaits approval, was rejected by policy, lacks an input, or failed at the provider, and after a timeout inspect the destination before repeating a write.

See how an action proceeds and how to review an approval.

Questions about the Google Sheets connector

Can I use my existing agent with Google Sheets?

Yes: connect your agent to Deixic through MCP, choose which connected tools it can use, and Deixic checks calls routed through its gateway; Dex is available if your team also wants an agent.

Can an agent change data in Google Sheets?

This connector supports 1 action, listed on its overview page. Configure a connection and choose the tools and provider permissions your task needs; an available action is not permission for every agent to run it, and Deixic policy and any required approval still apply to calls through the gateway.

What do I need to connect Google Sheets?

Prepare Client ID, Client secret, Access token, Refresh token; the connection uses OAuth, and the connected identity’s provider permissions determine which resources it can access.

Does connecting Google Sheets keep every answer up to date?

No: an earlier answer is still an earlier answer, so for a decision that depends on current state, have the agent refresh the source and retain the lookup time, and save stable instructions separately from facts that can change.

Google Sheets connector overview Docs All connectors