Can I use this to create charts in Google Sheets?

Yes, it includes specific patterns and API request structures for generating LINE, BAR, and other chart types programmatically within your spreadsheets.

Is it possible to read and write document comments?

Yes, the skill includes patterns for interacting with the Google Drive API to list, read, and manage comments and feedback within Google Docs.

Does this skill support standard OAuth user credentials?

The skill prioritizes Service Account authentication for automation as it is more secure and reliable for server-side operations, avoiding the need for manual browser-based logins.

How does it handle API rate limits?

The skill provides implementation patterns for batch operations, such as worksheet.update_cells(), which minimize API calls and significantly improve performance for large datasets.

Google Workspace Automation

Name: Google Workspace Automation
Author: dbmcco

bydbmcco

•

生产力与工作流

Automates Google Docs, Sheets, and Slides operations using secure service account authentication and standardized implementation patterns.

The Google Workspace Automation skill provides Claude with specialized capabilities to interact programmatically with Google's productivity suite. It focuses on professional-grade integration practices, including service account authentication, environment variable management, and performance-optimized batch operations. By providing specific patterns for the gspread and googleapiclient libraries, it allows users to build robust financial models, automated reporting dashboards, and dynamic document generation workflows while adhering to strict security and rate-limiting guidelines.

主要功能

01Optimized batch update patterns to handle API rate limits and performance

02Dynamic Google Slides presentation creation from templates

036 GitHub stars

04Comprehensive Google Sheets control including formatting and chart creation

05Secure Service Account authentication and environment management

06Programmatic Google Docs generation and comment management

使用场景

01Synchronizing database records with shared Google Workspace documents for team collaboration

02Creating personalized client proposals and slide decks from external data

03Generating automated financial reports and dashboards in Google Sheets

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dbmcco/claude-agent-toolkit google-docs-automation

For use in Claude.ai and ChatGPT

Download Skill