Recipe Generate Report From Sheet
googleworkspace/cliThis skill reads data from Google Sheets and generates a formatted report in Google Docs, suitable for teams and individuals needing automated reporting. It includes key capabilities such as fetching spreadsheet data, creating and writing the report document, and sharing it with stakeholders. It is ideal for productivity users and developers aiming to streamline report generation within Google Workspace.
Generate a Google Docs Report from Sheet Data
PREREQUISITE: Load the following skills to execute this recipe:
gws-sheets,gws-docs,gws-driveRead 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"}'
GitHub Owner
Owner: googleworkspace
GitHub Links
- Website: https://developers.google.com/workspace
- Twitter: https://twitter.com/workspacedevs
SKILL.md
name: recipe-generate-report-from-sheet version: 1.0.0 description: "Read data from a Google Sheet and create a formatted Google Docs report." metadata: openclaw: category: "recipe" domain: "productivity" requires: bins: ["gws"] skills: ["gws-sheets", "gws-docs", "gws-drive"]
Generate a Google Docs Report from Sheet Data
PREREQUISITE: Load the following skills to execute this recipe:
gws-sheets,gws-docs,gws-driveRead 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"}'