Claude MarketplacesSubmit
googleworkspace avatar

Recipe Generate Report From Sheet

googleworkspace/cliOfficial

This recipe automates the common workflow of pulling data from Google Sheets and turning it into a polished Google Docs report with proper formatting and sharing permissions. It reads your spreadsheet data, creates a new document with a structured layout including summary statistics and detailed breakdowns, then automatically shares it with specified stakeholders. Perfect for monthly sales reports, project updates, or any recurring data presentation where you're tired of copying and pasting between Google apps. The four-step process handles authentication and file permissions, so you get a complete end-to-end automation rather than just data extraction.

skills.sh installs
31.2K
GitHub stars
32.2K
last updated
Aug 21, 2026
View on GitHub

Install

$ npx -y skills add googleworkspace/cli --skill recipe-generate-report-from-sheet --agent claude-code

Installs into .claude/skills of the current project.

Files

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

  1. Read the data: gws sheets +read --spreadsheet SHEET_ID --range "Sales!A1:D"
  2. Create the report doc: gws docs documents create --json '{"title": "Sales Report - January 2025"}'
  3. Write the report: `gws docs +write --document-id DOC_ID --text '## Sales Report - January 2025

Summary

Total deals: 45 Revenue: $125,000

Top Deals

  1. Acme Corp - $25,000
  2. Widget Inc - $18,000'`
  3. Share with stakeholders: gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "cfo@company.com"}'
SKILL.md on GitHub

Sponsors

Promote your product hereReach 125k+ visitors monthlyPromote your product hereReach 125k+ visitors monthlyAgent CaffeineSponsoredClose your lid, come back to finished workSnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthlyWaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthlyknobsSponsoredSee your site on any phone, any day, in any language

Details

Repository
github.com/googleworkspace/cli
Categories
Documentation, CLI & Terminal

More from googleworkspace/cli

All 113

Recommended

More Documentation
1caffeinelabs avatarextension-openaicaffeinelabs/skillsMANDATORY recipe for every Caffeine build that calls OpenAI (ChatGPT, GPT-4o, an LLM, a chatbot, embeddings). The ONLY supported path is the `openai-client` mop30.8Kskills.sh installs
2jimliu avatarbaoyu-comicjimliu/baoyu-skillsKnowledge comic creator supporting multiple art styles and tones. Creates original educational comics with detailed panel layouts and batch-capable image genera30.3Kskills.sh installs
3pbakaus avatarshapepbakaus/impeccablePlan the UX and UI for a feature before writing code. Runs a structured discovery interview, then produces a design brief that guides implementation. Use during30Kskills.sh installs
4caffeinelabs avatarextension-posting-to-xcaffeinelabs/skillsMANDATORY recipe for every Caffeine build that posts to X (Twitter). The ONLY supported path is the `x-client` mops package with OAuth 2.0 PKCE. Hand-rolling `i29.8Kskills.sh installs
5warpdotdev avatarspec-driven-implementationwarpdotdev/common-skillsDrive a spec-first workflow for substantial features by writing PRODUCT.md before implementation, writing TECH.md when warranted, and keeping both specs updated28.9Kskills.sh installs
6warpdotdev avatarwrite-product-specwarpdotdev/common-skillsWrite a PRODUCT.md spec for a significant user-facing feature in Warp, focused on detailed behavior and validation. Use when the user asks for a product spec, d28.9Kskills.sh installs