recipe-copy-sheet-for-new-month
googleworkspace/cli
Duplicate a Google Sheets template tab for a new month of tracking.
What is recipe-copy-sheet-for-new-month?
This recipe automates the creation of monthly tracking sheets by duplicating a template tab in Google Sheets and renaming it for the new month. Use it to quickly set up recurring monthly workflows without manual copying.
- Retrieve spreadsheet metadata and structure
- Copy a template sheet to the same or different spreadsheet
- Rename the duplicated sheet with a new month label
- Automate repetitive monthly sheet setup tasks
How to install recipe-copy-sheet-for-new-month
npx skills add null --skill recipe-copy-sheet-for-new-month- gws-sheets skill installed
- Google Workspace CLI (gws) configured with authentication
- Access to the Google Sheet you want to duplicate
How to use recipe-copy-sheet-for-new-month
- 1.Identify your spreadsheet ID and the template sheet ID (usually 0 for the first sheet)
- 2.Run the get spreadsheet command to verify the sheet structure
- 3.Execute the copyTo command to duplicate the template sheet
- 4.Update the sheet ID and desired month name in the batchUpdate command
- 5.Run the rename command to label the new sheet with the current or target month
Use cases
- Create a new budget tracking sheet each month from a template
- Duplicate a project status sheet for monthly planning cycles
- Set up monthly expense or time-tracking sheets automatically
- Generate new monthly report templates from a master sheet
- Project managers tracking monthly metrics
- Finance teams managing monthly budgets
- Productivity enthusiasts with recurring monthly workflows
- Teams using Google Sheets for time or expense tracking
recipe-copy-sheet-for-new-month FAQ
Yes. In the copyTo command, set destinationSpreadsheetId to a different spreadsheet ID than the source.
The spreadsheet ID is in the Google Sheets URL: docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit
This recipe provides the steps; you can wrap them in a scheduler or workflow tool to run automatically each month.
Replace sheetId 0 with the ID of the sheet you want to copy. Use the get command to find sheet IDs.
Full instructions (SKILL.md)
Source of truth, from googleworkspace/cli.
name: recipe-copy-sheet-for-new-month description: "Duplicate a Google Sheets template tab for a new month of tracking." metadata: version: 0.22.5 openclaw: category: "recipe" domain: "productivity" requires: bins: - gws skills: - gws-sheets
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"}}]}'
Related skills
More from googleworkspace/cli and the wider catalog.
gws-gmail
Send, read, and manage Gmail emails via Google Workspace CLI.
gws-drive
Manage Google Drive files, folders, and shared drives via CLI.
gws-docs
Read and write Google Docs via command line.
gws-calendar
Manage Google Calendar events, calendars, and access control via CLI.
gws-sheets
Read and write Google Sheets spreadsheets via CLI.
gws-gmail-send
Send emails via Gmail with attachments, CC/BCC, HTML support, and draft options.