recipe-generate-report-from-sheet
Reads data from a Google Sheet and creates a formatted Google Docs report.
npx skills add https://github.com/googleworkspace/cli --skill recipe-generate-report-from-sheetBefore / After Comparison
1 组Each time a data report was needed, data had to be manually copied from Google Sheets, then pasted and formatted into a document. This process was time-consuming, laborious, and prone to errors, leading to low report update efficiency.
Automatically reads data from Google Sheets and creates beautifully formatted Google Docs reports. This significantly saves report creation time, ensures data accuracy, and improves decision-making efficiency.
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": "cfo@company.com"}'
User Reviews (0)
Write a Review
No reviews yet
Statistics
User Rating
Rate this Skill