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

14,194

batch_update

12,549

format_cell

5,196

get_sheet_names

1,717

add_sheet

1,471

spreadsheets_values_batch_get_by_data_filter

1,170

spreadsheets_values_append

1,152

batch_update_values_by_data_filter

1,108

get_spreadsheet_info

1,061

clear_values

647

update_sheet_properties

548

execute_sql

521

search_spreadsheets

477

create_google_sheet1

383

get_spreadsheet_by_data_filter

306

delete_dimension

293

spreadsheets_values_batch_clear

244

insert_dimension

234

list_tables

224

delete_sheet

215

query_table

211

lookup_spreadsheet_row

189

sheet_from_json

155

spreadsheets_sheets_copy_to

116

find_worksheet_by_title

104

append_dimension

create_chart

googlesheets__delete_dimension

get_table_schema

set_basic_filter

aggregate_column_data

spreadsheets_values_batch_clear_by_data_filter

create_spreadsheet_row

update_spreadsheet_properties

clear_basic_filter

create_spreadsheet_column

GOOGLESHEETS_SEARCH_SPREADSHEETS

get_spreadsheet

batch_update_spreadsheet

get_values

format_cells

freeze_rows

add_filter

search_developer_metadata

find_spreadsheet

authenticate

read_sheet

update_values

search_rows

list_sheets

CREATE_GOOGLE_SHEET

create_a_google_sheet

create_google_sheet

CREATE_A_GOOGLE_SHEET

GOOGLESHEETS_GET_SPREADSHEET_INFO

GOOGLESHEETS_CREATE_GOOGLE_SHEET

Total

45,043

Uptime (30d)100.0%

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

Usage

Integrate

Google Sheets

Performance

Performance

Usage

Top Clients

Daily Sessions

Usage

Integrate

Performance

Usage

Top Clients

Daily Sessions