Skip to content
actionlake
Start free

Connectors · Files & documents

Google Sheets MCP server for AI agents.

actionlake is an MCP gateway: one remote MCP server that connects Claude and other MCP clients to Google Sheets and the rest of your systems. It gives your agent 87 Google Sheets actions (7 reads, 61 writes and 19 that wait for a confirmation) and holds the Google Sheets credential itself, so the agent never does. It paces Google Sheets's limits and records every call. Connecting Google Sheets needs your own Google Sheets OAuth app and one admin sign-in.

Connect Google Sheets freeSee pricing

100,000 free calls a month. No card, no email, no password: press Start a free sandbox on the next screen and keep the key it shows you.

claude mcp add --transport http actionlake https://connect.actionlake.com/mcp
the first call
do {  action: "gws_sheets.spreadsheets.get",  intent: "check which Google Sheets account is connected"}# Get a spreadsheet · read · 1 upstream call
  • 87actionsin one signed file
  • 7readlook, never change
  • 61writecreate and update
  • 19wait for a yesdestructive, confirmed first

Set up

Connect Google Sheets in three steps.

  1. 01

    Add actionlake to Claude.

    Run the command once in Claude Code; its consent page can create a free sandbox: 100,000 calls a month, no card. In the Claude app, add a custom connector with the URL below and paste your key on the consent page. Creating a new sandbox from the Claude app is not yet tested by us.

    https://connect.actionlake.com/mcp
  2. 02

    Connect Google Sheets.

    OAuth 2.0, authorization code with PKCE. You register your own OAuth app with Google Sheets, an admin signs in once, and you paste the app's client id and secret and the tokens from that sign-in; actionlake renews the access token from then on. actionlake stores what you paste write-only, sealed under your tenant's key.

    Before the first sign-in, Google Sheets needs an OAuth app of your own, registered in its developer portal. actionlake has no Google Sheets app to lend you.

    • access_tokenAccess token from one sign-in with your own OAuth app
    • refresh_tokenRefresh token from the same sign-in; the access token is renewed from it
    • client_idGoogle OAuth client id
    • client_secretGoogle OAuth client secret
    account { op: "connections.requirements", service: "gws_sheets" }
# free: exactly what to paste, and what is found for you
  3. 03

    Make the first call. Check before a write.

    Ask in plain words; Claude picks the action. Before anything changes, check validates the call and prices it, for free.

    do    { action: "gws_sheets.spreadsheets.get" }# get a spreadsheet · read · 1 upstream callcheck { action: "gws_sheets.spreadsheets.create", input: { … } }# free: inputs, permissions, cost and confirmations, nothing sent

Google Sheets at a glance

Sign-in
OAuth 2.0, authorization code with PKCE. You register your own OAuth app with Google Sheets, an admin signs in once, and you paste the app's client id and secret and the tokens from that sign-in; actionlake renews the access token from then on.
You provide
access_tokenrefresh_tokenclient_idclient_secret
Limits we pace to
60 calls a minute, per connection
API covered
Google Sheets API 4sheets.googleapis.com/v4
Built from
Google Sheets's documentation, read 17 September 2026sheets.googleapis.comdevelopers.google.com
Service file
Version 2.0.0, signed (Ed25519)
Cached reads
7 of 7 reads, for up to an hour; a write clears what it affects
Ready-made plans
8 in the store
Shared entities
2, so ask can line Google Sheets up with your other systems
Data
Processed and stored in Sydney, Australia. No US region yet

Capabilities

What an AI agent can do in Google Sheets.

87 actions in 1 area. Every one carries its effect, so a key can allow the reads and hold the rest.

  • 7readlook, never change
  • 61writecreate and update
  • 19destructivewait for a confirmation

  1. Spreadsheets

    87

    7 read · 61 write · 19 destructive

    Get a spreadsheet · Create a spreadsheet · Add a sheet · Batch-update a spreadsheet (raw requests)

Top actions

The Google Sheets API, shaped for agents.

The ids your agent types, what each does, and the one name it shares with other systems. 33 of Google Sheets's 40 action names are shared with at least one other connector, so an agent learns them once.

