google-docs-automation

Google Sheets automation reads, writes, and formats cells programmatically using gspread and the Google API client. You authorize with service account credentials, open a spreadsheet by key, and use worksheet methods to read values, update cells, and apply formatting without manual intervention.

Yes. This Skill automates document generation by reading data from Sheets, then creating and updating Google Docs content programmatically. A common workflow pulls raw data from a master spreadsheet and populates a formatted report document automatically.

Google Slides automation generates and modifies presentations programmatically using the Google API. You can insert data-driven content, create slide decks dynamically, and update existing presentations with live data pulled from Sheets or other sources.

Service account authentication is enforced for security. Credentials are managed via environment files (.env), which store API keys and secrets separately from code. This approach enforces minimal scope usage and keeps sensitive data out of your codebase.

Robust error handling and rate-limit backoff are built in. The Skill automatically detects rate-limit errors and implements exponential backoff to retry requests, ensuring reliable automation without manual intervention or data loss.

Yes. A typical workflow automates monthly financial reports by ingesting data from a master Sheet, updating a P&L statement in Docs, and generating a summary slide deck for stakeholders—all without manual steps.