Google Sheets
Read, write, format, and analyze spreadsheet data through the Google Sheets API.
Overview
This skill teaches AI agents to work with Google Sheets — reading and writing cell data, formatting, creating charts, managing named ranges, and using formulas. Supports both simple value operations and complex batch updates.
Capabilities
Reading Data
- Read single cells, ranges, and multiple ranges in one call
- Get values with formatting metadata
- Read entire sheets or named ranges
- Choose value render options: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA
Writing Data
- Write to single cells or ranges
- Append rows to the end of a table
- Batch update multiple ranges in a single request
- Choose input options: RAW or USER_ENTERED
Formatting
- Set cell background colors, font styles, sizes, and colors
- Apply number formats (currency, percentage, dates, custom)
- Set borders, merge cells, alignment
- Apply conditional formatting rules and data validation
Sheet Management
- Create, rename, delete, and reorder sheets
- Copy sheets between spreadsheets
- Freeze rows and columns, hide/show elements
- Set sheet-level protection
Charts & Visualization
- Create embedded charts (bar, line, pie, scatter, area, combo)
- Configure chart titles, legends, axes, and data ranges
Authentication
Requires Google OAuth 2.0 with spreadsheets or spreadsheets.readonly scope.
Permissions
| Permission |
Scope |
Reason |
| Network |
*.googleapis.com |
Sheets API calls |
| Network |
accounts.google.com |
OAuth authentication |
| Filesystem |
Read ./** |
Read local CSV/data files |
| Subprocess |
None |
Not required |
Best Practices
- Use A1 notation for ranges — quote sheet names with spaces
- Batch operations to minimize API calls
- USER_ENTERED for formulas and dates
- Append, don't overwrite — use
values.append for adding rows
- Named ranges instead of hardcoded A1 references
1---2name: google-sheets3description: Google Sheets4---5# Google Sheets67Read, write, format, and analyze spreadsheet data through the Google Sheets API.89## Overview1011This skill teaches AI agents to work with Google Sheets — reading and writing cell data, formatting, creating charts, managing named ranges, and using formulas. Supports both simple value operations and complex batch updates.1213## Capabilities1415### Reading Data1617- Read single cells, ranges, and multiple ranges in one call18- Get values with formatting metadata19- Read entire sheets or named ranges20- Choose value render options: FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA2122### Writing Data2324- Write to single cells or ranges25- Append rows to the end of a table26- Batch update multiple ranges in a single request27- Choose input options: RAW or USER_ENTERED2829### Formatting3031- Set cell background colors, font styles, sizes, and colors32- Apply number formats (currency, percentage, dates, custom)33- Set borders, merge cells, alignment34- Apply conditional formatting rules and data validation3536### Sheet Management3738- Create, rename, delete, and reorder sheets39- Copy sheets between spreadsheets40- Freeze rows and columns, hide/show elements41- Set sheet-level protection4243### Charts & Visualization4445- Create embedded charts (bar, line, pie, scatter, area, combo)46- Configure chart titles, legends, axes, and data ranges4748## Authentication4950Requires Google OAuth 2.0 with `spreadsheets` or `spreadsheets.readonly` scope.5152## Permissions5354| Permission | Scope | Reason |55| ---------- | --------------------- | ------------------------- |56| Network | `*.googleapis.com` | Sheets API calls |57| Network | `accounts.google.com` | OAuth authentication |58| Filesystem | Read `./**` | Read local CSV/data files |59| Subprocess | None | Not required |6061## Best Practices62631. **Use A1 notation** for ranges — quote sheet names with spaces642. **Batch operations** to minimize API calls653. **USER_ENTERED** for formulas and dates664. **Append, don't overwrite** — use `values.append` for adding rows675. **Named ranges** instead of hardcoded A1 references
tankpkg