recipe-generate-report-from-sheet

googleworkspace/cli

Read Google Sheet data and generate formatted Google Docs reports automatically.

What is recipe-generate-report-from-sheet?

This recipe combines Google Sheets, Docs, and Drive to extract data from a spreadsheet and create a polished report document. Use it when you need to transform raw sheet data into a formatted report and share it with stakeholders.

Read structured data from Google Sheets by range
Create new Google Docs documents programmatically
Write formatted text and sections to Docs
Share generated reports with specific users via Drive permissions
Automate multi-step reporting workflows

How to install recipe-generate-report-from-sheet

npx skills add null --skill recipe-generate-report-from-sheet

Prerequisites

gws-sheets skill installed
gws-docs skill installed
gws-drive skill installed
Google Workspace account with Sheets, Docs, and Drive access
Spreadsheet ID and document permissions

Claude Code

Cursor

Windsurf

Cline

How to use recipe-generate-report-from-sheet

1.Read data from your Google Sheet using the range parameter (e.g., 'Sales!A1:D')
2.Create a new Google Docs document with your desired report title
3.Write the formatted report content to the document, including headers, summaries, and data
4.Set sharing permissions on the generated document to grant access to stakeholders

Use cases

Good for

Generate monthly sales reports from transaction data in Sheets
Create executive summaries by extracting key metrics from spreadsheets
Produce formatted financial reports and share them with finance teams
Build automated weekly status reports from project tracking sheets
Generate client-facing reports from data stored in Google Sheets

Who it's for

Business analysts
Finance and accounting professionals
Project managers
Sales operations teams
Anyone automating report generation workflows

recipe-generate-report-from-sheet FAQ

What skills do I need to install first?

You must install gws-sheets, gws-docs, and gws-drive skills before using this recipe.

Can I customize the report formatting?

Yes, you can format the text using Markdown-style syntax in the write command, including headers, lists, and sections.

How do I specify which data to read from my sheet?

Use the --range parameter with standard sheet notation (e.g., 'Sales!A1:D10') to specify the exact cells to read.

Can I share the report with multiple people?

Yes, run the permissions create command multiple times with different email addresses, or use a group email.

Full instructions (SKILL.md)

Source of truth, from googleworkspace/cli.

name: recipe-generate-report-from-sheet description: "Read data from a Google Sheet and create a formatted Google Docs report." metadata: version: 0.22.5 openclaw: category: "recipe" domain: "productivity" requires: bins: - gws skills: - gws-sheets - gws-docs - gws-drive

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