Google Workspace CLI 教程：从表格数据自动生成格式化文档报告

recipe-generate-report-from-sheet by googleworkspace/cli

5,800 周安装量

22,500 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/googleworkspace/cli --skill recipe-generate-report-from-sheet

云服务数据分析生产力

🇨🇳中文介绍

基于表格数据生成 Google 文档报告

前提条件： 执行此方案前，请先加载以下技能：gws-sheets、gws-docs、gws-drive

从 Google 表格读取数据并创建格式化的 Google 文档报告。

步骤

读取数据：gws sheets +read --spreadsheet SHEET_ID --range "Sales!A1:D"
创建报告文档：gws docs documents create --json '{"title": "Sales Report - January 2025"}'
撰写报告：`gws docs +write --document-id DOC_ID --text '## Sales Report - January 2025

摘要

总交易数：45 总收入：$125,000

重要交易

Acme Corp - $25,000
Widget Inc - $18,000'`
与利益相关者共享：gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "cfo@company.com"}'

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

🇺🇸English

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

Weekly Installs

5.8K

Repository

googleworkspace/cli

GitHub Stars

22.5K

First Seen

Mar 4, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

codex5.6K

opencode5.6K

gemini-cli5.6K

cursor5.6K

github-copilot5.6K

kimi-cli5.6K