Generate a Google Docs Report from Sheet Data
SkillDev toolsTurn the data in a Google Sheet into a formatted report in Google Docs without writing it yourself. Once added, your AI can read the sheet you point it to and produce the finished document. Useful whenever spreadsheet data needs to be presented as something people can actually read.
Available today. Use it from your connected AI after setup.
No other account needed.
Add the skill, then ask your AI to read a Google Sheet you choose and turn its data into a report.
Then ask your AI: use the Generate a Google Docs Report from Sheet Data skill
What your AI can do with it
- Read data from a Google Sheet
- Turn sheet data into a written report
- Create a formatted report document in Google Docs
What this skill tells your AI
The instructions your AI receives, as published by googleworkspace/cli in skills/recipe-generate-report-from-sheet/SKILL.md and read by ahel’s review.
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"}'
Signals
- GitHub stars
- 31k
- Forks
- 2k
- Last commit
- Sep 2026
Advanced
- Catalog kind
- skill
- Gateway key
recipe-generate-report-from-sheet- Source
- github.com/googleworkspace/cli