ActionWhat it doesEffectSame name in
gws_sheets.spreadsheets.getGet a spreadsheetRead a spreadsheet's properties, its sheets and optionally its cell grid.readcontent.spreadsheet.get5 connectors
gws_sheets.spreadsheets.createCreate a spreadsheetCreate a new spreadsheet, optionally with named sheets already in it.writecontent.spreadsheet.create4 connectors
gws_sheets.sheets.addAdd a sheetAdd a new sheet (tab) to a spreadsheet.writecontent.sheet.create2 connectors
gws_sheets.sheets.copy_toCopy a sheet to another spreadsheetCopy one sheet (tab) into a different spreadsheet.writethis connector
gws_sheets.values.appendAppend rows to a sheetAdd rows after the last row of the table that the given range falls in.writecontent.cell_range.create3 connectors
gws_sheets.dimensions.appendAppend rows or columnsAdd empty rows or columns at the end of a sheet.writecontent.cell_range.create3 connectors
gws_sheets.charts.addAdd a chartEmbed a chart in a spreadsheet.writecontent.sheet_chart.create2 connectors
gws_sheets.conditional_formats.addAdd a conditional format ruleAdd a rule that colours cells when a condition holds.writethis connector
gws_sheets.charts.deleteDelete a chart or other embedded objectRemove an embedded chart, image or slicer by its object id.destructivecontent.sheet_chart.delete2 connectors
gws_sheets.protected_ranges.deleteRemove a protected rangeUnprotect a range by its protected-range id.destructivecontent.file_permission.remove20 connectors
gws_sheets.protected_ranges.addProtect a rangeStop anyone but named editors changing a range.writecontent.file_permission.add19 connectors
gws_sheets.filters.set_basicSet the basic filterApply a sheet's basic filter over a range, with optional sort and per-column criteria.writethis connector

Try it

Prompts to paste into Claude.

Each one names the Google Sheets actions it will call, so you know what it reads and what it changes before you send it.

  1. Readread

    Get a spreadsheet in Google Sheets and tell me what stands out.

    callsgws_sheets.spreadsheets.get

  2. Planwrite

    Create a tracker workbook with a header row and frozen top row in Google Sheets.

    callsgws_sheets.spreadsheets.creategws_sheets.sheets.addgws_sheets.values.updategws_sheets.sheets.freezegws_sheets.filters.set_basic+1 more

  3. Planwrite

    Tidy a freshly imported range in Google Sheets.

    callsgws_sheets.values.getgws_sheets.cells.trim_whitespacegws_sheets.cells.text_to_columnsgws_sheets.cells.sort_rangegws_sheets.dimensions.auto_resize

  4. Writewrite

    Create a spreadsheet in Google Sheets. Show me exactly what you will send before you save it.

    callsgws_sheets.spreadsheets.create

The plan store

Ready-made plans for Google Sheets.

8 plans in the store. Install one and your agent runs it by name; the reply says which connections are still missing. A schedule can run a plan on a timetable. There are no triggers or webhooks, by design.

  1. Append a batch of rows after a human signs off

    Use it when A batch of rows should be added to an existing sheet but a person must approve the write before it happens.

    A person decidesAppend row count rows to range in spreadsheet spreadsheet id.

    Effect
    write
    Steps
    4
    Needs
    range, row count, rows and spreadsheet id
    Install
    gws_sheets-append-rows-with-approval

  2. Highlight overdue rows and restrict the status column

    Use it when A tracker tab should visually flag overdue rows and only accept known status values.

    Effect
    write
    Steps
    5
    Needs
    due formula, end column, end row, range a1, sheet id, spreadsheet id, start column, start row, status column and statuses
    Install
    gws_sheets-flag-overdue-with-formatting

  3. Refresh connected data sources and report the result

    Use it when A workbook backed by connected data sources needs refreshing and the caller wants the refreshed numbers, not a fire and forget refresh.

    Effect
    write
    Steps
    5
    Needs
    spreadsheet id and summary range
    Install
    gws_sheets-refresh-data-sources-report

  4. Tidy a freshly imported range

    Use it when Data has just been pasted or imported into a tab and needs whitespace trimmed, splitting and sorting before anyone works with it.

    Effect
    write
    Steps
    6
    Needs
    end column, end row, range a1, sheet id, sort column, spreadsheet id, start column and start row
    Install
    gws_sheets-clean-imported-range

  5. Snapshot a live tab into a dated archive tab

    Use it when A tab that keeps changing needs a frozen dated copy kept alongside it for the record.

    Effect
    write
    Steps
    6
    Needs
    sheet id, source range and spreadsheet id
    Install
    gws_sheets-monthly-snapshot-tab

  6. Create a tracker workbook with a header row and frozen top row

    Use it when Someone wants a fresh Google Sheet set up as a tracker with headers, a frozen header row and filters already in place.

    Effect
    write
    Steps
    6
    Needs
    column count, headers, tab title and title
    Install
    gws_sheets-new-tracker-workbook

  7. Clear several ranges once a human approves the deletion

    Use it when Cells in one or more ranges must be wiped and the deletion needs a captured copy and a human sign off first.

    A person decidesPermanently clear the ranges ranges in spreadsheet spreadsheet id. A copy has been read out first.

    Effect
    destructive
    Steps
    4
    Needs
    first range, ranges and spreadsheet id
    Install
    gws_sheets-purge-range-after-approval

  8. Copy tabs to an archive workbook then delete them after sign off

    Use it when Old tabs are cluttering a workbook and should be archived elsewhere and then removed with a human sign off.

    A person decidesDelete the tabs tab names from spreadsheet spreadsheet id. Copies are already in archive workbook archive spreadsheet id.

    Effect
    destructive
    Steps
    5 · loops
    Needs
    archive spreadsheet id, spreadsheet id, tab ids and tab names
    Install
    gws_sheets-retire-stale-tabs
