/recipe-copy-sheet-for-new-month

allowed-tools: Bash, Read, Write, Edit
argument-hint: [task-parameters]
description: Duplicate a Google Sheets template tab for a new month of tracking.

Copy Sheet For New Month

Execute Google Workspace workflow: $ARGUMENTS

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

Task

Execute this workflow with the following parameters: $ARGUMENTS

1. **Prerequisites Check**

• Verify `gws` CLI is installed: `gws --version`
• Confirm authentication: `gws auth status`
• Load required GWS skills (check PREREQUISITE section above)

2. **Parameter Preparation**

• Parse task parameters from $ARGUMENTS
• Validate required inputs
• Prepare JSON payloads and flags

3. **Execute Workflow Steps**

• Follow the steps outlined above
• Replace placeholder IDs with actual values
• Handle errors and retries
• Log progress and results

4. **Verify Results**

• Confirm each step completed successfully
• Verify changes in Google Workspace
• Report final status and any issues

Tips

• Use `--dry-run` flag when available to preview changes
• Always inspect API schemas before calling: `gws schema <service>.<resource>.<method>`
• Check command help for all flags: `gws <service> <resource> <method> --help`

---

**License**: Apache License 2.0 **Source**: [Google Workspace CLI](https://github.com/googleworkspace/cli) **Original Skill**: `recipe-copy-sheet-for-new-month`