recipe-generate-report-from-sheet
Helps your agent create reports. It reads data from a Google Sheet and builds a formatted Google Docs report.
What it does
This tool takes information from a Google Sheet and organizes it into a formatted Google Docs document. It's like copying data from a table and pasting it into a nice report.
When to use it
- ✓When you need to turn raw spreadsheet data into a visually appealing report.
- ✓To create sales summaries, task lists, or any information that needs to be presented clearly.
- ✓When sharing important data with others who don't have direct access to the spreadsheet.
Example of what to ask your AI
“Generate a sales report from my 'Q1 Sales' spreadsheet and save it as 'Q1 Report'.”
Want more? Open the sections below.
How to use
The easiest way: copy the message below and paste it into Claude, ChatGPT, Cursor or any AI. It reads the skill and follows the instructions.
Skill link
Ready-to-paste message
How it works
The tool first reads the data from the specified spreadsheet. Then, it creates a new document in Google Docs and inserts the read data, formatting it as a report.
Installation
Easiest way: copy the skill link and paste it into Claude, ChatGPT or Cursor asking it to follow the instructions.
In the terminal (Claude Code, Codex, Cursor), in your project folder:
npx skills add googleworkspace/cli --skill recipe-generate-report-from-sheetOr download just the file:
curl -L https://raw.githubusercontent.com/googleworkspace/cli/main/skills/recipe-generate-report-from-sheet/SKILL.md -o SKILL.mdTechnical content (original SKILL.md)
Original text by the author, straight from GitHub.
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"}'
FAQ
Do I need to have the data in a special format in the spreadsheet?
No, the tool can read data from any Google Sheet. Just make sure the data you want in the report is in a specific area of the sheet.
Can I choose where the data goes in the report?
Yes, you can specify which data to read from the spreadsheet and how it will be presented in the report.
What happens to the report after it's created?
The report is saved in your Google Drive and can be shared with others, like colleagues or managers.
Details
Original description by the author
Read data from a Google Sheet and create a formatted Google Docs report.
repo: googleworkspace/cli
Popularity
- GitHub stars
- 32k
- Ranking position
- #6327
- License
- Apache-2.0
- Updated
- 10/6/2026
Comments
- …
More skills from this repository
gws-admin-reports
Helps your agent get activity reports from Google Workspace. It collects audit and usage data.
googleworkspace/cli
gws-calendar-agenda
Helps your agent see upcoming events across all calendars. It's useful for organizing your schedule and knowing what's coming up.
googleworkspace/cli
gws-calendar-insert
Lets your agent create new events in Google Calendar. It's useful for scheduling appointments and meetings.
googleworkspace/cli
gws-calendar
Allows your agent to manage calendars and events. It's useful for organizing your life and work.
googleworkspace/cli
Similar skills
intent-driven-development
Helps your agent turn ideas into clear, testable plans. Defines criteria to ensure changes are made correctly and safely.
affaan-m/ECC
product-capability
Guides your agent in turning product ideas into clear plans. It defines what needs to be done, the limits, and decisions before development.
affaan-m/ECC
article-writing
Writes long-form content like articles, guides, and blog posts with a unique style. It's useful when you need well-written texts with a consistent voice and credibility.
affaan-m/ECC