VM0Agent Skills
Google Sheets
Read and write data in Google Sheets
Google Sheets is a spreadsheet application. This skill enables your agent to read data, update cells, and manage spreadsheets.
Required Environment
| Name | Type | Description |
|---|---|---|
GOOGLE_SHEETS_CLIENT_ID | var | OAuth client ID |
GOOGLE_SHEETS_CLIENT_SECRET | secret | OAuth client secret |
GOOGLE_SHEETS_REFRESH_TOKEN | secret | Refresh token |
See Google Cloud Console for how to obtain these credentials. Select the minimum scope required for your use case:
| Scope | Description |
|---|---|
https://www.googleapis.com/auth/spreadsheets.readonly | Read spreadsheets only |
https://www.googleapis.com/auth/spreadsheets | Full access (read and write) |
Configuration
version: "1.0"
agents:
my-agent:
framework: claude-code
skills:
- https://github.com/vm0-ai/vm0-skills/tree/main/google-sheetsRun
Store your secrets on the platform (recommended, one-time setup):
vm0 secret set GOOGLE_SHEETS_CLIENT_SECRET your-google-sheets-client-secret
vm0 secret set GOOGLE_SHEETS_REFRESH_TOKEN your-google-sheets-refresh-tokenThen run your agent - secrets are automatically loaded:
vm0 run my-agent "update the spreadsheet"For CI/CD or temporary overrides, pass secrets at runtime: --secrets GOOGLE_SHEETS_CLIENT_SECRET=value. See Environment Variables for details.
Example Instructions
# Report Generator
You use Google Sheets to create weekly reports.
## Workflow
1. Fetch data from various sources
2. Create new sheet for the week
3. Populate with formatted data
4. Add charts and summaries
## Sheet Structure
- Summary tab with KPIs
- Raw data tabs by category
- Charts for visualization# Data Sync Agent
You use Google Sheets to keep spreadsheets synchronized with databases.
## Workflow
1. Read data from the source spreadsheet
2. Compare with database records
3. Update changed rows
4. Log sync results
## Sync Rules
- Only sync rows with changes
- Preserve formatting
- Add timestamp to synced rows