Read, write, and analyze data in Google Sheets.
Add a note to a specific cell in a spreadsheet. A note is a small piece of text attached to a cell (shown with a black triangle) that appears when you hover over the cell. sheet_id_or_name takes precedence over sheet_position. If a sheet is not mentioned, then always assume the default sheet_position is sufficient.
Create a new spreadsheet with the provided title and data in its first sheet Returns the newly created spreadsheet's id and title
Generate a Google File Picker URL for user-driven file selection and authorization. This tool generates a URL that directs the end-user to a Google File Picker interface where where they can select or upload Google Drive files. Users can grant permission to access their Drive files, providing a secure and authorized way to interact with their files. This is particularly useful when prior tools (e.g., those accessing or modifying Google Docs, Google Sheets, etc.) encountered failures due to file non-existence (Requested entity was not found) or permission errors. Once the user completes the file picker flow, the prior tool can be retried. Suggest this tool to users when they are surprised or confused that the file they are searching for or attempting to access cannot be found.
Gets the specified range of cells from a single sheet in the spreadsheet. sheet_id_or_name takes precedence over sheet_position. If a sheet is not mentioned, then always assume the default sheet_position is sufficient.
Gets the metadata for a spreadsheet including the metadata for the sheets in the spreadsheet. Use this tool to get the name, position, ID, and URL of all sheets in a spreadsheet as well as the number of rows and columns in each sheet. Does not return the content/data of the sheets in the spreadsheet - only the metadata. Excludes spreadsheets that are in the trash.
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-03-06 | A+ | 96 | - | v1 |
Searches for spreadsheets in the user's Google Drive based on the titles and content and returns the title, ID, and URL for each matching spreadsheet. Does not return the content/data of the sheets in the spreadsheets - only the metadata. Excludes spreadsheets that are in the trash.
Write values to a Google Sheet using a flexible data format. sheet_id_or_name takes precedence over sheet_position. If a sheet is not mentioned, then always assume the default sheet_position is sufficient.
Get comprehensive user profile and Google Sheets environment information. This tool provides detailed information about the authenticated user including their name, email, profile picture, Google Sheets access permissions, and other important profile details from Google services.
Write a value to a single cell in a spreadsheet.