skills.rest
oresttokovenko
oresttokovenkoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

recipe-generate-report-from-sheet

Generates a formatted Google Docs report from Google Sheets data and shares it via Drive.

Updated Nov 9, 2023
Search Tags:#automation#report generation#google sheets#google docs#recipe#google drive#gws
One-click install
npx skills add https://github.com/oresttokovenko/dot-files --skill recipe-generate-report-from-sheet-oresttokovenko
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: recipe-generate-report-from-sheet
Source: https://github.com/oresttokovenko/dot-files/tree/main/chezmoi/dot_agents/skills/recipe-generate-report-from-sheet
Command: npx skills add https://github.com/oresttokovenko/dot-files --skill recipe-generate-report-from-sheet-oresttokovenko

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Manually copying spreadsheet data into a formatted report and distributing it to stakeholders is repetitive and error-prone. This recipe automates the full pipeline from reading a Google Sheet to producing and sharing a Google Docs report. ## Core Features & Use Cases - Sheet Data Reading: Pulls a specified range from a Google Sheet using the gws CLI. - Report Generation: Creates a Google Doc and writes formatted Markdown-style report content such as summaries and top-deal lists. - Stakeholder Sharing: Grants reader access to the generated document via Google Drive permissions. - Use Case: A sales manager reads the January deals range from a tracking spreadsheet, generates a "Sales Report - January 2025" document with revenue totals and top deals, and shares it with the CFO in one workflow. ## Quick Start Read the range Sales!A1:D from my Google Sheet, create a Google Docs sales report summarizing the data, and share it with my CFO.

Frequently Asked Questions about recipe-generate-report-from-sheet

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a Google Docs report from Google Sheets data?▼

Read the desired range with gws sheets +read, create a document with gws docs documents create, then write the formatted report content with gws docs +write. Finally share the document using gws drive permissions create.

How to share a Google Doc with specific people using the command line?▼

Use gws drive permissions create with the file ID and a JSON body specifying role, type, and emailAddress. For example, grant reader access to a user by passing their email address in the request.

What tools are required to run this Google Sheets to Docs workflow?▼

The workflow requires the gws command-line binary plus three loaded skills: gws-sheets for reading spreadsheet data, gws-docs for creating and writing documents, and gws-drive for managing sharing permissions.

Can I read a specific range from a Google Sheet with gws?▼

Yes, gws sheets +read accepts a --spreadsheet ID and a --range parameter such as Sales!A1:D. This returns only the cells within the specified range of the named sheet.

What are the limitations of generating reports from spreadsheets this way?▼

The report content is written as static text, so it does not update automatically when the sheet changes. Each new reporting period requires re-running the read and write steps with updated data.

Related Skills

Explore More Data & Analytics Skills→
vikingokftvikingokft

recipe-generate-report-from-sheet

Automates creating a formatted Google Docs report from a Google Sheet range.

Official
Intermediate
devbasexdevbasex
1

playwright-evidence

Generate Playwright test reports and upload evidence to Google Drive.

Official
Intermediate
evolution-foundationevolution-foundation
520

data-validate

Validate analyses for accuracy, bias, and methodology before sharing.

Official
Advanced
propane-aipropane-ai
4

data-views-and-reports

Generate dashboard specs and report content from connected data tools.

Official
Intermediate