Recipe Generate Report From Sheet
Turn Google Sheets rows into a shareable Google Docs report with Drive permissions in one agent-guided recipe.
Overview
recipe-generate-report-from-sheet is an agent skill for the Grow phase that reads a Google Sheet range and creates a formatted, shareable Google Docs report via the gws CLI.
Install
npx skills add https://github.com/googleworkspace/cli --skill recipe-generate-report-from-sheetWhat is this skill?
- Four-step gws CLI recipe: read Sheet range, create Doc, write formatted markdown body, grant Drive reader access
- Hard prerequisite chain: load gws-sheets, gws-docs, and gws-drive before execution
- Parameterized spreadsheet ID, range (e.g. Sales!A1:D), doc title, and stakeholder email
- Outputs a live Google Doc ID ready for CFO or team sharing via permissions API
- 4-step recipe
- 3 prerequisite gws skills
Adoption & trust: 15.8k installs on skills.sh; 26.9k GitHub stars; 3/3 security scanners passed (skills.sh audits).
What problem does it solve?
You track metrics in Google Sheets but waste time reformatting and emailing static summaries to people who expect a proper Doc.
Who is it for?
Solo founders who already use Google Workspace and want agent-driven sheet-to-doc reporting with explicit share steps.
Skip if: Teams without gws installed, non-Google stacks, or workflows that need PDF exports, charts, or automated scheduling without Sheets/Docs APIs.
When should I use this skill?
You need to read Google Sheet data and produce a formatted Google Docs report with stakeholder sharing via gws.
What do I get? / Deliverables
You end with a titled Google Doc containing structured report text and reader permissions for stakeholders, without leaving the agent workflow.
- Google Doc with formatted report body
- Drive reader permission for specified user email
Recommended Skills
Journey fit
Canonical shelf is Grow because the outcome is stakeholder-facing reporting and metrics narrative from sheet data, not building the sheet integration itself. Analytics fits recurring report generation from structured sheet ranges (sales, KPIs) for founders who already track numbers in Sheets.
How it compares
Use as a fixed multi-skill recipe instead of asking the agent to improvise separate Sheets and Docs API calls.
Common Questions / FAQ
Who is recipe-generate-report-from-sheet for?
Indie builders and small teams on Google Workspace who generate recurring reports from spreadsheet data and want Docs plus Drive sharing in one guided flow.
When should I use recipe-generate-report-from-sheet?
Use in Grow when you need analytics-style summaries from Sheet tabs (sales, pipeline, ops metrics), after gws-sheets, gws-docs, and gws-drive are loaded and you have spreadsheet and range IDs.
Is recipe-generate-report-from-sheet safe to install?
Review the Security Audits panel on this Prism page for install risk and file integrity; the recipe issues Drive permission grants and writes Docs content, so confirm scopes and recipient emails before running in production accounts.
Workflow Chain
Requires first: gws sheets, gws docs
SKILL.md
READMESKILL.md - Recipe Generate Report From Sheet
# Generate a Google Docs Report from Sheet Data > **PREREQUISITE:** Load the following skills to execute this recipe: `gws-sheets`, `gws-docs`, `gws-drive` Read data from a Google Sheet and create a formatted Google Docs report. ## Steps 1. Read the data: `gws sheets +read --spreadsheet SHEET_ID --range "Sales!A1:D"` 2. Create the report doc: `gws docs documents create --json '{"title": "Sales Report - January 2025"}'` 3. Write the report: `gws docs +write --document-id DOC_ID --text '## Sales Report - January 2025 ### Summary Total deals: 45 Revenue: $125,000 ### Top Deals 1. Acme Corp - $25,000 2. Widget Inc - $18,000'` 4. Share with stakeholders: `gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "cfo@company.com"}'`