Copy a Google Sheet for a New Month

PREREQUISITE: Load the following skills to execute this recipe:

gws-sheets

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"}}]}'