1---
2name: recipe-copy-sheet-for-new-month
3description: "Duplicate a Google Sheets template tab for a new month of tracking."
4metadata:
5  version: 0.22.5
6  openclaw:
7    category: "recipe"
8    domain: "productivity"
9    requires:
10      bins:
11        - gws
12      skills:
13        - gws-sheets
14---
15 
16# Copy a Google Sheet for a New Month
17 
18> **PREREQUISITE:** Load the following skills to execute this recipe: `gws-sheets`
19 
20Duplicate a Google Sheets template tab for a new month of tracking.
21 
22## Steps
23 
241. Get spreadsheet details: `gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'`
252. Copy the template sheet: `gws sheets spreadsheets sheets copyTo --params '{"spreadsheetId": "SHEET_ID", "sheetId": 0}' --json '{"destinationSpreadsheetId": "SHEET_ID"}'`
263. Rename the new tab: `gws sheets spreadsheets batchUpdate --params '{"spreadsheetId": "SHEET_ID"}' --json '{"requests": [{"updateSheetProperties": {"properties": {"sheetId": 123, "title": "February 2025"}, "fields": "title"}}]}'`
27 
28