Google Sheets
JSON →Integrate with Google Sheets to read, write, and manage spreadsheet data.
Install
npx mcp-gsheets@latest Tools · 6
- read_spreadsheet Read data from a Google Sheets spreadsheet
- write_spreadsheet Write data to a Google Sheets spreadsheet
- batch_update Perform batch operations on a Google Sheets spreadsheet
- format_cells Apply formatting to cells in a Google Sheets spreadsheet
- create_chart Create a chart in a Google Sheets spreadsheet
- conditional_formatting Apply conditional formatting rules to a Google Sheets spreadsheet
Environment variables
GOOGLE_PROJECT_IDGOOGLE_SERVICE_ACCOUNT_KEYGOOGLE_PRIVATE_KEYTEST_SPREADSHEET_IDSPREADSHEET_ID
Links
★ 69 GitHub stars