Google Sheets API release notes

Developer Preview: The Google Sheets Model Context Protocol (MCP) server now supports reading and managing spreadsheet comments:

• Include comments when retrieving a spreadsheet by setting the optional commentsIncluded field on the get_spreadsheet tool.
• Create, reply to, resolve or reopen, update, and delete comments and replies using the update_spreadsheet tool with the insertComment, addCommentReply, updateCommentPost, deleteComment, and deleteCommentReply operations.

To learn more, see Configure the Sheets MCP server and the Sheets MCP tool reference.

Developer Preview: The Google Sheets Model Context Protocol (MCP) server and its reference documentation include the following updates:

• Added the optional fields (field mask) and ranges (A1 or R1C1 notation) parameters to get_spreadsheet.
• Added the optional writeControl (WriteControl with requiredRevisionId) parameter to update_spreadsheet, along with inline request schemas in tool descriptions across the Sheets MCP reference pages.
• Expanded the Tool Annotations section across tool reference pages with definitions of readOnlyHint, destructiveHint, idempotentHint, and openWorldHint.

To learn more, see Configure the Sheets MCP server and the Sheets MCP tool reference.

Generally Available: You can now programmatically read, create, and manage comments in Google Sheets with the Google Sheets API. This includes:

• Reading comment threads and anchors by setting commentsViewMode in spreadsheets.get or spreadsheets.getByDataFilter.
• Creating comment threads and replying to comment threads using InsertCommentRequest and AddCommentReplyRequest.
• Modifying existing comment and reply posts using UpdateCommentPostRequest.
• Deleting comments and replies using DeleteCommentRequest and DeleteCommentReplyRequest.

For more information, see Manage comments.

Developer Preview: You can now programmatically create and manage comments in Google Sheets with the Google Sheets API. This includes:

• Creating comment threads and replying to comment threads using the InsertCommentRequest and AddCommentReplyRequest.

• Modifying existing comment and reply posts using UpdateCommentPostRequest.

• Deleting comments and replies using DeleteCommentRequest and DeleteCommentReplyRequest.

For more information, see Manage comments.

Developer Preview: The Model Context Protocol (MCP) server for Google Sheets is now available in developer preview. MCP is an open protocol that enables seamless integration between AI applications and your spreadsheets. By configuring the Sheets MCP server, you enable AI agents to securely interact with your spreadsheets and take actions, such as reading cell values or updating formulas.

To get started with the Sheets MCP server, see the following documentation:

• Set up the Sheets MCP server
• Sheets MCP tool reference

To find more available MCP servers, see Model Context Protocol (MCP) servers in Google Workspace.

Generally available: Create, update, and read Google Drive and People chips in Google Sheets API. To learn more, see Smart chips in the Sheets API documentation.

You can now create and modify tables, and take basic actions on tables using the Sheets API.

• Learn more about creating tables using the Sheets API
• Learn about the Table object in the Sheets API

Google Sheets API v3 is turned down. For more information, see Migrate from Sheets API v3.

Google Sheets API v4 is now available. For more information, see Introducing the Google Sheets API v4.