MCP / Docs and productivity
Google Sheets MCP
Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps. Connect it to Claude, Codex, Cursor or any MCP client through one FlyMy.AI MCP.
Sign in once36 actionsDocs and productivityTop 20 on FlyMy.AI
Find my spreadsheet named Leads 2026 and read rows 2-50 of the first sheet.
Paste it into an assistant connected to FlyMy.AI. The agent picks the actions.
What Google Sheets MCP can do
36 actions in the FlyMy.AI catalog, the most used first. Your agent finds them through search_tools and calls the one the task needs.
| Action | What it does |
|---|---|
GOOGLESHEETS_BATCH_UPDATE | Updates a specified range in a google sheet with given values, or appends them as new rows if `first cell location` is omitted; ensure the target sheet exists and the spreadsheet contains at least... |
GOOGLESHEETS_BATCH_GET | Retrieves data from specified cell ranges in a google spreadsheet; ensure the spreadsheet has at least one worksheet and any explicitly referenced sheet names in ranges exist. |
GOOGLESHEETS_CREATE_GOOGLE_SHEET1 | Creates a new google spreadsheet in google drive using the provided title. |
GOOGLESHEETS_ADD_SHEET | Adds a new sheet (worksheet) to a spreadsheet. |
GOOGLESHEETS_SHEET_FROM_JSON | Creates a new google spreadsheet and populates its first worksheet from `sheet json`, which must be non-empty as its first item's keys establish the headers. |
GOOGLESHEETS_GET_SPREADSHEET_INFO | Retrieves comprehensive metadata for a google spreadsheet using its id, excluding cell data. |
GOOGLESHEETS_FORMAT_CELL | Applies text and background cell formatting to a specified range in a google sheets worksheet. |
GOOGLESHEETS_GET_SHEET_NAMES | Lists all worksheet names from a specified google spreadsheet (which must exist), useful for discovering sheets before further operations. |
GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND | Append values to a spreadsheet. |
GOOGLESHEETS_SEARCH_SPREADSHEETS | Search for google spreadsheets using various filters including name, content, date ranges, and more. |
GOOGLESHEETS_UPDATE_SHEET_PROPERTIES | Update properties of a sheet (worksheet) within a google spreadsheet, such as its title, index, visibility, tab color, or grid properties. |
GOOGLESHEETS_FIND_WORKSHEET_BY_TITLE | Finds a worksheet by its exact, case-sensitive title within a google spreadsheet; returns a boolean indicating if found and the complete metadata of the entire spreadsheet, regardless of whether... |
Show all 36 actions
| Action | What it does |
|---|---|
GOOGLESHEETS_APPEND_DIMENSION | Append new rows or columns to a sheet, increasing its size. |
GOOGLESHEETS_AGGREGATE_COLUMN_DATA | Searches for rows where a specific column matches a value and performs mathematical operations on data from another column. |
GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER | Update values in ranges matching data filters. |
GOOGLESHEETS_CLEAR_BASIC_FILTER | Clear the basic filter from a sheet. |
GOOGLESHEETS_CLEAR_VALUES | Clears cell content (preserving formatting and notes) from a specified a1 notation range in a google spreadsheet; the range must correspond to an existing sheet and cells. |
GOOGLESHEETS_CREATE_CHART | Create a chart in a google sheets spreadsheet using the specified data range and chart type. |
GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN | Creates a new column in a google spreadsheet, requiring a valid `spreadsheet id` and an existing `sheet id`; an out-of-bounds `insert index` may append/prepend the column. |
GOOGLESHEETS_CREATE_SPREADSHEET_ROW | Inserts a new, empty row into a specified sheet of a google spreadsheet at a given index, optionally inheriting formatting from the row above. |
GOOGLESHEETS_DELETE_DIMENSION | Delete specified rows or columns from a sheet in a google spreadsheet. |
GOOGLESHEETS_DELETE_SHEET | Delete a sheet (worksheet) from a spreadsheet. |
GOOGLESHEETS_EXECUTE_SQL | Execute sql queries against google sheets tables. |
GOOGLESHEETS_GET_SPREADSHEET_BY_DATA_FILTER | Returns the spreadsheet at the given id, filtered by the specified data filters. |
GOOGLESHEETS_GET_TABLE_SCHEMA | This action is used to get the schema of a table in a google spreadsheet, call this action to get the schema of a table in a spreadsheet before you query the table. |
GOOGLESHEETS_INSERT_DIMENSION | Insert new rows or columns into a sheet at a specified location. |
GOOGLESHEETS_LIST_TABLES | This action is used to list all tables in a google spreadsheet, call this action to get the list of tables in a spreadsheet. |
GOOGLESHEETS_LOOKUP_SPREADSHEET_ROW | Finds the first row in a google spreadsheet where a cell's entire content exactly matches the query string, searching within a specified a1 notation range or the first sheet by default. |
GOOGLESHEETS_QUERY_TABLE | This action is used to query a table in a google spreadsheet, call this action to query a table in a spreadsheet. |
GOOGLESHEETS_SEARCH_DEVELOPER_METADATA | Search for developer metadata in a spreadsheet. |
GOOGLESHEETS_SET_BASIC_FILTER | Set a basic filter on a sheet in a google spreadsheet. |
GOOGLESHEETS_SPREADSHEETS_SHEETS_COPY_TO | Copy a single sheet from a spreadsheet to another spreadsheet. |
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR | Clear one or more ranges of values from a spreadsheet. |
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_CLEAR_BY_DATA_FILTER | Clears one or more ranges of values from a spreadsheet using data filters. |
GOOGLESHEETS_SPREADSHEETS_VALUES_BATCH_GET_BY_DATA_FILTER | Return one or more ranges of values from a spreadsheet that match the specified data filters. |
GOOGLESHEETS_UPDATE_SPREADSHEET_PROPERTIES | Update properties of a spreadsheet, such as its title, locale, or auto-recalculation settings. |
Ask your agent
Requests to paste as they are. Each one runs on the actions named under it.
“Find my spreadsheet named Leads 2026 and read rows 2-50 of the first sheet.”uses
GOOGLESHEETS_SEARCH_SPREADSHEETS, GOOGLESHEETS_BATCH_GET“Create a spreadsheet called Competitor prices from this table of products and prices.”uses
GOOGLESHEETS_SHEET_FROM_JSON“Append today's signups (date, email, plan) as new rows to the Signups sheet.”uses
GOOGLESHEETS_SPREADSHEETS_VALUES_APPEND“Add a tab called Summary and make its header row bold.”uses
GOOGLESHEETS_ADD_SHEET, GOOGLESHEETS_FORMAT_CELLConnect Google Sheets in a minute
One MCP for every integration. Add it once, then every MCP in the catalog is a request away.
- 01
Add FlyMy.AI
Add the FlyMy.AI MCP to your assistant with one of the commands below and sign in. No key to copy.
- 02
Sign in to Google Sheets
Open the Google Sheets connection settings and sign in once. Your agent then works as your account; the token stays with FlyMy.AI, never in a prompt or a chat.
- 03
Ask
Paste a request from this page. Every run shows what it cost.
Claude Code
claude mcp add --transport http flymyai https://mcp-agents.flymy.ai/mcp
Then run /mcp in Claude Code and sign in.
Codex
codex mcp add flymy --url https://mcp-agents.flymy.ai/mcp
Then run codex mcp login flymy to sign in.
claude.ai and Claude Desktop
https://mcp-agents.flymy.ai/mcp
Settings, Connectors, Add custom connector: paste this URL.
Pay per run
FlyMy.AI bills the run: the model and the tool's seconds. Calls go to your own Google Sheets account, under its plan and limits. No seats and no minimum.
Go to the source
From the FlyMy.AI platform catalog of 2026-10-28: name, description, actions and setup as the platform lists them. Examples are requests to paste, not recorded runs.