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 |