Skip to main content
Glama

mcp-gsheets

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
GOOGLE_PROJECT_IDYesYour Google Cloud project ID
GOOGLE_APPLICATION_CREDENTIALSYesAbsolute path to your Google service account key JSON file

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
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:

  • Fixed range "A1" - must provide exactly 3 rows
  • Flexible range "A1" - will expand to fit all provided rows
  • To update rows 42-74 (33 rows), use "A42" not "A42" IMPORTANT: Empty rows in your data array still count as rows!
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

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