skilld
All skills
googleworkspace avatar

/recipe-generate-report-from-sheet

@705fb0e
by Google Workspacegoogleworkspace/cli31k stars
1,856

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

Ask your Agent

Use this Skill: https://skilld.dev/gh/googleworkspace/cli/recipe-generate-report-from-sheet

This session only. Nothing lands on disk.

SKILL.md

≈27 tokens always: the name and description. ≈202 when used: this file.

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

Source: SKILL.md on GitHub

Third-party checks

No alerts16d5 checks · Risk SAFE
  • Gen Agent Trust Hub16d

    This productivity recipe automates the process of reading data from Google Sheets and generating formatted Google Docs reports. It uses the vendor-specific 'gws' CLI tool to interact with Google Workspace services and is consistent with its stated functionality.

  • Socket16d

    No alerts

  • Snyk16d

    Risk: LOW · No issues

  • Runlayer6mo

    1/1 file flagged

  • ZeroLeaks5mo

    Score: 93/100 · 2 sections analyzed

Provenance

Signed by skilld at 705fb0e. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 2 months ago.

Activeupdated 6 months ago

Capability

Other metadata
metadata
{
  "version": "0.22.5",
  "openclaw": {
    "category": "recipe",
    "domain": "productivity",
    "requires": {
      "bins": [
        "gws"
      ],
      "skills": [
        "gws-sheets",
        "gws-docs",
        "gws-drive"
      ]
    }
  }
}

Topics

  • google-workspace
  • google-sheets
  • google-docs
  • reporting
  • recipe
  • gws-cli
  • data-extraction
  • document-generation

README badge

README badge for googleworkspace/cli/recipe-generate-report-from-sheet

What it does

Reads data from a Google Sheet and writes it as a formatted report document in Google Docs, then shares the report with specified stakeholders. Combines gws-sheets, gws-docs, and gws-drive skills to automate report generation from spreadsheet data.

Generated from the current SKILL.md.

Frequently asked

What Google Workspace APIs does this recipe use?
It uses the Sheets API to read data, the Docs API to create and write formatted documents, and the Drive API to set sharing permissions.
Do I need to install prerequisite skills first?
Yes. You must load gws-sheets, gws-docs, and gws-drive before running this recipe.
Can I automate report generation on a schedule?
The skill itself does not handle scheduling. You would need to wrap the gws commands in an external scheduler or workflow tool.
What formatting options are available for the report?
The gws docs +write command supports markdown-style formatting including headers, lists, and plain text. Consult the gws-docs skill documentation for the full range of supported formatting.

Generated from the current SKILL.md. These answers refresh after source changes.