Google Sheets
Connect to Google Sheets to perform spreadsheet management and data processing.
Key Features
- Spreadsheet creation and management
- Sheet data retrieval and updates
- Cell and range data batch processing
- Sheet copying, renaming, creation
- Row/column addition and management
- Spreadsheet sharing and permission settings
- Multiple spreadsheet simultaneous processing
Basic Information
Authentication Method
Authenticates using OAuth 2.0.
Required Permissions
https://www.googleapis.com/auth/spreadsheets: Full Google Sheets access permission
Supported MCP Tools
Data Retrieval
get_sheet_data
Retrieves data from a sheet in a specific spreadsheet.
get_multiple_sheet_data
Retrieves data from multiple specific ranges in Google Sheets.
get_multiple_spreadsheet_summary
Retrieves summary information of multiple Google Sheets.
Data Updates
update_cells
Updates cells in Google Sheets.
batch_update_cells
Batch updates multiple ranges in Google Sheets.
Sheet Structure Management
add_rows
Adds rows to a Google Sheets sheet.
add_columns
Adds columns to a Google Sheets sheet.
list_sheets
Retrieves list of all sheets in Google Sheets.
copy_sheet
Copies a sheet from one spreadsheet to another.
rename_sheet
Renames a sheet in Google Sheets.
create_sheet
Creates a new sheet tab in existing Google Sheets.
Spreadsheet Management
create_spreadsheet
Creates a new Google Sheets.
list_spreadsheets
Retrieves list of all spreadsheets in the configured Google Drive folder.
share_spreadsheet
Shares Google Sheets with multiple users via email.
Usage Example
For example,
- When you input “Retrieve data from A1:C10 range in the spreadsheet” as a prompt,
- The LLM calls the
get_sheet_datatool through MCP to retrieve data from that range. - Then, it responds in the chat based on the tool call results.
Notes
- Be careful when processing large amounts of data during batch updates.
- Verify appropriate permission settings when sharing spreadsheets.
- Use carefully when updating data as existing data may be overwritten.