recipe-generate-report-from-sheet

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

30,468
installs: 0 up / 0 down, score 0.00
votes
In the catalog since: 30 Sept 2026
From: googleworkspace/cli

Get it through your agent

Skill instructions

Rendered from the published SKILL.md, 22 lines.

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

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

Summary

Total deals: 45 Revenue: $125,000

Top Deals

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

Get it through your agent

Call the Graph-of-Skills MCP server's retrieve_skill_bundle tool and it returns this skill's text inside your budget.

{
  "tool": "retrieve_skill_bundle",
  "arguments": {
    "query": "recipe-generate-report-from-sheet"
  }
}

New to this? Set up Graph-of-Skills or get a free key. The text on this page comes from its authors: how skills are sourced and what we check. If none fits your task, your agent can write a skill for your own library. To keep a skill from your own library on a machine, see how to install one of your skills.

Share on X Share on LinkedIn Share on Bluesky Share on Hacker News

Share on Reddit

Source

Listing on skills.sh

From googleworkspace/cli via skills.sh

Related skills

recipe-create-events-from-sheet
Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row.
30,011 installs
recipe-create-doc-from-template
Copy a Google Docs template, fill in content, and share with collaborators.
30,652 installs
xlsx
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
186,817 installs
docx
Use this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files) or Word templates (.dotx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', '.dotx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx or .dotx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation.
205,936 installs
grill-with-docs
A relentless interview to sharpen a plan or design, which also creates docs (ADR's and glossary) as we go.
1,216,228 installs