back
loading skill details...
Duplicate a Google Sheets template tab for a new month of tracking.
Duplicate a Google Sheets template tab for a new month of tracking.
Automates the three-step workflow: retrieve spreadsheet metadata, copy a template sheet, and rename the new tab with a month identifier
Requires the gws-sheets skill and uses Google Sheets API commands for sheet operations
Ideal for recurring monthly tracking workflows where a consistent template structure needs to be replicated with minimal manual effort
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"}}]}'don't have the plugin yet? install it then click "run inline in claude" again.