1---
2name: recipe-generate-report-from-sheet
3description: "Read data from a Google Sheet and create a formatted Google Docs report."
4metadata:
5  version: 0.22.5
6  openclaw:
7    category: "recipe"
8    domain: "productivity"
9    requires:
10      bins:
11        - gws
12      skills:
13        - gws-sheets
14        - gws-docs
15        - gws-drive
16---
17 
18# Generate a Google Docs Report from Sheet Data
19 
20> **PREREQUISITE:** Load the following skills to execute this recipe: `gws-sheets`, `gws-docs`, `gws-drive`
21 
22Read data from a Google Sheet and create a formatted Google Docs report.
23 
24## Steps
25 
261. Read the data: `gws sheets +read --spreadsheet SHEET_ID --range "Sales!A1:D"`
272. Create the report doc: `gws docs documents create --json '{"title": "Sales Report - January 2025"}'`
283. Write the report: `gws docs +write --document-id DOC_ID --text '## Sales Report - January 2025
29 
30### Summary
31Total deals: 45
32Revenue: $125,000
33 
34### Top Deals
351. Acme Corp - $25,000
362. Widget Inc - $18,000'`
374. Share with stakeholders: `gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "[email protected]"}'`
38 
39