Recipe generate report from sheet
Skill googleworkspace/cli/skills/recipe-generate-report-from-sheet
Google Workspace CLI — one command-line tool for Drive, Gmail, Calendar, Sheets, Docs, Chat, Admin, and more. Dynamically built from Google Discovery Service. Includes AI agent skills.
npx -y skills add googleworkspace/cli --skill recipe-generate-report-from-sheetAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
What its author says it does
Copied from the file, not written here
Read data from a Google Sheet and create a formatted Google Docs report.
SKILL.md
1.1 KB, as published. Nobody here has run it
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": "[email protected]"}'