Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| GOOGLE_PROJECT_ID | Yes | Your Google Cloud project ID | |
| GOOGLE_APPLICATION_CREDENTIALS | Yes | Absolute path to your Google service account key JSON file |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| sheets_check_access | Check access permissions for a spreadsheet. Returns information about what operations are allowed. |
| sheets_get_values | Get values from a specified range in a Google Sheets spreadsheet |
| sheets_batch_get_values | Get values from multiple ranges in a Google Sheets spreadsheet |
| sheets_get_metadata | Get metadata about a Google Sheets spreadsheet including sheet names, IDs, and properties |
| sheets_update_values | Update values in a specified range of a Google Sheets spreadsheet. Examples:
|
| sheets_batch_update_values | Update values in multiple ranges of a Google Sheets spreadsheet |
| sheets_append_values | Append values to the end of a table in a Google Sheets spreadsheet |
| sheets_clear_values | Clear values in a specified range of a Google Sheets spreadsheet |
| sheets_create_spreadsheet | Create a new Google Sheets spreadsheet |
| sheets_insert_sheet | Add a new sheet to an existing Google Sheets spreadsheet |
| sheets_delete_sheet | Delete a sheet from a Google Sheets spreadsheet |
| sheets_duplicate_sheet | Duplicate a sheet within a Google Sheets spreadsheet |
| sheets_copy_to | Copy a sheet to another Google Sheets spreadsheet |
| sheets_update_sheet_properties | Update properties of a sheet in a Google Sheets spreadsheet |
| sheets_format_cells | Format cells in a Google Sheet (colors, fonts, alignment, number formats) |
| sheets_update_borders | Update borders of cells in a Google Sheet |
| sheets_merge_cells | Merge cells in a Google Sheet |
| sheets_unmerge_cells | Unmerge cells in a Google Sheet |
| sheets_add_conditional_formatting | Add conditional formatting rules to a Google Sheet |