recipe-copy-sheet-for-new-month
Duplicate a Google Sheets template tab for a new month of tracking
by googleworkspaceFree
Description
recipe-copy-sheet-for-new-month is a recipe skill from the Google Workspace CLI project, listed on skills.sh. It duplicates a template tab in a Google Sheet to start a new month of tracking. The workflow has three steps. The first gets the spreadsheet's details, including its sheets and their IDs. The second copies the template sheet into the same spreadsheet, using the copyTo method with the destination spreadsheet ID. The third renames the new tab with a month identifier, through a batch update that sets the sheet title. The example in the recipe renames the tab to February 2025. The recipe requires the gws-sheets skill, and it uses Google Sheets API commands for the sheet operations. It suits people who keep a monthly budget, a timesheet or a log in a sheet, and who want each month's tab to start from the same template without copying it by hand.…
Highlights
- Copies a template tab for each month
- Renames the new tab with a month title
- Uses the Sheets API batch update
- Needs the gws-sheets skill
Ratings & Reviews
No ratings yet
Be the first to rate recipe-copy-sheet-for-new-month.
People also visit
recipe-create-expense-tracker
Google Sheets spreadsheet template for expense tracking
recipe-generate-report-from-sheet
Extract Google Sheet data and generate a formatted Google Docs report
recipe-log-deal-update
Append deal status updates to a Google Sheets sales tracking spreadsheet
recipe-copy-sheet-for-new-month FAQ
What does this recipe do?
It copies a template tab in a Google Sheet and renames the copy for a new month.
How do I install it?
Run: npx skills add https://github.com/googleworkspace/cli --skill recipe-copy-sheet-for-new-month
Where does the copy go?
The recipe copies the template sheet to the destination spreadsheet ID given in the command, which is the same spreadsheet in the example.
How is the tab renamed?
With a batch update that sets the sheet's title, such as February 2025 in the example.
Has it been checked for security?
skills.sh lists three audits: Gen Agent Trust Hub Pass, Socket Pass and Snyk Pass.
What are the best recipe-copy-sheet-for-new-month alternatives?
Popular alternatives to recipe-copy-sheet-for-new-month include recipe-create-expense-tracker, recipe-generate-report-from-sheet and recipe-log-deal-update. See all recipe-copy-sheet-for-new-month alternatives