RE

recipe-copy-sheet-for-new-month

Copies and renames a Google Sheets tab for a new month automatically.

Install

mkdir -p .claude/skills/recipe-copy-sheet-for-new-month && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/14439" && unzip -o skill.zip -d .claude/skills/recipe-copy-sheet-for-new-month && rm skill.zip

Installs to .claude/skills/recipe-copy-sheet-for-new-month

Activation

This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.

Duplicate a Google Sheets template tab for a new month of tracking.
67 charsno explicit “when” trigger
Beginner

Key capabilities

  • Get spreadsheet details using `gws sheets spreadsheets get`
  • Copy a template sheet to a new destination using `gws sheets spreadsheets sheets copyTo`
  • Rename the new tab with a new title using `gws sheets spreadsheets batchUpdate`

How it works

This skill uses the `gws-sheets` skill to interact with the Google Sheets API. It first gets spreadsheet details, then copies a specified template sheet, and finally renames the newly created tab.

Inputs & outputs

You give it
A Google Sheet ID and the sheet ID of the template tab
You get back
A new Google Sheets tab, duplicated from a template and renamed for a new month

When to use recipe-copy-sheet-for-new-month

  • Setting up a new tracking month
  • Duplicating budget templates
  • Preparing monthly report tabs

About this skill

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

When not to use it

  • When duplicating a Google Sheet for purposes other than a new month of tracking
  • When only a single sheet needs to be created without copying a template
  • When the Google Sheets API is not the desired method for sheet manipulation

Prerequisites

gwsgws-sheets

Limitations

  • It requires the `gws` and `gws-sheets` skills to be loaded
  • The process is specific to duplicating a template tab for a new month
  • It assumes a template sheet exists with a known sheet ID

How it compares

This skill automates the specific sequence of duplicating a Google Sheets template and renaming it for a new month, providing a simplify process compared to performing these steps manually through the Sheets interface.

Compared to similar skills

recipe-copy-sheet-for-new-month side by side with the closest alternatives in the catalog.

SkillInstallsUpdatedSafetyDifficulty
recipe-copy-sheet-for-new-month (this skill)01moNo flagsBeginner
gog782moReviewIntermediate
calc03moReviewBeginner
bewerbungs-tracker03moNo flagsBeginner

Try saying

Example prompts that trigger this skill in your AI assistant.

Search skills

Search the agent skills registry