Recipe Copy Sheet For New Month
Roll forward a monthly tracking spreadsheet by copying the template tab and renaming it for the new period with gws sheets commands.
Overview
recipe-copy-sheet-for-new-month is an agent skill for the Operate phase that duplicates a Google Sheets template tab and renames it for a new month of tracking using gws.
Install
npx skills add https://github.com/googleworkspace/cli --skill recipe-copy-sheet-for-new-monthWhat is this skill?
- 3-step recipe: spreadsheets get, sheets copyTo, batchUpdate rename title
- Requires gws-sheets skill and spreadsheetId plus template sheetId
- batchUpdate updateSheetProperties example title February 2025
- copyTo keeps destination in same spreadsheet by default JSON
- OpenClaw recipe v0.22.5 productivity domain
- 1 prerequisite skill: gws-sheets
Adoption & trust: 15.5k installs on skills.sh; 26.9k GitHub stars.
What problem does it solve?
Your monthly tracker lives on one template tab and you waste time each month duplicating and renaming it by hand.
Who is it for?
Solos running gws-sheets who maintain one spreadsheet with a canonical template tab for recurring monthly data entry.
Skip if: Greenfield spreadsheet design, multi-workbook consolidation, or teams that need Apps Script triggers instead of CLI batch updates.
When should I use this skill?
Duplicate a Google Sheets template tab for a new month of tracking after loading gws-sheets.
What do I get? / Deliverables
You get a new sheet cloned from the template with an updated month title ready for fresh rows.
- Cloned sheet tab in spreadsheet
- Renamed month title on new tab
Recommended Skills
Journey fit
Recurring sheet hygiene is ongoing operations—same template, new month—without rebuilding trackers from scratch. Iterate covers repeating monthly rituals: duplicate structure, rename tab, keep historical tabs intact.
How it compares
Structured gws batchUpdate recipe versus manual Duplicate sheet in the Sheets UI.
Common Questions / FAQ
Who is recipe-copy-sheet-for-new-month for?
Indie operators and freelancers using gws who repeat the same Google Sheets template every month for tracking or reporting.
When should I use recipe-copy-sheet-for-new-month?
Use it in Operate iterate at month boundaries, in Grow analytics when rolling forward KPI tabs, or in Build pm when resetting sprint backlog sheets from a template.
Is recipe-copy-sheet-for-new-month safe to install?
It mutates live spreadsheets via copy and rename; review the Security Audits panel on this page and test on a copy of spreadsheetId before production ledgers.
Workflow Chain
Requires first: gws sheets
SKILL.md
READMESKILL.md - Recipe Copy Sheet For New Month
# 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 1. Get spreadsheet details: `gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'` 2. Copy the template sheet: `gws sheets spreadsheets sheets copyTo --params '{"spreadsheetId": "SHEET_ID", "sheetId": 0}' --json '{"destinationSpreadsheetId": "SHEET_ID"}'` 3. Rename the new tab: `gws sheets spreadsheets batchUpdate --params '{"spreadsheetId": "SHEET_ID"}' --json '{"requests": [{"updateSheetProperties": {"properties": {"sheetId": 123, "title": "February 2025"}, "fields": "title"}}]}'`