Skip to content

Google Sheets API and MCP

Google Sheets lets applications read and change spreadsheet values, formulas and formatting in an authorized account. An agent can read spreadsheet values, append report rows and clear selected ranges. Connect your Google Sheets account once with OAuth in Longwave; agents act only on that account.

Add to Longwave

Add Google Sheets to your agent

Paste this into Claude Code or a terminal. Then run /mcp to sign in.

functions
7
access
Connect account

Use Google Sheets on Longwave

  1. Download Longwave or open app.longwave.run.
  2. Connect your Google Sheets account once. Agents then act on that account, and only that account.
  3. Ask for the result in any thread, for example: “Read a prospect list from a spreadsheet”. The agent picks the Google Sheets function and calls it.

Use Google Sheets in Claude Code, Codex, Cursor or ChatGPT

Add the Longwave MCP server once. It carries 2,593 functions across 103 tools, including Google Sheets, and asks you to sign in on first use.

Why call Google Sheets through Longwave

  • One sign-in to Google Sheets, shared by every harness and device you use.
  • One MCP server for 103 tools, so your agent setup does not grow a key and a server per vendor.
  • Spending limits per key and per account, checked before a paid call is made.
  • Each call is recorded with the provider, the cost and the result, and can be read again from another device.

Google Sheets functions

Functions 4

Function Price
google-sheets.values.update google-sheets.values.update
See vendor pricing
google-sheets.values.batch-get google-sheets.values.batch-get
See vendor pricing
google-sheets.spreadsheets.get google-sheets.spreadsheets.get
See vendor pricing
google-sheets.spreadsheets.create google-sheets.spreadsheets.create
See vendor pricing

Google Sheets 3

Every function here: Included within the connected account's API quota or product plan; no separate per-call fee published. Included within the connected account's API quota or product plan; no separate per-call fee published.

Function
Read Google Sheets values Read a caller-selected A1 range, subject to the executor response limit; use a finite cell range. google-sheets.values.get
Append Google Sheets rows Append up to 100 rows of up to 50 text cells each; input values remain literal text. google-sheets.values.append
Clear Google Sheets values Clear values in an A1 range while preserving formatting and validation. google-sheets.values.clear

Prices are Google Sheets's published rates. Source: Google Sheets pricing.

Use cases

Questions people ask

How do I specify a range in the Google Sheets API?

The values API accepts A1 notation such as A1:C10. A range identifies the sheet and cells the request reads or changes. Google Sheets documentation

Does clearing a Sheets range remove its formatting?

The values.clear method clears cell values. It preserves other cell properties, including formatting and data validation. Google Sheets documentation

How does Longwave access my Google Sheets account?

You sign in to Google Sheets once and approve the permissions the functions need. Longwave stores the token encrypted and uses it only for calls you or your agents make. Disconnect it at any time in settings.

How do I use Google Sheets in Claude Code?

Add the Longwave MCP server once with claude mcp add --transport http longwave https://api.longwave.run/v1/mcp/tasks, sign in, and ask for what you need. Claude finds the right Google Sheets function and calls it.

Use Google Sheets in Longwave

Ask any Longwave thread for the result, or add Longwave to Claude Code, Codex, Cursor or ChatGPT.

Add to Longwave