Recipe Copy Sheet For New Month
googleworkspace/cli20.2k
This skill automates the process of duplicating a Google Sheets template tab for a new month of tracking. It provides key capabilities such as retrieving spreadsheet details, copying a specific sheet, and renaming the new tab, making it ideal for users managing recurring monthly data without manual effort. Designed for productivity enhancement, it is useful for anyone who regularly updates tracking sheets in Google Sheets.
Copy a Google Sheet for a New Month
PREREQUISITE: Load the following skills to execute this recipe:
gws-sheetsDuplicate 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"}}]}'
GitHub Owner
Owner: googleworkspace
GitHub Links
- Website: https://developers.google.com/workspace
- Twitter: https://twitter.com/workspacedevs
SKILL.md
name: recipe-copy-sheet-for-new-month version: 1.0.0 description: "Duplicate a Google Sheets template tab for a new month of tracking." metadata: 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-sheetsDuplicate 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"}}]}'