# Recipe Copy Sheet For New Month

> Duplicate a Google Sheets template tab for a new month of tracking.

Source: https://skillsagentes.com/skills/googleworkspace/cli/recipe-copy-sheet-for-new-month
Repository: https://github.com/googleworkspace/cli
Author: googleworkspace
License: Apache-2.0
Updated: hace 4 meses
Context cost: 17 tok installed, 251 tok once triggered, 251 tok with every bundled file
Bundle: 1 file, 1002 B
Permissions requested: none declared

## Install

```bash
npx -y skills add googleworkspace/cli --skill recipe-copy-sheet-for-new-month --agent claude-code
```

## What it does

- Obtiene los detalles de la hoja de cálculo con `gws sheets spreadsheets get`
- Duplica la pestaña plantilla con `gws sheets spreadsheets sheets copyTo`
- Renombra la nueva pestaña con `gws sheets spreadsheets batchUpdate` usando `updateSheetProperties`

## Use it when

- Necesitas duplicar una pestaña plantilla de Google Sheets para un nuevo mes de seguimiento

## What triggers it

- "Copia la hoja plantilla para el seguimiento de marzo"
- "Duplica la pestaña de este mes y renómbrala a 'Febrero 2025'"

## Before you install

- Requiere el binario `gws` y la skill `gws-sheets` cargada previamente.

## Files

- SKILL.md — 1002 B

## SKILL.md

Reproduced verbatim from googleworkspace/cli under Apache-2.0. This section is the upstream document and is in English.

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

---

Skills Agentes — https://skillsagentes.com/skills/googleworkspace/cli/recipe-copy-sheet-for-new-month