Google Sheets

AllMCP gives your agent a full set of Google Sheets and Google Drive tools: read and write cells, manage tabs, format ranges, add charts, share files, export, and more.

All providers How connecting works

---

Point your client at AllMCP

Connect your MCP client to the AllMCP endpoint and authenticate with your API key.

https://go.allmcp.co/mcp/

Send your key on every request using either header:

X-API-Key: allmcp_xxx

Authorization: Bearer allmcp_xxx

If you run agents for more than one of your own customers, add ?user_id=... (and optionally ?org_id=...) to the endpoint URL so each customer’s Google connection stays separate.

---

Connect

Google Sheets uses OAuth2, so there are no tokens to copy by hand.

1. Ask your agent to connect Google Sheets

   Tell your agent to connect the google_sheets provider. It returns a secure Google sign-in link.

2. Grant access in your browser

   Open the link, sign in to Google, and approve the requested access. That is the only manual step.

Tip

AllMCP handles consent and token refresh for you. Once you have approved access in Google, your agent stays connected. You only need to sign in again if you revoke access from your Google account.

---

Tools by category

Once you are connected, your agent can use the Google Sheets tools below. The categories show what it can do for you.

Files

Drive-side file operations (the Sheets API has no list endpoint of its own).

Tool	Description
google_sheets_list_spreadsheets	Lists the spreadsheets you have access to in Google Drive.
google_sheets_get_file_metadata	Returns file-level details for one spreadsheet, such as its name, owner, and timestamps.
google_sheets_create_spreadsheet	Creates a brand-new, empty spreadsheet.
google_sheets_copy_spreadsheet	Makes a duplicate copy of an existing spreadsheet.
google_sheets_rename_spreadsheet	Changes the title of an existing spreadsheet.
google_sheets_trash_spreadsheet	Moves a spreadsheet to the Drive trash, where it can still be recovered.
google_sheets_untrash_spreadsheet	Restores a spreadsheet that was previously moved to the trash.
google_sheets_delete_spreadsheet	Permanently deletes a spreadsheet, bypassing the trash — this cannot be undone.

Values

Read and write cell data.

Tool	Description
google_sheets_values_get	Reads the values from a single range of cells.
google_sheets_values_update	Writes values into a single range of cells.
google_sheets_values_append	Adds new rows of data to the end of a sheet.
google_sheets_values_clear	Clears the values from a range of cells.
google_sheets_values_batch_get	Reads several ranges of cells in a single request.
google_sheets_values_batch_update	Writes to several ranges of cells in a single request.
google_sheets_values_batch_clear	Clears several ranges of cells in a single request.
google_sheets_values_batch_get_by_data_filter	Reads ranges selected by a data filter rather than by fixed cell addresses.
google_sheets_values_batch_update_by_data_filter	Writes to ranges selected by a data filter rather than by fixed cell addresses.
google_sheets_values_batch_clear_by_data_filter	Clears ranges selected by a data filter rather than by fixed cell addresses.

Metadata

Read spreadsheet structure (sheet names, IDs, dimensions).

Tool	Description
google_sheets_get_spreadsheet	Returns the full structure of a spreadsheet, including every tab and its dimensions.
google_sheets_get_by_data_filter	Returns spreadsheet structure for only the parts that match a data filter.

Sheets (tab management)

Add, delete, duplicate, rename, and reorder the tabs within a spreadsheet.

Dimensions

Insert, delete, and resize rows and columns.

Formatting

Format ranges, merge and unmerge cells, and set data validation rules.

Conditional

Create, update, and delete conditional formatting rules.

Filters & Sort

Apply basic filters, save filter views, and sort ranges.

Charts

Create, update, and delete charts.

Sharing

Manage who a spreadsheet is shared with and at what access level.

Export

Export a spreadsheet to CSV, XLSX, or PDF.

Tables

Create, update, and delete structured tables (a 2024+ Google Sheets feature).

Find & Replace

Find and replace text, trim whitespace, and remove duplicate rows.

Named Ranges

Create, update, and delete named ranges.

Protection

Create, update, and delete protected ranges that restrict who can edit them.

Developer Metadata

Attach and manage custom key-value annotations on a spreadsheet, sheet, or range.

---

Common workflows

Just describe what you want in plain language — your agent picks the right tools.

Read a spreadsheet

Read cells A1:D10 from the sheet "Sales Q1" in spreadsheet ID 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms

Write data

Update cells B2:B6 in sheet "Forecast" to the values [100, 200, 150, 300, 250]

Create a report

Create a new spreadsheet called "Weekly Report", add a sheet named "Deals", and write the headers: Date, Name, Amount, Stage

Export

Export spreadsheet ID abc123 to CSV

---

Notes

Note

Finding the spreadsheet ID. Spreadsheet IDs appear in the Google Sheets URL: https://docs.google.com/spreadsheets/d/{ID}/edit

Caution

Large reads. For very large reads (more than 10,000 cells), ask your agent to fetch multiple ranges in one batch — it is faster and more reliable.

---

See also

All providers Browse every connected provider.

System tools The always-on tools every connection ships with.