Google Sheets guMCP Server

Tools

• Create-Sheet

  Creates a new Google Sheets document

• Add-Sheet

  Add a new sheet to an existing spreadsheet

• Get-Spreadsheet-Info

  Retrieves spreadsheet metadata (title, sheets, etc.)

• Get-Sheet-Names

  Lists all sheet (tab) names in a spreadsheet

• Batch-Get

  Reads values from multiple ranges

• Batch-Update

  Writes values to multiple ranges

• Append-Values

  Appends values to the end of a range (like inserting rows)

• Lookup-Row

  Searches for a row by column value in a specified range

• Clear-Values

  Clears values from a given range

• Copy-Sheet

  Copies a sheet from one spreadsheet to another