# Google Sheets actions

> Read and write selected spreadsheet ranges through shared, resource-scoped connections.

Canonical: https://valuechat.app/docs/google-sheets
Category: Integrations & API

## Before you start

Use a test channel or sample conversation first. Confirm the result before applying the setup to production traffic.

## How it works

1. Connect and select. Authorize Google Sheets and select the intended spreadsheets/resources. A Google sign-in to ValueChat alone is not this authorization.

2. Default actions. List tabs, read bounded A1 ranges, find matching rows, append rows, update values, clear values and add a sheet/tab. Use exact spreadsheet IDs and ranges; preserve existing formulas and unrelated rows.

3. Advanced actions. An explicit advanced setting adds whole-spreadsheet creation, row/column insertion or deletion, tab rename/duplicate/delete and exact-key update-or-append. Removing a tab is different from clearing cell contents.

4. Data behavior. RAW cell values are the default. Exact-key upsert rejects duplicate keys and uses a read followed by a write; it is not an atomic cross-user transaction or unrestricted batch-update endpoint.

5. Agent/workflow use. Grant the selected resources/actions, map confirmed customer values and verify the resulting cells. A newly created resource can need an explicit grant before another restricted agent may use it.

## What to verify

- The expected channel, conversation, contact or execution is visible.
- The assignment matches the configured routing.
- No customer-facing message claims an action that failed.
- Activity or execution history explains the result.

## Need help?

support@valuechat.app. Never send API keys or passwords.