Recipe Generate Report From Sheet
- 24.6k installs
- 30k repo stars
- Updated July 22, 2026
- googleworkspace/cli
recipe-generate-report-from-sheet is a Google Workspace CLI recipe that reads data from Sheets and creates formatted Docs reports.
About
This recipe automates report generation by reading data from Google Sheets and writing formatted documents in Google Docs. It retrieves tabular data, transforms it into report sections with summaries and top items, and shares the output with stakeholders. Developers use it to eliminate manual report creation and keep documents in sync with live data.
- Reads data from Google Sheets with range-based queries
- Creates formatted Google Docs reports from Sheet data
- Shares reports with stakeholders via Drive permissions
Recipe Generate Report From Sheet by the numbers
- 24,576 all-time installs (skills.sh)
- +810 installs in the week ending Jul 28, 2026 (Skillselion tracking)
- Ranked #38 of 690 Office & Documents skills by installs in the Skillselion catalog
- Security screen: LOW risk (skills.sh audit)
- Data as of Jul 28, 2026 (Skillselion catalog sync)
recipe-generate-report-from-sheet capabilities & compatibility
- Works with
- google drive
npx skills add https://github.com/googleworkspace/cli --skill recipe-generate-report-from-sheetAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 24.6k |
|---|---|
| repo stars | ★ 30k |
| Security audit | 3 / 3 scanners passed |
| Last updated | July 22, 2026 |
| Repository | googleworkspace/cli ↗ |
How do you create a Google Doc report from Sheets data?
Generate formatted reports from Google Sheet data and share with stakeholders.
Who is it for?
Developers using gws who need to pipe spreadsheet ranges into formatted, shareable Google Docs reports automatically.
Skip if: Live dashboard charts, BigQuery pipelines, or one-off cell edits without report formatting requirements.
When should I use this skill?
A developer asks to read data from a Google Sheet and create a formatted Google Docs report from it.
What you get
Formatted Google Docs report generated from Sheet range data and saved to Google Drive
- Formatted Google Docs report
- Drive-stored report file
By the numbers
- Requires 3 prerequisite skills: gws-sheets, gws-docs, and gws-drive
- Ships with gws CLI metadata version 0.22.5
Files
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"}'`
Related skills
Lark DocGenerate, update, and maintain structured documentation directly inside Lark/Feishu using natural language and agentic workflows.475kLark DriveLet their coding agents read, create, update and search documents stored in Lark (Feishu) Drive directly from prompts.475kLark SheetsConnect Claude, Cursor or other agents directly to Feishu/Lark spreadsheets for live data reads, writes, and structured automation.474kLark WikiGenerate, update, and sync structured knowledge bases inside Lark (Feishu) directly from code, specs, or agent output.474kLark WhiteboardGenerate, edit, and collaborate on visual diagrams and flowcharts directly inside Claude, Cursor or other agents.474kLark SlidesInstantly generate polished, professional slide decks from specs, roadmaps, or meeting notes using Lark/Feishu.474kFAQ
Which gws skills does the report recipe require?
recipe-generate-report-from-sheet requires gws-sheets, gws-docs, and gws-drive utility skills. Load all three before reading Sheet ranges and writing the formatted Docs output to Drive.
How does the recipe read spreadsheet data?
recipe-generate-report-from-sheet runs gws sheets +read with --spreadsheet SHEET_ID and a range like Sales!A1:D, then passes the returned structured data into gws docs report creation steps.
Is Recipe Generate Report From Sheet safe to install?
skills.sh reports 3 of 3 security scanners passed. Review the Security Audits panel on this page before installing in production.