recipe-generate-report-from-sheet▌
googleworkspace/cli · updated Apr 8, 2026
Extract Google Sheet data and generate a formatted Google Docs report with sharing.
- ›Requires three Google Workspace skills: gws-sheets for data reading, gws-docs for document creation and formatting, and gws-drive for permission management
- ›Workflow chains four operations: read sheet ranges, create a new Doc, write formatted content with headers and sections, and share with specified stakeholders
- ›Supports markdown-style formatting in the report output and role-based access control for
1e:["$","div",null,{"className":"prose prose-invert max-w-none prose-headings:font-semibold prose-headings:tracking-tight prose-h1:text-4xl prose-h1:mb-2 prose-h2:text-2xl prose-h2:mb-2 prose-h3:text-lg prose-h3:mb-2 prose-p:text-muted-foreground prose-li:text-muted-foreground prose-code:bg-muted prose-code:text-foreground prose-code:px-1 prose-code:py-0.5 prose-code:rounded-sm prose-code:text-sm prose-code:before:content-none prose-code:after:content-none prose-pre:bg-muted prose-pre:text-foreground prose-pre:border prose-pre:border-border prose-pre:rounded-md [&_table]:!border-[color:var(--border)] [&_th]:!border-[color:var(--border)] [&_td]:!border-[color:var(--border)]","dangerouslySetInnerHTML":{"__html":"<h1>Generate a Google Docs Report from Sheet Data</h1>\n<blockquote>\n<p><strong>PREREQUISITE:</strong> Load the following skills to execute this recipe: <code>gws-sheets</code>, <code>gws-docs</code>, <code>gws-drive</code></p>\n</blockquote>\n<p>Read data from a Google Sheet and create a formatted Google Docs report.</p>\n<h2>Steps</h2>\n<ol>\n<li>Read the data: <code>gws sheets +read --spreadsheet SHEET_ID --range "Sales!A1:D"</code></li>\n<li>Create the report doc: <code>gws docs documents create --json '{"title": "Sales Report - January 2025"}'</code></li>\n<li>Write the report: gws docs +write --document-id DOC_ID --text '## Sales Report - January 2025</li>\n</ol>\n<h3>Summary</h3>\n<p>Total deals: 45\nRevenue: $125,000</p>\n<h3>Top Deals</h3>\n<ol>\n<li>Acme Corp - $25,000</li>\n<li>Widget Inc - $18,000'</li>\n<li>Share with stakeholders: <code>gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "cfo@company.com"}'</code></li>\n</ol>"}}]