Overview
The Google Sheets server enables AI assistants to interact with Google Sheets, providing comprehensive spreadsheet management including data reading and writing, range operations, spreadsheet creation, and collaboration features through the Google Sheets API.How to Add Google Sheets
Authorize
Simply log in with your Google account and approve the OAuth consent request. No admin approval needed.
Simple OAuth Consent: Google Sheets uses standard Google OAuth consent. Works with personal Google accounts and Google Workspace without special admin approval.
What You Can Do
Spreadsheet Discovery
List accessible spreadsheets and get spreadsheet information
Data Operations
Read and modify cell values with range-based operations
Spreadsheet Creation
Create new spreadsheets and add sheets within existing ones
Collaboration
Read, create, reply to, and resolve spreadsheet comments
Available Tools (10)
Spreadsheet Operations
list_spreadsheets
list_spreadsheets
List spreadsheets from Google Drive that the user has access to. Returns spreadsheet names, IDs, modified times, and Drive web links. Defaults to 25 spreadsheets maximum.
get_spreadsheet_info
get_spreadsheet_info
Get detailed information about a specific spreadsheet including its title and list of sheets with their IDs and dimensions.
create_spreadsheet
create_spreadsheet
Create a new Google Spreadsheet with a title and optional list of sheet names. Returns spreadsheet ID and URL.
create_sheet
create_sheet
Create a new sheet (tab) within an existing spreadsheet by specifying the sheet name.
Data Operations
read_sheet_values
read_sheet_values
Read values from a specific range in a Google Sheet using A1 notation (e.g., “Sheet1!A1:D10”). Defaults to “A1:Z1000” if range not specified.
modify_sheet_values
modify_sheet_values
Modify values in a specific range - can write, update, or clear values. Supports value input options: “RAW” (no parsing) or “USER_ENTERED” (formulas evaluated). Can clear ranges by setting clear_values parameter.
Comment Operations
read_spreadsheet_comments
read_spreadsheet_comments
Read all comments from a Google Spreadsheet including author, creation time, and content.
create_spreadsheet_comment
create_spreadsheet_comment
Create a new comment on a Google Spreadsheet with specified content.
reply_to_spreadsheet_comment
reply_to_spreadsheet_comment
resolve_spreadsheet_comment
resolve_spreadsheet_comment
Resolve a comment in a Google Spreadsheet to mark it as complete.
Use Cases
Spreadsheet Discovery
“Show me all my Google Sheets” - List accessible spreadsheets with metadata and links.Spreadsheet Details
“Get information about the Budget 2024 spreadsheet” - View sheet names and structure.Reading Data
“Read values from cells A1 to D10 in the Sales sheet” - Extract data from specific ranges.Reading Large Ranges
“Read all data from the Data sheet” - Uses default range A1:Z1000 for comprehensive data retrieval.Writing Data
“Write ‘Q1 Sales’ to cell A1 and ‘50000’ to cell B1” - Update cell values in specified ranges.Formula Entry
“Add formula ‘=SUM(A1:A10)’ to cell A11 with USER_ENTERED mode” - Insert formulas that evaluate automatically.Clearing Data
“Clear values in range A1:D10” - Remove data from specified cells using clear_values parameter.Spreadsheet Creation
“Create a new spreadsheet called ‘Monthly Budget’ with sheets for each month” - Generate new spreadsheets with multiple sheets.Adding Sheets
“Add a new sheet called ‘Q4 Data’ to the existing spreadsheet” - Expand spreadsheets with additional tabs.Reading Comments
“Show me all comments in the Project Tracker spreadsheet” - View collaboration feedback.Adding Comments
“Add a comment saying ‘Please verify these numbers’” - Provide feedback on spreadsheet data.Comment Threads
“Reply to comment ABC123 with ‘Verified and approved’” - Participate in spreadsheet discussions.Resolving Comments
“Mark comment XYZ789 as resolved” - Complete feedback loops.Range Notation: Uses A1 notation for specifying cell ranges. Format: “Sheet1!A1:D10” (with sheet name) or “A1:D10” (default sheet). Default range is “A1:Z1000” if not specified.Value Input Options:
- “RAW”: Values stored as-is without parsing
- “USER_ENTERED”: Formulas and formatted values are parsed as if entered by user (default)
Guardrails
In addition to the 14 universal guardrails, this server has 42 server-specific guardrails across 7 operations.| Guardrail | Operation | Timing | Description |
|---|---|---|---|
| Block Sheet Creation in Protected Spreadsheets | create_sheet | Request | Prevents adding new sheets to specific protected spreadsheets |
| Limit Sheet Creation Count | create_spreadsheet | Request | Caps the number of sheets that can be created in a new spreadsheet |
| Block Comments on Protected Spreadsheets | create_spreadsheet_comment | Request | Prevents creating comments on specific protected spreadsheets |
| Block Comments with URLs | create_spreadsheet_comment | Request | Prevents creating comments containing URLs or external links |
| Limit Comment Length | create_spreadsheet_comment | Request | Caps the maximum length of comment content |
| Block Specific Spreadsheet IDs | get_spreadsheet_info | Request | Denies access to blocklisted spreadsheets by their IDs |
| Hide Sensitive Sheet Names | get_spreadsheet_info | Response | Redacts sheet names containing sensitive keywords |
| Filter Sensitive Spreadsheet Names | list_spreadsheets | Response | Hides spreadsheets containing sensitive keywords in their names |
| Hide Old Spreadsheets | list_spreadsheets | Response | Filters out spreadsheets older than a specified date |
| Limit Spreadsheet Results | list_spreadsheets | Request | Caps the maximum number of spreadsheets returned |
| Restrict to Allowed Spreadsheets | list_spreadsheets | Request | Only allows listing/accessing spreadsheets in a whitelist |
| Block Formula Injection | modify_sheet_values | Request | Prevents writing formulas or scripts that could be malicious |
| Block Modification of Protected Spreadsheets | modify_sheet_values | Request | Prevents any modification to specific critical spreadsheets |
| Block Protected Range Modification | modify_sheet_values | Request | Prevents editing specific protected ranges |
| Limit Write Data Size | modify_sheet_values | Request | Caps the amount of data that can be written in a single request |
| Prevent Data Overwrite | modify_sheet_values | Request | Only allows writing to empty cells, prevents overwriting existing data |
| Prevent Large Range Clear | modify_sheet_values | Request | Blocks clearing ranges exceeding a maximum cell count |
| Restrict Input Option to RAW | modify_sheet_values | Request | Forces value_input_option to RAW to prevent formula evaluation |
| Block Content Access for Dangerous Formats | read_sheet_values | Response | Blocks accessing content of files with dangerous formats |
| Block Full Spreadsheet Read | read_sheet_values | Request | Prevents reading entire spreadsheet with unbounded ranges |
| Block Reading Specific Sheet Names | read_sheet_values | Request | Prevents reading from sheets with certain names |
| Filter Formula Values | read_sheet_values | Response | Hides formulas to prevent revealing business logic |
| Hide Cells Matching Patterns | read_sheet_values | Response | Redacts cells containing values matching specified regex patterns |
| Redact PII in Cells | read_sheet_values | Response | Masks PII like SSNs, emails, and phone numbers in cells |
| Restrict Range Size | read_sheet_values | Request | Limits the maximum number of cells that can be read in a single request |
| Block Comments from Protected Spreadsheets | read_spreadsheet_comments | Request | Prevents reading comments from specific sensitive spreadsheets |
| Filter Comments by Allowed Authors | read_spreadsheet_comments | Response | Redacts comments from authors not in allowed list |
| Filter Sensitive Comments | read_spreadsheet_comments | Response | Redacts comments containing sensitive keywords |
| Hide Commenter Identity | read_spreadsheet_comments | Response | Removes email addresses and names from comment data |
| Limit to Recent Comments | read_spreadsheet_comments | Response | Only shows comments from within a specified time period |
| Block Replies to Old Comments | reply_to_spreadsheet_comment | Request | Prevents replying to comments older than a specified time period |
| Limit Reply Length | reply_to_spreadsheet_comment | Request | Caps the maximum length of reply content |
| Author Only Comment Resolution | resolve_spreadsheet_comment | Request | Only allows the original comment author to resolve their comments |