recipe-copy-sheet-for-new-month
Duplicate a Google Sheets template tab for a new month of tracking.
By googleworkspace · 27,532 installs
npx skills add googleworkspace/cli --skill recipe-copy-sheet-for-new-month
Source repository · Upstream listing
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
1. Get spreadsheet details: gws sheets spreadsheets get params '{"spreadsheetId": "SHEET ID"}'
2. Copy the template sheet: gws sheets spreadsheets sheets copyTo params '{"spreadsheetId": "SHEET ID", "sheetId": 0}' json '{"destinationSpreadsheetId": "SHEET ID"}'
3. Rename the new tab: gws sheets spreadsheets batchUpdate params '{"spreadsheetId": "SHEET ID"}' json '{"requests": [{"updateSheetProperties": {"properties": {"sheetId": 123, "title": "February 2025"}, "fields": "title"}}]}'