Recipe Copy Sheet For New Month
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.
- skills.sh installs
- 30.8K
- GitHub stars
- 32.2K
- 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
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/googleworkspace/cli
- Category
- CLI & Terminal
More from googleworkspace/cli
All 113- Recipe Review Meet Participants30.8K
- Recipe Batch Invite To Event30.8K
- Recipe Collect Form Responses30.8K
- Recipe Create Events From Sheet30.7K
- Persona It Admin30.7K
- Recipe Create Vacation Responder30.7K
- Recipe Share Folder With Team30.7K
- Persona Customer Support30.7K
- Recipe Forward Labeled Emails30.7K
- Persona Event Coordinator30.6K
- Gws Modelarmor30.6K
- Persona Sales Ops30.6K
- Recipe Create Meet Space30.6K
- Recipe Create Expense Tracker30.6K
- Recipe Create Feedback Form30.5K
- Recipe Post Mortem Setup30.5K
- Gws Modelarmor Create Template30.5K
- Persona Hr Coordinator30.4K
- Recipe Share Event Materials30.4K
- Recipe Send Team Announcement30.3K
- Gws Modelarmor Sanitize Prompt30.3K
- Gws Classroom30.2K
- Gws Modelarmor Sanitize Response30.2K
- Recipe Log Deal Update30.2K
Recommended
More CLI & Terminal
recipe-batch-invite-to-eventgoogleworkspace/cliAdd a list of attendees to an existing Google Calendar event and send notifications.30.8Kskills.sh installsrecipe-create-events-from-sheetgoogleworkspace/cliRead event data from a Google Sheets spreadsheet and create Google Calendar entries for each row.30.7Kskills.sh installsrecipe-create-vacation-respondergoogleworkspace/cliEnable a Gmail out-of-office auto-reply with a custom message and date range.30.7Kskills.sh installsrecipe-share-folder-with-teamgoogleworkspace/cliShare a Google Drive folder and all its contents with a list of collaborators.30.7Kskills.sh installspersona-customer-supportgoogleworkspace/cliManage customer support — track tickets, respond, escalate issues.30.7Kskills.sh installsrecipe-forward-labeled-emailsgoogleworkspace/cliFind Gmail messages with a specific label and forward them to another address.30.7Kskills.sh installs