mcp-gsheets
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 |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| sheets_check_accessC | Check access permissions for a spreadsheet. Returns information about what operations are allowed. |
| sheets_get_valuesC | Get values from a specified range in a Google Sheets spreadsheet |
| sheets_batch_get_valuesC | Get values from multiple ranges in a Google Sheets spreadsheet |
| sheets_get_metadataC | Get metadata about a Google Sheets spreadsheet including sheet names, IDs, and properties |
| sheets_update_valuesA | Update values in a specified range of a Google Sheets spreadsheet. Examples:
|
| sheets_batch_update_valuesC | Update values in multiple ranges of a Google Sheets spreadsheet |
| sheets_append_valuesC | Append values to the end of a table in a Google Sheets spreadsheet |
| sheets_clear_valuesC | Clear values in a specified range of a Google Sheets spreadsheet |
| sheets_create_spreadsheetC | Create a new Google Sheets spreadsheet |
| sheets_insert_sheetC | Add a new sheet to an existing Google Sheets spreadsheet |
| sheets_delete_sheetC | Delete a sheet from a Google Sheets spreadsheet |
| sheets_duplicate_sheetC | Duplicate a sheet within a Google Sheets spreadsheet |
| sheets_copy_toC | Copy a sheet to another Google Sheets spreadsheet |
| sheets_update_sheet_propertiesC | Update properties of a sheet in a Google Sheets spreadsheet |
| sheets_format_cellsC | Format cells in a Google Sheet (colors, fonts, alignment, number formats) |
| sheets_update_bordersC | Update borders of cells in a Google Sheet |
| sheets_merge_cellsC | Merge cells in a Google Sheet |
| sheets_unmerge_cellsC | Unmerge cells in a Google Sheet |
| sheets_add_conditional_formattingC | Add conditional formatting rules to a Google Sheet |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/freema/mcp-gsheets'
If you have feedback or need assistance with the MCP directory API, please join our Discord server