recipe-generate-report-from-sheet

googleworkspace/cli · updated Apr 8, 2026

$npx skills add https://github.com/googleworkspace/cli --skill recipe-generate-report-from-sheet
0 commentsdiscussion
summary

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
skill.md

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>"}}]

Discussion

Product Hunt–style comments (not star reviews)
  • No comments yet — start the thread.
general reviews

Ratings

4.658 reviews
  • William Menon· Dec 20, 2024

    recipe-generate-report-from-sheet is among the better-maintained entries we tried; worth keeping pinned for repeat workflows.

  • Benjamin Desai· Dec 12, 2024

    Useful defaults in recipe-generate-report-from-sheet — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.

  • Dhruvi Jain· Dec 8, 2024

    Registry listing for recipe-generate-report-from-sheet matched our evaluation — installs cleanly and behaves as described in the markdown.

  • Omar Sharma· Dec 4, 2024

    Keeps context tight: recipe-generate-report-from-sheet is the kind of skill you can hand to a new teammate without a long onboarding doc.

  • Sophia Nasser· Dec 4, 2024

    Registry listing for recipe-generate-report-from-sheet matched our evaluation — installs cleanly and behaves as described in the markdown.

  • Oshnikdeep· Nov 27, 2024

    recipe-generate-report-from-sheet reduced setup friction for our internal harness; good balance of opinion and flexibility.

  • Omar Bansal· Nov 23, 2024

    I recommend recipe-generate-report-from-sheet for anyone iterating fast on agent tooling; clear intent and a small, reviewable surface area.

  • Sophia Tandon· Nov 23, 2024

    recipe-generate-report-from-sheet reduced setup friction for our internal harness; good balance of opinion and flexibility.

  • Omar Bhatia· Nov 19, 2024

    recipe-generate-report-from-sheet has been reliable in day-to-day use. Documentation quality is above average for community skills.

  • Noah Perez· Nov 11, 2024

    Solid pick for teams standardizing on skills: recipe-generate-report-from-sheet is focused, and the summary matches what you get after install.

showing 1-10 of 58

1 / 6