
Recipe Copy Sheet For New Month
- 24.2k installs
- 30k repo stars
- Updated July 22, 2026
- googleworkspace/cli
recipe-copy-sheet-for-new-month is a Google Workspace CLI recipe that duplicates spreadsheet tabs for new monthly tracking periods.
About
recipe-copy-sheet-for-new-month is a Google Workspace CLI recipe that duplicates a Google Sheets template tab for new months of tracking. Software engineers use it to automate recurring spreadsheet setups. It copies a template sheet and renames the new tab with the current period.
- Duplicates Sheets templates for recurring periods
- Renames tabs with new month labels automatically
- Eliminates manual copy-paste workflows
Recipe Copy Sheet For New Month by the numbers
- 24,246 all-time installs (skills.sh)
- +807 installs in the week ending Jul 28, 2026 (Skillselion tracking)
- Ranked #43 of 690 Office & Documents skills by installs in the Skillselion catalog
- Data as of Jul 28, 2026 (Skillselion catalog sync)
recipe-copy-sheet-for-new-month capabilities & compatibility
- Works with
- google drive
- Use cases
- project management · planning
What recipe-copy-sheet-for-new-month says it does
Duplicate a Google Sheets template tab for a new month of tracking.
npx skills add https://github.com/googleworkspace/cli --skill recipe-copy-sheet-for-new-monthAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 24.2k |
|---|---|
| repo stars | ★ 30k |
| Last updated | July 22, 2026 |
| Repository | googleworkspace/cli ↗ |
How do you duplicate a Google Sheets tab for a new month?
Automate recurring spreadsheet template setup for monthly tracking
Who is it for?
Automating monthly spreadsheet setup
Skip if: Excel-only workflows, databases as source of truth, or spreadsheets without a reusable template tab.
When should I use this skill?
You need to create new spreadsheet tabs for recurring periods
What you get
A new Google Sheets tab copied from a template with an updated month name inside the target spreadsheet.
- Duplicated sheet tab for new month
- Updated tab name in target spreadsheet
By the numbers
- Recipe metadata version 0.22.5
- Uses 2 Sheets API operations: spreadsheets get and sheets copyTo
Files
Copy a Google Sheet for a New Month
PREREQUISITE: Load the following skills to execute this recipe: gws-sheetsDuplicate 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"}}]}'
Related skills
FAQ
Which gws skill does recipe-copy-sheet-for-new-month need?
recipe-copy-sheet-for-new-month requires the gws binary and gws-sheets skill per metadata version 0.22.5 before calling spreadsheets get and sheets copyTo endpoints.
What APIs does the monthly copy recipe call?
recipe-copy-sheet-for-new-month first runs gws sheets spreadsheets get to inspect the spreadsheet, then gws sheets spreadsheets sheets copyTo to duplicate the template sheet tab for the new month.