recipe-generate-report-from-sheet
Read data from a Google Sheet and create a formatted Google Docs report.
Install with Tessl CLI
npx tessl i github:googleworkspace/cli --skill recipe-generate-report-from-sheet65
Does it follow best practices?
Optimize this skill
If you maintain this skill, you can automatically optimize it using the tessl CLI to improve its score:
npx tessl skill review --optimize ./path/to/skillValidation for skill structure
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-id 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"}'
- Repository
- googleworkspace/cli
- Commit
6ed836c
- Last updated
- Created
Is this your skill?
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.