# Recipe Generate Report From Sheet

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

- Skill: `vikingokft/recipe-generate-report-from-sheet` (Agent Skill)
- Install (CLI): `npx skillmds add vikingokft/recipe-generate-report-from-sheet`
- Raw SKILL.md: https://api.skillmd.com/api/skills/vikingokft/recipe-generate-report-from-sheet/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Docs & Writing
- Author: vikingokft (https://skillmd.com/u/vikingokft)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/vikingokft/recipe-generate-report-from-sheet

---


# 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": "cfo@company.com"}'`