google-docs-automation

What problem does it solve?

This Skill automates repetitive and time-consuming tasks across Google Docs, Sheets, and Slides, freeing you from manual data entry, formatting, and report generation.

Core Features & Use Cases

• Sheets Data Management: Read, write, format cells, and create dynamic charts in Google Sheets.
• Document Generation: Programmatically create, update, and format Google Docs content.
• Presentation Automation: Generate and modify Google Slides presentations with dynamic data.
• Use Case: Automatically generate monthly financial reports by pulling raw data from a master Google Sheet, updating a P&L statement in a Google Doc, and creating a summary slide deck for stakeholders.

Quick Start

Authorize and open a Google Sheet

import gspread gc = gspread.authorize(credentials) spreadsheet = gc.open_by_key(os.getenv('GOOGLE_SHEET_ID')) worksheet = spreadsheet.worksheet('Sheet1')

Read cell A1

value = worksheet.acell('A1').value

Write a new value to cell A1

worksheet.update_acell('A1', 'New Value')