Recipe Copy Sheet For New Month
googleworkspace/cliOfficial
A straightforward recipe for duplicating Google Sheets tabs when you need monthly tracking templates. It walks through the three-step process: fetching spreadsheet details, copying your template sheet, and renaming the duplicate with the new month. Handy for budget trackers, habit logs, or any recurring monthly data collection where you want to start fresh but keep the same structure. The commands are basic Google Workspace API calls, so you'll need the gws-sheets skill loaded first. Nothing fancy, but it beats manually copying tabs every month when you're maintaining multiple tracking spreadsheets.
- installs
- 30.2K
- GitHub stars
- 31.9K
- last updated
- Aug 21, 2026
Install
$ npx -y skills add googleworkspace/cli --skill recipe-copy-sheet-for-new-month --agent claude-codeInstalls into .claude/skills of the current project.
Files
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"}}]}'
Sponsors
Details
- Repository
- github.com/googleworkspace/cli
- Category
- CLI & Terminal
