Agent Skills
› googleworkspace/cli
› recipe-copy-sheet-for-new-month
recipe-copy-sheet-for-new-month
GitHub通过调用 Google Sheets API，复制模板工作表并重命名为新月份，实现月度追踪表的自动化创建流程。
Trigger Scenarios
需要为下个月创建新的数据追踪表格
批量生成或复制 Google Sheets 工作表
Install
npx skills add googleworkspace/cli --skill recipe-copy-sheet-for-new-month -g -y
SKILL.md
Frontmatter
{
"name": "recipe-copy-sheet-for-new-month",
"metadata": {
"version": "0.22.5",
"openclaw": {
"domain": "productivity",
"category": "recipe",
"requires": {
"bins": [
"gws"
],
"skills": [
"gws-sheets"
]
}
}
},
"description": "Duplicate a Google Sheets template tab for a new month of tracking."
}
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"}}]}'
Version History
- a3768d0 Current 2026-08-20 07:26
