Google Sheets

Spreadsheet access for reading and managing sheets

OAuth8 toolshttps://sheets.googleapis.com/v4

GET

google_sheets_get_spreadsheet

Get metadata (sheets, properties) for a spreadsheet

/spreadsheets/{spreadsheetId}

2 parameters

Param	Type	Required	Description
spreadsheetId	string	required	Spreadsheet ID (from its URL)
includeGridData	boolean	optional	Include cell data in the response

POST

google_sheets_create_spreadsheet

Create a new spreadsheet

/spreadsheets

2 parameters

Param	Type	Required	Description
properties	object	optional	Spreadsheet properties, e.g. { title: 'My Sheet' }
sheets	array	optional	Initial sheets to create

GET

google_sheets_get_values

Read cell values from a range

/spreadsheets/{spreadsheetId}/values/{range}

3 parameters

Param	Type	Required	Description
spreadsheetId	string	required	Spreadsheet ID
range	string	required	A1 notation range, e.g. 'Sheet1!A1:D10'
valueRenderOption	string	optional	How values are rendered (FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA)

GET

google_sheets_batch_get_values

Read cell values from multiple ranges in one call

/spreadsheets/{spreadsheetId}/values:batchGet

3 parameters

Param	Type	Required	Description
spreadsheetId	string	required	Spreadsheet ID
ranges	array	required	A1 notation ranges to read
valueRenderOption	string	optional	How values are rendered

PUT

google_sheets_update_values

Overwrite cell values in a range

/spreadsheets/{spreadsheetId}/values/{range}

4 parameters

Param	Type	Required	Description
spreadsheetId	string	required	Spreadsheet ID
range	string	required	A1 notation range to write, e.g. 'Sheet1!A1'
valueInputOption	string	required	How input is interpreted (RAW or USER_ENTERED)
values	array	required	2D array of row values

POST

google_sheets_append_values

Append rows of values after the last row of data in a range

/spreadsheets/{spreadsheetId}/values/{range}:append

4 parameters

Param	Type	Required	Description
spreadsheetId	string	required	Spreadsheet ID
range	string	required	A1 notation range to search for a table, e.g. 'Sheet1!A1'
valueInputOption	string	required	How input is interpreted (RAW or USER_ENTERED)
values	array	required	2D array of row values to append

POST

google_sheets_clear_values

Clear cell values in a range (leaves formatting intact)

/spreadsheets/{spreadsheetId}/values/{range}:clear

2 parameters

Param	Type	Required	Description
spreadsheetId	string	required	Spreadsheet ID
range	string	required	A1 notation range to clear

POST

google_sheets_batch_update

Apply structural/formatting updates (add sheet, resize columns, etc.) in one atomic call

/spreadsheets/{spreadsheetId}:batchUpdate

2 parameters

Param	Type	Required	Description
spreadsheetId	string	required	Spreadsheet ID
requests	array	required	List of update request objects (addSheet, updateCells, etc.)