Skip to content
Get packs

Copy a Google Sheet for a New Month

Duplicate a Google Sheets template tab and rename it for a new month of tracking

Source Download skill
Repository
googleworkspace/cli
Stars
32,059
Licence
Apache-2.0
Files
1 file

What it does

This skill gives the agent a short step-by-step recipe for making a fresh monthly tab from a template inside a Google Sheet. The agent looks up the spreadsheet, copies the template tab within the same file, and renames the new tab (for example to a month name). It works by issuing commands through the gws command-line tool, which talks to Google Sheets on your behalf, so it only does something useful if that tool and your Google access are already set up.

Great for

  • People who reuse the same Google Sheets layout every month, such as budgets, timesheets or sales trackers
  • Teams that want a consistent monthly tab created without manual copying and renaming

Skip it if

  • Anyone without the gws tool installed and authenticated to a Google account, since the skill cannot work without it
  • Sheets where the template should be changed rather than copied, or where the sheet ID and tab ID are not known, because the steps use placeholder IDs that must be filled in correctly and a wrong ID could modify the wrong file

Try asking

  • “Make a new February 2025 tab from my expense template in my budget spreadsheet”
  • “Copy the template tab in this sheet and rename the copy to March 2025”
  • “Set up next month's tracking tab in our team timesheet file”
Step-by-step guide: how to use Copy a Google Sheet for a New MonthInstall, first run, examples, tips and FAQs

Install in 3 steps

  1. 1

    Download the skill

    The ZIP contains the 1 original files, the Apache-2.0 licence and an attribution note.

    recipe-copy-sheet-for-new-month.zip
  2. 2

    Add it to your agent

    Claude Code (all projects)

    mkdir -p ~/.claude/skills && unzip recipe-copy-sheet-for-new-month.zip -d ~/.claude/skills/

    Claude Code / Agent SDK (this project only)

    mkdir -p .claude/skills && unzip recipe-copy-sheet-for-new-month.zip -d .claude/skills/

    Claude apps (web/desktop): Settings → Capabilities → Skills → Upload skill, and choose the ZIP.

  3. 3

    Ask for the task

    No special command needed — the agent reads the skill's description and loads it when your request matches. Try one of the prompts above.

Get better results

  • Give the agent the exact spreadsheet ID and the name of the template tab so it does not guess
  • Check the new tab's title and contents afterwards, since the example steps use a fixed sheetId of 0 and a hard-coded title that the agent must adapt

What's inside

  • SKILL.md

Redistributed unmodified from googleworkspace/cli under the Apache-2.0 licence. The assessment was drafted with AI from the skill's files on 2026-10-29. Skills can instruct your agent to run code — read SKILL.md and any scripts before installing.