Skip to content
Development
Skill

/recipe-generate-report-from-sheet

Read data from a Google Sheet and create a formatted Google Docs report.

From plugin
cli
30k95 skills
Install
$ npx -y skills add googleworkspace/cli --skill recipe-generate-report-from-sheet --agent claude-code

How it fires

How this skill gets triggered: by you, by Claude, or both.

  • Fires itselfAuto-invocation. Claude auto-loads it when your prompt matches the work.Auto-invocation is when the right skill fires by itself at the right moment, driven by a FLOW.md router and a hook, instead of you invoking it by name. It is the difference between a skill being installed and a skill actually getting used.Read the full definition →
  • You can call itInvoke it directly when you want it.
  • Slash command/recipe-generate-report-from-sheet

Context preview

The summary Claude sees to decide when to auto-load this skill.

Read data from a Google Sheet and create a formatted Google Docs report.

SKILL.md

recipe-generate-report-from-sheet.SKILL.md
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": "cfo@company.com"}'`

Ships withcli

Google Workspace CLI — one command-line tool for Drive, Gmail, Calendar, Sheets, Docs, Chat, Admin, and more. Dynamically built from Google Discovery Service. Includes AI agent skills.

Get the whole plugin
Stats
30,285
Stars
1,773
Forks
Active
Maintenance
Rust
Language
Apache-2.0
License
9d ago
Last commit
5mo ago
Created

Repo: googleworkspace/cli