---
title: "Google Sheets Update Settings"
method: PUT
path: "/integrations/google-sheets/settings"
tags: ["Google Sheets"]
---

# Google Sheets Update Settings

`PUT /integrations/google-sheets/settings`

## Request

- Base URL: `https://api.openintake.ai` (the document declares no server; this is the origin it was published from)
- URL: `https://api.openintake.ai/integrations/google-sheets/settings`
- Auth: none declared
- TypeScript: <https://skmtc.dev/openintake/apis/openintake-api/docs/integrations/google-sheets/settings/put.ts> (a function with typed inputs; its response is checked against the schema)

Choose the spreadsheet and tab, set the expected account, map columns,
and switch pushing on or off. A new spreadsheet or tab is checked against
the signed-in account before it is saved.

## Request body

- GoogleSheetsSettingsUpdate: Fields left out are unchanged.
  - `spreadsheet` string, nullable
  - `sheet_name` string, nullable
  - `push_enabled` boolean, nullable
  - `expected_account` string, nullable
  - `column_mapping` object, nullable

## Response `200`

Successful Response

- GoogleSheetsStatus: Connection, chosen sheet and push health for the current firm.
  - `connected` boolean, required
  - `connected_at` string, nullable
  - `account_email` string, nullable
  - `expected_account` string, nullable
  - `needs_reauth` boolean
  - `reauth_reason` string, nullable
  - `spreadsheet_id` string, nullable
  - `spreadsheet_title` string, nullable
  - `spreadsheet_url` string, nullable
  - `sheet_name` string, nullable
  - `push_enabled` boolean
  - `column_mapping` object
  - `last_success_at` string, nullable
  - `last_error` string, nullable
  - `last_error_at` string, nullable

## Other responses

- `422`: Validation Error

## Changes

- **2026-11-03** `56ef656004f6`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/openintake/apis/openintake-api/changes/integrations/google-sheets/settings/put.md)

---

[API](https://skmtc.dev/openintake/apis/openintake-api.md) - [All operations](https://skmtc.dev/openintake/apis/openintake-api/llms.txt) - [OpenAPI document](https://skmtc.dev/openintake/apis/openintake-api/revisions/fe9f779e77ad?raw)