Skip to main content
affpapa.org
RU EN
skill Claude Code CX Codex Cursor GitHub Copilot official · Google

recipe-generate-report-from-sheet — Claude Code skill for reports

Reads Google Sheets data and turns it into a formatted Google Docs report. Use it when a spreadsheet needs to become a document you can share with colleagues.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add googleworkspace/cli --skill recipe-generate-report-from-sheet -a claude-code
Open on GitHub

What recipe-generate-report-from-sheet does

The skill lays out a gws workflow: read a spreadsheet range, create a Google Docs document, then write the report into it. Its example reads Sales!A1:D and puts a summary and top deals in the document.

The workflow can also grant a user reader access to the report. It requires gws and the gws-sheets, gws-docs, and gws-drive skills. Install it when you want this spreadsheet-to-document sequence; the recipe depends on those tools being available.

What it helps with

  • turn Google Sheets data into a Google Docs report
  • read a specified sheet range with gws
  • add a summary and top deals to a document
  • grant a user reader access to the report

Example prompts for the agent

  • Read `Sales!A1:D` and create a Google Docs report from it.
  • Make a summary and list the top deals from this sheet.
  • Create the report and give `[email protected]` reader access.

How to install recipe-generate-report-from-sheet

1Skills CLI (Vercel)

npx skills add googleworkspace/cli --skill recipe-generate-report-from-sheet -a claude-code

2Manually: put the files in place

~/.claude/skills/recipe-generate-report-from-sheet/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/recipe-generate-report-from-sheet/

From the same set95

The whole set →
gws-gmail official googleworkspace This skill hands your agent Gmail: send mail, read the inbox, reply in a thread. Useful when email work already runs through the gws CLI. Claude Code CX Codex Cursor +1 81,900installs gws-gmail-send official googleworkspace A skill that teaches your agent to send Gmail from the terminal: recipients, subject, body, attachments and drafts. Claude Code CX Codex Cursor +1 74,700installs gws-drive official googleworkspace This skill hands your agent Google Drive through the gws CLI: files, folders, shared drives, comments and access requests. Useful when docs move through code. Claude Code CX Codex Cursor +1 74,500installs gws-shared official googleworkspace This skill gives agents shared rules for gws CLI authentication, flags, and output formats. Use it when working with gws commands. Claude Code CX Codex Cursor +1 66,000installs gws-calendar official googleworkspace Manage Google Calendar events, access rules, and schedules through the gws CLI tool. Claude Code CX Codex Cursor +1 61,100installs gws-sheets official googleworkspace This skill lets an agent read and edit Google Sheets through the CLI. Use it when a coding workflow needs spreadsheet data or table updates. Claude Code CX Codex Cursor +1 58,800installs gws-docs official googleworkspace This skill lets an agent read and update Google Docs through gws. Use it when document changes should happen from an agent chat. Claude Code CX Codex Cursor +1 58,300installs gws-sheets-read official googleworkspace Reads cell values and sheets from Google Spreadsheets via CLI. Useful when an agent needs spreadsheet data without risk of altering it. Claude Code CX Codex Cursor +1 50,600installs

Similar

pptx official anthropics This skill helps create, read, and edit .pptx files and .potx templates. Use it when building a deck or extracting slide text. Claude Code Claude.ai 241,433installs pdf official anthropics This skill lets an agent read, create, and edit PDF files, including forms and scanned documents. Use it when PDF work is part of the task. Claude Code Claude.ai 216,041installs docx official anthropics This skill creates, reads, and edits Word documents and templates. Use it for reports, letters, and files that need headings, tables, or page numbers. Claude Code Claude.ai 206,304installs xlsx official anthropics Creates, reads, edits, and converts spreadsheet files. Use it when the requested deliverable is an Excel workbook or another tabular file. Claude Code Claude.ai 187,223installs brand-guidelines official anthropics Applies Anthropic's official brand colors and fonts to documents, slides and other artifacts. Useful whenever something needs to match the company look. Claude Code Claude.ai 109,043installs theme-factory official anthropics Applies preset color palettes and font pairs to slides, documents, and HTML pages. Use it when an artifact needs one consistent visual style. Claude Code Claude.ai 94,921installs

Questions about recipe-generate-report-from-sheet

How do I install recipe-generate-report-from-sheet in Claude Code?

Run npx skills add googleworkspace/cli --skill recipe-generate-report-from-sheet -a claude-code.

What does recipe-generate-report-from-sheet do?

It defines a gws workflow to read Google Sheets data, create a Google Docs report, and grant reader access.

What does recipe-generate-report-from-sheet need to run?

It requires gws plus the gws-sheets, gws-docs, and gws-drive skills.

Source text

SKILL.md · Apache-2.0 
---
name: recipe-generate-report-from-sheet
description: "Read data from a Google Sheet and create a formatted Google Docs report."
metadata:
  version: 0.22.5
  openclaw:
    category: "recipe"
    domain: "productivity"
    requires:
      bins:
        - gws
      skills:
        - gws-sheets
        - gws-docs
        - gws-drive
---

# 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'`
4. Share with stakeholders: `gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "[email protected]"}'`

© googleworkspace · Apache-2.0 · googleworkspace/cli

See also

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor