Skip to content
Skillpedia
Automations32k · #6310

recipe-copy-sheet-for-new-month

Lets your agent copy a Google Sheets template for a new month. This saves time and ensures the format is correct for tracking.

What it does

This tool copies an existing Google Sheet to create a new one, perfect for organizing information for a new month. It duplicates a specific 'tab' (page) from your spreadsheet so you can start recording data for the next month without losing old records.

When to use it

  • ✓When you need a fresh spreadsheet to track your monthly finances.
  • ✓When starting a new project and wanting a clean copy of your tracking template.
  • ✓To organize your tasks or goals for the next month in a new tab.

Example of what to ask your AI

“Copy the 'Financial Tracker' spreadsheet and name the new tab 'March 2025'.”

Want more? Open the sections below.

How to use

The easiest way: copy the message below and paste it into Claude, ChatGPT, Cursor or any AI. It reads the skill and follows the instructions.

Skill link

https://github.com/googleworkspace/cli/blob/main/skills/recipe-copy-sheet-for-new-month/SKILL.md

Ready-to-paste message

Use this skill to help me: https://github.com/googleworkspace/cli/blob/main/skills/recipe-copy-sheet-for-new-month/SKILL.md Read the SKILL.md file at that link and follow its instructions for my task.
How it works

The tool first finds the details of your spreadsheet. Then, it creates an exact copy of the tab you chose and renames it with the name you specify, like 'March 2025'.

Installation

Easiest way: copy the skill link and paste it into Claude, ChatGPT or Cursor asking it to follow the instructions.

In the terminal (Claude Code, Codex, Cursor), in your project folder:

npx skills add googleworkspace/cli --skill recipe-copy-sheet-for-new-month

Or download just the file:

curl -L https://raw.githubusercontent.com/googleworkspace/cli/main/skills/recipe-copy-sheet-for-new-month/SKILL.md -o SKILL.md
Technical content (original SKILL.md)

Original text by the author, straight from GitHub.

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

Do I need to have a spreadsheet ready beforehand?

Yes, you need to have a spreadsheet in Google Sheets that will serve as the template to be copied.

What is 'SHEET_ID'?

It's a unique code that identifies your spreadsheet in Google Sheets. It's usually part of the spreadsheet's web address (URL).

What happens to the data in the original spreadsheet?

The original spreadsheet remains untouched. The tool only creates a copy of it.

Details

Original description by the author

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

repo: googleworkspace/cli

Popularity

GitHub stars
32k
Ranking position
#6310
License
Apache-2.0
Updated
10/6/2026

Is this skill useful?

0

Sign in to vote.

Comments

  • …

More skills from this repository

Similar skills