install a plan
account { op: "plans.install", slug: "gws_sheets-append-rows-with-approval" }
# then ask for it by name; a schedule can run it on a timetable

Governance for Google Sheets

Destructive actions wait for a yes.

19 Google Sheets actions are destructive. These are all of them:

  • Delete a sheetgws_sheets.sheets.delete
  • Clear a range of cellsgws_sheets.values.clear
  • Delete a chart or other embedded objectgws_sheets.charts.delete
  • Delete rows or columnsgws_sheets.dimensions.delete
  • Remove a protected rangegws_sheets.protected_ranges.delete
  • Clear the basic filtergws_sheets.filters.clear_basic
  • Delete a conditional format rulegws_sheets.conditional_formats.delete
  • Delete a data sourcegws_sheets.data_sources.delete
  • Delete a tablegws_sheets.tables.delete
  • Delete cells in a rangegws_sheets.cells.delete_range
  • Clear several ranges at oncegws_sheets.values.batch_clear
  • Delete a named rangegws_sheets.named_ranges.delete
  • Remove duplicate rowsgws_sheets.cells.delete_duplicates
  • Ungroup rows or columnsgws_sheets.dimension_groups.delete
  • Clear ranges selected by data filtergws_sheets.values.batch_clear_by_data_filter
  • Remove alternating coloursgws_sheets.bandings.delete
  • Delete a filter viewgws_sheets.filter_views.delete
  • Delete developer metadatagws_sheets.developer_metadata.delete
  • Cancel a data source refreshgws_sheets.data_sources.cancel_refresh

A destructive action runs only with confirm: true. Under the human policy the agent cannot confirm for itself: the run stops until a named person approves, in the console or from a signed link in an email. The cap on a key is refused before the call is sent, never after.

dogws_sheets.sheets.deleteconfirm_policy: human

Delete a sheet?

intent: the user asked me to delete a sheet

run suspended · waiting for a named person · key gws-sheets-agent cannot confirm itself
In the console, or from an emailed signed link.
a key for this connector
account {  op: "keys.create", name: "gws-sheets-agent",  allowed_actions: ["gws_sheets.*"], cap_calls: 2000,  confirm_policy: "human_for_writes",  approval_rules: [    { match: "gws_sheets.sheets.delete", approver: "[email protected]" },    { match: "gws_sheets.values.clear", approver: "[email protected]" },    { match: "gws_sheets.charts.delete", approver: "[email protected]" }  ]}
Illustrative. Scoped to Google Sheets only, capped at 2,000 upstream calls, every write confirmed, and the destructive ones approved by a named person.

Cost

What Google Sheets costs on actionlake.

Every Google Sheets action is one upstream call, the only thing actionlake bills. Searching, check, cost, account and any call Google Sheets refused with 401, 403, 429 or a 5xx are free. Paid plans start at US$49 a month for 250,000 calls, with overage from US$0.30 down to US$0.18 per 1,000.

  • 1upstream call per actionall 87 Google Sheets actions
  • 87actions pageeach page of a long list is one call
  • 7reads can be cacheda cache hit costs nothing
  • 100,000calls a month, freepaid plans from US$49 a month for 250,000

See pricing

Action index

Every Google Sheets action.

87 actions by area: the id your agent calls, what it does, and its effect.

