recipe-generate-report-from-sheet
Extract Google Sheet data and generate a formatted Google Docs report
by googleworkspaceFree
Description
recipe-generate-report-from-sheet is a recipe skill from the Google Workspace CLI project, listed on skills.sh. It reads data from a Google Sheet and turns it into a formatted Google Docs report, which is then shared. It needs three skills: gws-sheets to read the data, gws-docs to create and format the document, and gws-drive to manage permissions. The steps are to read a range of the sheet, such as Sales!A1:D, to create a new document with a title such as Sales Report - January 2025, and to write the report text into it using the docs write helper, with a heading and a summary built from the figures. The example report includes a total number of deals and a revenue figure. The text in the report is set by the recipe's commands, so it is worth checking the figures against the sheet before the report is shared. It suits people who produce a regular summary from a spreadsheet, such as a monthly sales or project report, and want the document created from the numbers rather than retyped.…
Highlights
- Reads a sheet range for the data
- Creates a titled Google Doc report
- Writes a summary from the figures
- Needs gws-sheets, gws-docs and gws-drive
Ratings & Reviews
No ratings yet
Be the first to rate recipe-generate-report-from-sheet.
People also visit
recipe-copy-sheet-for-new-month
Duplicate a Google Sheets template tab for a new month of tracking
recipe-create-expense-tracker
Google Sheets spreadsheet template for expense tracking
recipe-draft-email-from-doc
Draft Gmail messages directly from Google Doc content without manual copying
recipe-log-deal-update
Append deal status updates to a Google Sheets sales tracking spreadsheet
recipe-generate-report-from-sheet FAQ
What does this recipe produce?
A Google Docs report built from the data in a sheet, with a title and a summary.
How do I install it?
Run: npx skills add https://github.com/googleworkspace/cli --skill recipe-generate-report-from-sheet
Which skills does it need?
gws-sheets to read the data, gws-docs to create the report and gws-drive for permissions.
Does it check the numbers?
No. The report is written from the commands the recipe runs, so the figures should be checked against the sheet.
Has it been checked for security?
skills.sh lists three audits: Gen Agent Trust Hub Pass, Socket Pass and Snyk Pass.
What are the best recipe-generate-report-from-sheet alternatives?
Popular alternatives to recipe-generate-report-from-sheet include recipe-copy-sheet-for-new-month, recipe-create-expense-tracker and recipe-draft-email-from-doc. See all recipe-generate-report-from-sheet alternatives