Recipe Generate Report From Sheet
googleworkspace/cliOfficial
This recipe automates the common workflow of pulling data from Google Sheets and turning it into a polished Google Docs report with proper formatting and sharing permissions. It reads your spreadsheet data, creates a new document with a structured layout including summary statistics and detailed breakdowns, then automatically shares it with specified stakeholders. Perfect for monthly sales reports, project updates, or any recurring data presentation where you're tired of copying and pasting between Google apps. The four-step process handles authentication and file permissions, so you get a complete end-to-end automation rather than just data extraction.
- installs
- 30.6K
- GitHub stars
- 31.9K
- last updated
- Aug 21, 2026
Install
$ npx -y skills add googleworkspace/cli --skill recipe-generate-report-from-sheet --agent claude-codeInstalls into .claude/skills of the current project.
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
- Read the data:
gws sheets +read --spreadsheet SHEET_ID --range "Sales!A1:D" - Create the report doc:
gws docs documents create --json '{"title": "Sales Report - January 2025"}' - Write the report: `gws docs +write --document-id DOC_ID --text '## Sales Report - January 2025
Summary
Total deals: 45 Revenue: $125,000
Top Deals
- Acme Corp - $25,000
- Widget Inc - $18,000'`
- Share with stakeholders:
gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "cfo@company.com"}'
Sponsors
Details
- Repository
- github.com/googleworkspace/cli
- Categories
- Documentation, CLI & Terminal