Spreadsheets87
  • gws_sheets.bandings.addAdd alternating colours to a rangewrite
  • gws_sheets.bandings.deleteRemove alternating coloursdestructive
  • gws_sheets.bandings.updateUpdate alternating colourswrite
  • gws_sheets.cells.appendAppend formatted rows to a sheetwrite
  • gws_sheets.cells.auto_fillAuto-fill a rangewrite
  • gws_sheets.cells.copy_pasteCopy and paste a rangewrite
  • gws_sheets.cells.cut_pasteCut and paste a rangewrite
  • gws_sheets.cells.delete_duplicatesRemove duplicate rowsdestructive
  • gws_sheets.cells.delete_rangeDelete cells in a rangedestructive
  • gws_sheets.cells.find_replaceFind and replacewrite
  • gws_sheets.cells.insert_rangeInsert cells into a rangewrite
  • gws_sheets.cells.mergeMerge cellswrite
  • gws_sheets.cells.paste_dataPaste delimited or HTML datawrite
  • gws_sheets.cells.randomizeShuffle the rows of a rangewrite
  • gws_sheets.cells.repeat_formatApply one cell format across a rangewrite
  • gws_sheets.cells.sort_rangeSort a rangewrite
  • gws_sheets.cells.text_to_columnsSplit text into columnswrite
  • gws_sheets.cells.trim_whitespaceTrim whitespace in a rangewrite
  • gws_sheets.cells.unmergeUnmerge cellswrite
  • gws_sheets.cells.updateWrite cell data with formattingwrite
  • gws_sheets.cells.update_bordersSet the borders of a rangewrite
  • gws_sheets.charts.addAdd a chartwrite
  • gws_sheets.charts.deleteDelete a chart or other embedded objectdestructive
  • gws_sheets.charts.moveMove or resize an embedded objectwrite
  • gws_sheets.charts.update_borderSet an embedded object's borderwrite
  • gws_sheets.charts.update_specUpdate a chart's specificationwrite
  • gws_sheets.conditional_formats.addAdd a conditional format rulewrite
  • gws_sheets.conditional_formats.deleteDelete a conditional format ruledestructive
  • gws_sheets.conditional_formats.updateUpdate a conditional format rulewrite
  • gws_sheets.data_sources.addAdd a data sourcewrite
  • gws_sheets.data_sources.cancel_refreshCancel a data source refreshdestructive
  • gws_sheets.data_sources.deleteDelete a data sourcedestructive
  • gws_sheets.data_sources.refreshRefresh a data sourcewrite
  • gws_sheets.data_sources.updateUpdate a data sourcewrite
  • gws_sheets.data_validation.setSet data validation on a rangewrite
  • gws_sheets.developer_metadata.createCreate developer metadatawrite
  • gws_sheets.developer_metadata.deleteDelete developer metadatadestructive
  • gws_sheets.developer_metadata.getGet developer metadataread
  • gws_sheets.developer_metadata.searchSearch developer metadataread
  • gws_sheets.developer_metadata.updateUpdate developer metadatawrite
  • gws_sheets.dimension_groups.addGroup rows or columnswrite
  • gws_sheets.dimension_groups.deleteUngroup rows or columnsdestructive
  • gws_sheets.dimension_groups.updateCollapse or expand a groupwrite
  • gws_sheets.dimensions.appendAppend rows or columnswrite
  • gws_sheets.dimensions.auto_resizeAuto-resize rows or columnswrite
  • gws_sheets.dimensions.deleteDelete rows or columnsdestructive
  • gws_sheets.dimensions.insertInsert rows or columnswrite
  • gws_sheets.dimensions.moveMove rows or columnswrite
  • gws_sheets.dimensions.update_propertiesResize or hide rows or columnswrite
  • gws_sheets.filter_views.addAdd a filter viewwrite
  • gws_sheets.filter_views.deleteDelete a filter viewdestructive
  • gws_sheets.filter_views.duplicateDuplicate a filter viewwrite
  • gws_sheets.filter_views.updateUpdate a filter viewwrite
  • gws_sheets.filters.clear_basicClear the basic filterdestructive
  • gws_sheets.filters.set_basicSet the basic filterwrite
  • gws_sheets.named_ranges.addAdd a named rangewrite
  • gws_sheets.named_ranges.deleteDelete a named rangedestructive
  • gws_sheets.named_ranges.updateUpdate a named rangewrite
  • gws_sheets.protected_ranges.addProtect a rangewrite
  • gws_sheets.protected_ranges.deleteRemove a protected rangedestructive
  • gws_sheets.protected_ranges.updateUpdate a protected rangewrite
  • gws_sheets.sheets.addAdd a sheetwrite
  • gws_sheets.sheets.copy_toCopy a sheet to another spreadsheetwrite
  • gws_sheets.sheets.deleteDelete a sheetdestructive
  • gws_sheets.sheets.duplicateDuplicate a sheetwrite
  • gws_sheets.sheets.freezeFreeze rows or columnswrite
  • gws_sheets.sheets.update_propertiesUpdate sheet propertieswrite
  • gws_sheets.slicers.addAdd a slicerwrite
  • gws_sheets.slicers.update_specUpdate a slicer's specificationwrite
  • gws_sheets.spreadsheets.batch_updateBatch-update a spreadsheet (raw requests)write
  • gws_sheets.spreadsheets.createCreate a spreadsheetwrite
  • gws_sheets.spreadsheets.getGet a spreadsheetread
  • gws_sheets.spreadsheets.get_by_data_filterGet a spreadsheet by data filterread
  • gws_sheets.spreadsheets.update_propertiesUpdate spreadsheet propertieswrite
  • gws_sheets.tables.addAdd a tablewrite
  • gws_sheets.tables.deleteDelete a tabledestructive
  • gws_sheets.tables.updateUpdate a tablewrite
  • gws_sheets.values.appendAppend rows to a sheetwrite
  • gws_sheets.values.batch_clearClear several ranges at oncedestructive
  • gws_sheets.values.batch_clear_by_data_filterClear ranges selected by data filterdestructive
  • gws_sheets.values.batch_getRead several ranges at onceread
  • gws_sheets.values.batch_get_by_data_filterRead ranges selected by data filterread
  • gws_sheets.values.batch_updateWrite several ranges at oncewrite
  • gws_sheets.values.batch_update_by_data_filterWrite ranges selected by data filterwrite
  • gws_sheets.values.clearClear a range of cellsdestructive
  • gws_sheets.values.getRead a range of cellsread
  • gws_sheets.values.updateWrite a range of cellswrite

