---
id: ssh2-recipe-generate-report-from-sheet
name: "recipe-generate-report-from-sheet"
url: https://skills.yangsir.net/skill/ssh2-recipe-generate-report-from-sheet
author: googleworkspace
domain: ai-productivity-automation
tags: ["google-sheets", "data-reporting", "automated-reports", "spreadsheet-analysis", "data-visualization"]
install_count: 30400
rating: 4.60 (148 reviews)
github: https://github.com/googleworkspace/cli
---

# recipe-generate-report-from-sheet

> 从Google Sheet读取数据，并创建格式化的Google Docs报告。

**Stats**: 30,400 installs · 4.6/5 (148 reviews)

## Before / After 对比

### 自动化生成数据报告，告别手动整理。

## Readme

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



---
*Source: https://skills.yangsir.net/skill/ssh2-recipe-generate-report-from-sheet*
*Markdown mirror: https://skills.yangsir.net/api/skill/ssh2-recipe-generate-report-from-sheet/markdown*