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

18,262

batch_update

14,755

format_cell

7,786

spreadsheets_values_batch_get_by_data_filter

2,327

spreadsheets_values_append

2,306

get_sheet_names

1,884

batch_update_values_by_data_filter

1,853

add_sheet

1,800

get_spreadsheet_info

1,758

get_spreadsheet_by_data_filter

762

clear_values

721

update_sheet_properties

703

lookup_spreadsheet_row

556

delete_dimension

506

execute_sql

497

search_spreadsheets

488

create_google_sheet1

445

aggregate_column_data

324

insert_dimension

319

query_table

270

spreadsheets_values_batch_clear

266

delete_sheet

265

sheet_from_json

203

list_tables

195

append_dimension

134

spreadsheets_sheets_copy_to

131

update_spreadsheet_properties

113

set_basic_filter

get_table_schema

create_chart

find_worksheet_by_title

googlesheets_format_cell

GOOGLESHEETS_FORMAT_CELL

create_spreadsheet_column

spreadsheets_values_batch_clear_by_data_filter

create_spreadsheet_row

upsert_rows

list_spreadsheets

get_cell

GOOGLESHEETS_BATCH_GET

googlesheets_update_sheet_properties

get_values

update_cells

googlesheets_batch_get

spreadsheets_get

get_spreadsheet

batch_update_spreadsheet

get_sheet_data

read_sheet

search_toolbox

clear_basic_filter

create_spreadsheet

spreadsheets_values_get

spreadsheets_batch_update

update_dimension_properties

search_developer_metadata

get

get_sheet

resize_dimension

format_range

search_tools

repeat_cell

auto_resize

read_spreadsheet

update_values

set_dropdown

set_column_width

list_sheets

batchupdate

get_spreadsheet_data

update_data_validation

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

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

60,196

Uptime (30d)100.0%

Latency (30d)21ms 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

18,262

batch_update

14,755

format_cell

7,786

spreadsheets_values_batch_get_by_data_filter

2,327

spreadsheets_values_append

2,306

get_sheet_names

1,884

batch_update_values_by_data_filter

1,853

add_sheet

1,800

get_spreadsheet_info

1,758

get_spreadsheet_by_data_filter

762

clear_values

721

update_sheet_properties

703

lookup_spreadsheet_row

556

delete_dimension

506

execute_sql

497

search_spreadsheets

488

create_google_sheet1

445

aggregate_column_data

324

insert_dimension

319

query_table

270

spreadsheets_values_batch_clear

266

delete_sheet

265

sheet_from_json

203

list_tables

195

append_dimension

134

spreadsheets_sheets_copy_to

131

update_spreadsheet_properties

113

set_basic_filter

get_table_schema

create_chart

find_worksheet_by_title

googlesheets_format_cell

GOOGLESHEETS_FORMAT_CELL

create_spreadsheet_column

spreadsheets_values_batch_clear_by_data_filter

create_spreadsheet_row

upsert_rows

list_spreadsheets

get_cell

GOOGLESHEETS_BATCH_GET

googlesheets_update_sheet_properties

get_values

update_cells

googlesheets_batch_get

spreadsheets_get

get_spreadsheet

batch_update_spreadsheet

get_sheet_data

read_sheet

search_toolbox

clear_basic_filter

create_spreadsheet

spreadsheets_values_get

spreadsheets_batch_update

update_dimension_properties

search_developer_metadata

get

get_sheet

resize_dimension

format_range

search_tools

repeat_cell

auto_resize

read_spreadsheet

update_values

set_dropdown

set_column_width

list_sheets

batchupdate

get_spreadsheet_data

update_data_validation

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

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

60,196

Uptime (30d)100.0%

Latency (30d)21ms p50

Performance

Usage

Integrate

Google Sheets

Performance

Performance

Usage

Top Clients

Daily Sessions

Usage

Integrate

Performance

Usage

Top Clients

Daily Sessions