Questions

The Google Sheets MCP server, answered.

Is there a Google Sheets MCP server for Claude?

Yes. actionlake is an MCP gateway: a remote MCP server that gives Claude, or another MCP client, 87 Google Sheets actions, through the same eight tools it uses for every other connector. actionlake is independent; it is not made or endorsed by Google Sheets.

What do I need to connect Google Sheets?

Your own Google Sheets OAuth app, registered with Google Sheets (its client id and client secret), and the access and refresh tokens from one admin sign-in. actionlake has no Google Sheets app of its own, so this is not a one-step consent. actionlake renews the access token as it expires. The free call account { op: "connections.requirements", service: "gws_sheets" } lists exactly what to paste.

Can an AI agent delete or change things in Google Sheets?

Only if its key allows it, and only with an explicit confirmation. 19 Google Sheets actions are destructive, including delete a sheet, clear a range of cells and delete a chart or other embedded object. Each runs only with confirm: true. Under the human confirm policy, or an approval rule on the key, the run waits until a named person approves it.

Will an AI agent use up my Google Sheets API limit?

actionlake paces every call to the limits in the Google Sheets service file: 60 calls a minute per connection. Repeated reads are answered from cache (7 Google Sheets actions can be), which never reaches Google Sheets.

What does a Google Sheets action cost?

One upstream call, the only unit actionlake bills. A list that pages bills one call per page (87 Google Sheets actions page). Cache hits, searches, dry runs and calls Google Sheets refused with 401, 403, 429 or a 5xx are free. The Free plan includes 100,000 calls a month with no card. Paid plans start at US$49 a month for 250,000 calls, with overage from US$0.30 down to US$0.18 per 1,000.

Which Google Sheets API does it cover?

The Google Sheets API 4 at sheets.googleapis.com/v4. It is built from Google Sheets's documentation as read on 17 September 2026. 87 actions in 1 area, each one in the signed service file (version 2.0.0).

Does actionlake keep my Google Sheets data, and where?

actionlake processes and stores data in Sydney, Australia; there is no US region yet. Reads may be cached for up to an hour, and a write clears the reads it affects. Each run's request and response is kept, sealed, for your plan's trace window: 1 day on Free, 3 days on Starter, 7 days on Pro, 14 days on Team, 30 days on Business and 30 days on Enterprise. Your Google Sheets credential is sealed under your tenant's key, never logged and never returned. Your traffic is not used to train models.

Which AI clients can use it?

Claude Code, tested by us end to end, and the Claude app as a custom connector, tested by us with an existing key. Other MCP clients that support remote servers over Streamable HTTP (MCP revisions 2025-06-18 and 2025-11-25) and OAuth dynamic client registration, or a bearer header, should connect the same way; we have not tested them. Or plain REST, under the same action names.

More connectors like Google Sheets

Shares the most action names with

Joins with, on shared entities

Browse

actionlake is independent. It is not made or endorsed by Google Sheets; the name is the vendor's own. Counts are from the Google Sheets service file, version 2.0.0.

Give your agent Google Sheets today.

Connect Google Sheets freeSee pricing

Start free - 100,000 calls/month, no card. No signup. Hard caps on every key. Cached answers are free.