Read, write and update your Google Sheets

Google Sheets guMCP Server

Additional properties for the spreadsheet (optional)

The sheets that should be created with the spreadsheet (optional)

The time zone of the new spreadsheet (e.g., 'America/New_York') (optional)

create-sheet

Details of the newly created spreadsheet including its ID, properties, sheets, and URLs

Whether to include filter views in the response (optional)

Whether to include grid data in the response (optional)

The ranges to retrieve from the spreadsheet (optional)

get-spreadsheet-info

Detailed metadata about the spreadsheet including ID, properties, and sheets

get-sheet-names

How dates, times, and durations should be represented (optional)

The major dimension of the values (optional, default: 'ROWS')

The ranges to retrieve from the spreadsheet (e.g. 'Sheet1!A1:C10')

How values should be rendered in the output (optional)

batch-get

Values from the requested ranges in the spreadsheet

Whether to include values in the response (optional)

How dates, times, and durations should be represented in the response (optional)

How values should be rendered in the response (optional)

How the input data should be interpreted (optional, default: 'RAW')

batch-update

Results of the batch update operation including total cells updated

How the input data should be inserted (optional)

The range to append to (e.g. 'Sheet1!A1')

append-values

Results of the append operation including the updated range and cell counts

The specific column index to search within (optional, 0-based)

Whether to require an exact match (optional, default: true)

The range to search within (e.g. 'Sheet1!A1:C10')

lookup-row

Results of the row lookup operation, including whether the value was found and the matching row data

The range to clear (e.g. 'Sheet1!A1:C10')

clear-values

Copy a sheet from one spreadsheet to another

The ID of the spreadsheet to copy the sheet to

The zero-based index where the new sheet should be inserted (optional)

The ID of the spreadsheet containing the sheet to copy

copy-sheet

Add a new sheet to an existing spreadsheet

The `properties` object for an AddSheetRequest — at minimum give a `title`, but you can include any sheet-level fields the API accepts.

add-sheet

Details of the new sheet: spreadsheetId, sheetId, sheetTitle, index, and spreadsheetUrl

Google Sheets guMCP Server

Tools

Create-Sheet

Get-Spreadsheet-Info

Get-Sheet-Names

Batch-Get

Batch-Update

Append-Values

Lookup-Row

Clear-Values

Copy-Sheet

Add-Sheet

Installation Steps

Create a Gumloop Account

Generate Your Server URL