Google Sheets 模板复制教程：为新月份自动复制工作表 | Google Workspace CLI 指南

recipe-copy-sheet-for-new-month by googleworkspace/cli

5,600 周安装量

22,500 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/googleworkspace/cli --skill recipe-copy-sheet-for-new-month

开发云服务生产力

🇨🇳中文介绍

为新月份复制 Google 表格

前提条件： 执行此配方前，请加载以下技能：gws-sheets

为新的月份跟踪复制 Google 表格模板工作表。

步骤

获取电子表格详细信息：gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'
复制模板工作表：gws sheets spreadsheets sheets copyTo --params '{"spreadsheetId": "SHEET_ID", "sheetId": 0}' --json '{"destinationSpreadsheetId": "SHEET_ID"}'
重命名新标签页：gws sheets spreadsheets batchUpdate --params '{"spreadsheetId": "SHEET_ID"}' --json '{"requests": [{"updateSheetProperties": {"properties": {"sheetId": 123, "title": "February 2025"}, "fields": "title"}}]}'

每周安装量

5.6K

代码仓库

googleworkspace/cli

广告位招租

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

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

联系我们

🇺🇸English

Copy a Google Sheet for a New Month

PREREQUISITE: Load the following skills to execute this recipe: gws-sheets

Duplicate a Google Sheets template tab for a new month of tracking.

Steps

Get spreadsheet details: gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'
Copy the template sheet: gws sheets spreadsheets sheets copyTo --params '{"spreadsheetId": "SHEET_ID", "sheetId": 0}' --json '{"destinationSpreadsheetId": "SHEET_ID"}'
Rename the new tab: gws sheets spreadsheets batchUpdate --params '{"spreadsheetId": "SHEET_ID"}' --json '{"requests": [{"updateSheetProperties": {"properties": {"sheetId": 123, "title": "February 2025"}, "fields": "title"}}]}'

Weekly Installs

5.6K

Repository

googleworkspace/cli

GitHub Stars

22.5K

First Seen

Mar 4, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

codex5.5K

opencode5.5K

gemini-cli5.4K

cursor5.4K

github-copilot5.4K

kimi-cli5.4K