recipe-copy-sheet-for-new-month: a Google Workspace CLI skill for Claude

Makes Claude duplicate a template tab in a Google Sheet and rename it for the new month.

Installs: 30.5K; on skills.sh
Stars: 32K; on GitHub
Updated: Oct 2026; last repo commit

recipe-copy-sheet-for-new-month is a 3-step recipe for Claude. It reads the spreadsheet, copies a template tab inside the same spreadsheet, and renames the copy. The example renames it "February 2025" and uses placeholder sheet IDs, so give Claude your spreadsheet ID, the template tab and the new name.

It needs the gws command-line tool installed and signed in to your Google account, plus these skills, which the install box adds: gws-shared, gws-sheets. Claude runs the gws commands in your terminal, so it works in an agent that can run shell commands. Ask for the job in plain words and give your own names, dates and addresses.

Good for

People who track budgets or logs with one tab per month
Ops and finance teams that rebuild the same sheet monthly
Claude Code or Codex users who already run the gws command-line tool

Install recipe-copy-sheet-for-new-month

Claude Code

Copy this prompt.

Install the recipe-copy-sheet-for-new-month skill in Claude Code. Run this command:

npm install -g @googleworkspace/cli

Then check that it loaded and tell me how to use it.

2
Paste it into Claude Code. It shows the change and asks before running it.

Requires Node.js 18 or newer.

Read-only mode: Add --dry-run to a gws command to check the request without calling the API.

Run all three steps in order. The skills only drive the gws program, so it must be installed and signed in first. The skills CLI adds 3 skills: gws-shared, gws-sheets, recipe-copy-sheet-for-new-month. At sign-in, choose only the Google services this skill needs, for example gws auth login -s drive,gmail,sheets. The README warns that the full recommended scope list fails for unverified apps, and gives a manual OAuth route if gcloud is not available. The Claude app is not covered: the README does not document it, and gws has to run on your own computer.

From the project README. Source.

What's in the skill

When it loads

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

Sections in SKILL.md

Steps

Key facts

Author: googleworkspace (GitHub organisation that owns the repo)
Status: Not an officially supported Google product
Repo: googleworkspace/cli, folder skills/recipe-copy-sheet-for-new-month
License: Apache-2.0
Skill version: 0.22.5
Installs on skills.sh: 30,463 as of 2026-11-02
GitHub stars: 32,038 as of 2026-11-02 (whole repo)
Last repo commit: 2026-10-30
Files: 1 file: SKILL.md
Needs: The gws program, Node.js 18+ for the npm install, and a Google Cloud project for sign-in
skills.sh audits: Gen Agent Trust Hub pass, Socket pass, Snyk pass

What it includes

Claude loads the listed skills before it starts
SKILL.md opens with a note to load gws-sheets to run this recipe.
Prerequisite: load gws-sheets
Reads the spreadsheet to find the template tab
Reads the spreadsheet's details.
Runs code · Step 1: Get spreadsheet details
Copies the template tab into the same spreadsheet
Uses the copyTo call with the spreadsheet as its own destination.
Runs code · Step 2: Copy the template sheet
Gives the copy a new title, such as a month name
Sends an update request that changes the tab's title. The tab ID in the example is a placeholder.
Runs code · Step 3: Rename the new tab

From the official docs

Permissions

Medium risk

What it can do

Read your data
Create and change things
Delete things
Read-only mode

Watch out for

It adds a tab to a spreadsheet you can edit
The copy and rename change the spreadsheet. Check the sheet and tab IDs Claude uses, because the SKILL.md values are placeholders. github.com
Sign in with only the Google service you need
gws signs in with OAuth through a Google Cloud project, and your choice at gws auth login decides what it can reach. The README says the full recommended preset has 85+ scopes and fails for unverified apps. github.com
gws is not an official Google product
The README says so, and warns to expect breaking changes before v1.0. Its npm route downloads the gws binary from GitHub Releases. github.com

Technical details

Turning on read-only	gws has a --dry-run flag that validates a request locally without calling the API.
Talks to	Google Workspace APIs, called by the gws program. Google Discovery Service, which gws reads at runtime
Sign-in and keys	gws signs in with Google OAuth. The README says credentials are encrypted at rest (AES-256-GCM), with the key in your OS keyring, or in ~/.config/gws/.encryption_key when the file backend is chosen.
Scopes	Google services you choose at gws auth login: sheets

Questions

What do I get from recipe-copy-sheet-for-new-month?

A new tab in the same spreadsheet, copied from your template tab and renamed. The sheet ID, tab ID and the "February 2025" title in SKILL.md are examples.

How do I install recipe-copy-sheet-for-new-month?

Use the install box at the top of this page. It adds recipe-copy-sheet-for-new-month, gws-shared and gws-sheets with the skills CLI. You also need the gws program installed and signed in to Google, which the first two steps in the box cover. The README lists Node.js 18+ for the npm install and a Google Cloud project for sign-in.

Do I need a Google Cloud project or an API key?

You need a Google Cloud project for sign-in. The README describes OAuth sign-in with a Google account, and it also supports a service account file or a pre-obtained access token. gws auth setup creates the project for you but needs the gcloud CLI. Without gcloud, the README has a manual OAuth route. In testing mode Google limits an unverified app to about 25 scopes, so pick individual services at sign-in.

Is recipe-copy-sheet-for-new-month safe to run?

Use it with care. It adds a tab to a spreadsheet you can edit. The gws-shared skill tells the agent to confirm write and delete commands with you and to prefer --dry-run for destructive operations. The README says gws is not an officially supported Google product and that breaking changes are expected before v1.0. Watch the first run yourself.

Does recipe-copy-sheet-for-new-month work in the Claude app or Codex?

The install box has Claude Code and Codex tabs that use the skills CLI. The README does not document the Claude app, and the skill only drives a gws program installed on your own computer. The README also documents OpenClaw and a Gemini CLI extension for the repo's skills.

How is it different from gws-sheets?

gws-sheets covers the general Sheets commands. This recipe is one fixed copy-and-rename sequence on top of it, and its SKILL.md lists gws-sheets as required.

Information

updated Nov 2, 2026

Repository: googleworkspace/cli
Folder: skills/recipe-copy-sheet-for-new-month

googleworkspace/cli skills.sh

Sources

Docs, issue trackers and discussions this page is built from.

Show all 4

googleworkspace/cli README · github.com
gws-shared SKILL.md · github.com
recipe-copy-sheet-for-new-month SKILL.md · github.com
gws-sheets SKILL.md · github.com