Google Sheets

Integrate

Integrate this server via the CLI, MCP SDK, or AI SDK. Smithery handles OAuth, token refresh, and session management for you.

Create API key Manage Connections

1. Install Smithery CLI

2. Create a namespace

3. Use this server

# Add this server
smithery mcp add googlesheets

# List available tools
smithery tool list {connection}

# Call a tool
smithery tool call {connection} {tool_name} '{"key": "value"}'

Read, write, and format spreadsheet data. Manage sheets, run formulas, and collaborate on structured data in real time.

Performance

Tool

Calls

batch_get

19,148

batch_update

15,190

format_cell

7,751

spreadsheets_values_batch_get_by_data_filter

2,452

spreadsheets_values_append

2,359

batch_update_values_by_data_filter

1,967

get_sheet_names

1,950

add_sheet

1,821

get_spreadsheet_info

1,812

clear_values

789

get_spreadsheet_by_data_filter

788

update_sheet_properties

710

lookup_spreadsheet_row

566

delete_dimension

550

execute_sql

519

search_spreadsheets

495

create_google_sheet1

455

aggregate_column_data

343

insert_dimension

322

query_table

287

delete_sheet

271

spreadsheets_values_batch_clear

265

sheet_from_json

203

list_tables

202

spreadsheets_sheets_copy_to

137

append_dimension

136

update_spreadsheet_properties

115

set_basic_filter

get_table_schema

create_chart

find_worksheet_by_title

googlesheets_format_cell

GOOGLESHEETS_FORMAT_CELL

spreadsheets_values_batch_clear_by_data_filter

create_spreadsheet_column

create_spreadsheet_row

GOOGLESHEETS_BATCH_GET

upsert_rows

list_spreadsheets

get_cell

googlesheets_update_sheet_properties

get_values

update_cells

get_spreadsheet

googlesheets_batch_get

spreadsheets_get

batch_update_spreadsheet

get_sheet_data

read_sheet

search_toolbox

list_sheets

clear_basic_filter

create_spreadsheet

spreadsheets_values_get

spreadsheets_batch_update

update_dimension_properties

search_developer_metadata

get

list

get_sheet

resize_dimension

get_spreadsheets

format_range

search_tools

repeat_cell

auto_resize

read_spreadsheet

spreadsheet_list

update_values

set_dropdown

set_column_width

batchupdate

get_spreadsheet_data

update_data_validation

__nonexistent_probe__

set_data_validation

spreadsheet_batch_update

set_cell_validation

add_validation_rule

update_dimensions

autoresize_dimensions

auto_resize_dimensions

dimension_properties

spreadsheets.values.get

batch_update_values

format_conditional_rule

sheets_list_spreadsheets

GOOGLESHEETS_ADD_SHEET

add_data_validation

GOOGLESHEETS_AGGREGATE_COLUMN_DATA

List available spreadsheets

googlesheets_get_spreadsheet_by_data_filter

googlesheets_batch_update

add_conditional_format_rule

googlesheets_spreadsheets_values_append

googlesheets_create_spreadsheet_row

spreadsheets_get_by_data_filter

googlesheets_update_spreadsheet_properties

Total

62,207

Uptime (30d)100.0%

Latency (30d)20ms p50

Integrate

Integrate this server via the CLI, MCP SDK, or AI SDK. Smithery handles OAuth, token refresh, and session management for you.

Create API key Manage Connections

1. Install Smithery CLI

2. Create a namespace

3. Use this server

# Add this server
smithery mcp add googlesheets

# List available tools
smithery tool list {connection}

# Call a tool
smithery tool call {connection} {tool_name} '{"key": "value"}'

Performance

Tool

Calls

batch_get

19,148

batch_update

15,190

format_cell

7,751

spreadsheets_values_batch_get_by_data_filter

2,452

spreadsheets_values_append

2,359

batch_update_values_by_data_filter

1,967

get_sheet_names

1,950

add_sheet

1,821

get_spreadsheet_info

1,812

clear_values

789

get_spreadsheet_by_data_filter

788

update_sheet_properties

710

lookup_spreadsheet_row

566

delete_dimension

550

execute_sql

519

search_spreadsheets

495

create_google_sheet1

455

aggregate_column_data

343

insert_dimension

322

query_table

287

delete_sheet

271

spreadsheets_values_batch_clear

265

sheet_from_json

203

list_tables

202

spreadsheets_sheets_copy_to

137

append_dimension

136

update_spreadsheet_properties

115

set_basic_filter

get_table_schema

create_chart

find_worksheet_by_title

googlesheets_format_cell

GOOGLESHEETS_FORMAT_CELL

spreadsheets_values_batch_clear_by_data_filter

create_spreadsheet_column

create_spreadsheet_row

GOOGLESHEETS_BATCH_GET

upsert_rows

list_spreadsheets

get_cell

googlesheets_update_sheet_properties

get_values

update_cells

get_spreadsheet

googlesheets_batch_get

spreadsheets_get

batch_update_spreadsheet

get_sheet_data

read_sheet

search_toolbox

list_sheets

clear_basic_filter

create_spreadsheet

spreadsheets_values_get

spreadsheets_batch_update

update_dimension_properties

search_developer_metadata

get

list

get_sheet

resize_dimension

get_spreadsheets

format_range

search_tools

repeat_cell

auto_resize

read_spreadsheet

spreadsheet_list

update_values

set_dropdown

set_column_width

batchupdate

get_spreadsheet_data

update_data_validation

__nonexistent_probe__

set_data_validation

spreadsheet_batch_update

set_cell_validation

add_validation_rule

update_dimensions

autoresize_dimensions

auto_resize_dimensions

dimension_properties

spreadsheets.values.get

batch_update_values

format_conditional_rule

sheets_list_spreadsheets

GOOGLESHEETS_ADD_SHEET

add_data_validation

GOOGLESHEETS_AGGREGATE_COLUMN_DATA

List available spreadsheets

googlesheets_get_spreadsheet_by_data_filter

googlesheets_batch_update

add_conditional_format_rule

googlesheets_spreadsheets_values_append

googlesheets_create_spreadsheet_row

spreadsheets_get_by_data_filter

googlesheets_update_spreadsheet_properties

Total

62,207

Uptime (30d)100.0%

Latency (30d)20ms p50

Performance

Usage

Integrate

Google Sheets

Performance

Performance

Usage

Top Clients

Daily Sessions

Usage

Integrate

Performance

Usage

Top Clients

Daily Sessions