# Google Sheets MCP for AI Agents | FlyMy.AI > Google Sheets MCP for Claude, Codex and Cursor through FlyMy.AI. Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data... Page: https://flymy.ai/mcp/google-sheets/ 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. [Connect Google Sheets](https://flymy.ai/mcp/google-sheets/#connect) [What it can do](https://flymy.ai/mcp/google-sheets/#actions) Sign in once, 36 actions, Docs and productivity, Top 20 on FlyMy.AI Ask your agent ``` 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_CELL` ## Connect Google Sheets in a minute One MCP for every integration. Add it once, then every MCP in the catalog is a request away. 1. 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. 2. 02 ### Sign in to Google Sheets Open the Google Sheets [connection settings](https://app.flymy.ai/mcp-configs#googlesheets) and sign in once. Your agent then works as your account; the token stays with FlyMy.AI, never in a prompt or a chat. 3. 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. [See usage pricing →](https://flymy.ai/pricing/) ## More Docs and productivity MCPs Docs, spreadsheets, tasks, projects, forms and files. ### Notion Notion pages/databases 21 actions / sign in Link: https://flymy.ai/mcp/notion/ ### Airtable Airtable bases on per-user OAuth: list bases and schema, read, create, update and delete records, comments, webhooks 9 actions / sign in Link: https://flymy.ai/mcp/airtable/ ### Google Drive Google Drive is a cloud storage solution for uploading, sharing, and collaborating on files across devices, with robust search and offline access 51 actions / sign in Link: https://docs.flymy.ai/mcp/apps/googledrive ### Api2Pdf Api2Pdf is a REST API that enables developers to generate PDFs from HTML, URLs, and various document formats using engines like wkhtmltopdf, Headless... 9 actions / your API key Link: https://docs.flymy.ai/mcp/apps/api2pdf ### Asana Asana work management: tasks, subtasks, projects, sections, portfolios, custom fields, comments and attachments on per-user OAuth 18 actions / sign in Link: https://docs.flymy.ai/mcp/asana ### Basin Basin is a no-code form backend that enables users to set up powerful, reliable forms quickly without writing server-side code 18 actions / your API key Link: https://docs.flymy.ai/mcp/apps/basin ## Go to the source [Google Sheets in the docs →](https://docs.flymy.ai/mcp/google-sheets), [Google Sheets connection settings →](https://app.flymy.ai/mcp-configs#googlesheets), [Google Sheets website →](https://sheets.google.com/), [Every MCP in the catalog →](https://flymy.ai/mcp/#catalog), [Usage pricing →](https://flymy.ai/pricing/) 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. --- For agents: the FlyMyAI operating guide (sign up, connect, run models, tools and agents) is https://flymy.ai/skill.md, and https://flymy.ai/llms.txt lists the other pages and the documentation.