Read and write Google Sheets spreadsheets - get content, update cells, append rows, fetch specific ranges, search for spreadsheets, and view metadata. Use when user asks to: read a spreadsheet, update cells, add data to Google Sheets, find a spreadsheet, check sheet contents, export spreadsheet data

Google Sheets Lightweight Google Sheets integration with standalone OAuth authentication. No MCP server required. Full read/write access. Requires Google Workspace account. Personal Gmail accounts are not supported. First Time Setup Authenticate with Google (opens browser): Check authentication status: Logout when needed: Read Commands All operations via scripts/sheets.py . Auto authenticates on first use if not logged in. Write Commands Spreadsheet ID You can use either: The spreadsheet ID: 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms The full URL: https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit The script automatically extracts the ID from URLs. Output Formats Text (default) Human readable format with pipe separators: CSV Standard CSV format, suitable for further processing: JSON Structured data format: A1 Notation Examples Sheet1!A1:B10 Range A1 to B10 on Sheet1 Sheet1!A:A All of column A on Sheet1 Sheet1!1:1 All of row 1 on Sheet1 A1:C5 Range on the first sheet Value Input Options USER ENTERED (default): Values are parsed as if typed by a user. Numbers, dates, and formulas are interpreted. RAW ( raw flag): Values are stored exactly as provided. No parsing of formulas or number formatting. Token Management Tokens stored securely using the system keyring: macOS : Keychain Windows : Windows Credential Locker Linux : Secret Service API (GNOME Keyring, KDE Wallet, etc.) Service name: google sheets skill oauth Tokens automatically refresh when expired using Google's cloud function.

google-sheets