recipe-generate-report-from-sheet

Vercel

All-time installs

27.8K

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

Install

Other options

Summary

Extract Google Sheet data and generate a formatted Google Docs report with sharing.

Requires three Google Workspace skills: gws-sheets for data reading, gws-docs for document creation and formatting, and gws-drive for permission management
Workflow chains four operations: read sheet ranges, create a new Doc, write formatted content with headers and sections, and share with specified stakeholders
Supports markdown-style formatting in the report output and role-based access control for sharing

Raw SKILL.md

1,148 bytes

---
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

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

### Summary
Total deals: 45
Revenue: $125,000

### Top Deals
1. Acme Corp - $25,000
2. Widget Inc - $18,000'`
4. Share with stakeholders: `gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "[email protected]"}'`

Security audits

SnykPASS

SocketPASS

Gen Agent Trust HubPASS