google-sheets-skill_skill

Overview

This skill reads, writes, and manages Google Sheets via the Google Sheets API. It supports reading ranges or whole sheets, updating or appending rows, creating and deleting sheets, and exporting results as JSON. Setup uses Google OAuth credentials for secure access.

How this skill works

The skill authenticates with Google OAuth and calls the Google Sheets API to list spreadsheets, fetch sheet metadata, read cell ranges, overwrite or append values, and perform sheet-level operations (create, add, delete). Commands accept spreadsheet IDs and A1-style ranges and return JSON-formatted responses for easy integration. Credential setup is required once; subsequent requests reuse the authenticated session.

When to use it

• Import or export tabular data between apps and Google Sheets
• Automate writing reports, logs, or form results into a sheet
• Read specific ranges or entire sheets for analysis or downstream processing
• Create templates, add or remove tabs programmatically
• Append rows when collecting incremental records or events

Best practices

• Store and protect OAuth credentials; grant least-privilege scopes needed
• Use explicit spreadsheet IDs (from the URL) to avoid operating on the wrong file
• Prefer range-specific reads/writes to limit bandwidth and avoid accidental overwrites
• Validate and normalize data before writing to prevent schema drift in sheets
• Use append for adding records and write (overwrite) only when replacing known ranges

Example use cases

• Read a range like "Sheet1!A1:C10" to pull recent rows into a script
• Append new transaction records into a monthly sheet without touching existing data
• Create a new spreadsheet as a report template and populate headers and formulas
• Add or delete tabs to reorganize data programmatically during ETL
• Clear or overwrite a specific range to reset a dashboard section