Can I use this for any Google Spreadsheet?

Yes, provided you have the Spreadsheet ID and the necessary access permissions configured through your Google Workspace credentials.

What prerequisites are needed for this skill?

You must have the 'gws' binary installed on your system and the 'gws-sheets' Claude Code skill loaded to execute this recipe.

Can I clone a sheet to a different file entirely?

Yes, the recipe supports a 'destinationSpreadsheetId' parameter, allowing you to copy a template from one file into a completely different spreadsheet.

Does it automatically handle the naming of the new month?

The skill provides the structure to rename the tab; you can instruct Claude to use a specific title like 'March 2025' during the batchUpdate step.

Is this process reversible if I make a mistake?

While the skill performs actions directly on your sheet, you can manually delete the created tab or use Google Sheets' version history to revert changes.

Google Sheets Monthly Template Replicator

Name: Google Sheets Monthly Template Replicator
Author: hazelugo

byhazelugo

0•

生産性とワークフロー

Automates the duplication and renaming of Google Sheets template tabs for recurring monthly tracking tasks.

This skill streamlines the process of setting up new tracking sheets by automatically cloning a template tab within a Google Spreadsheet and renaming it for the current or upcoming month. By leveraging the Google Workspace (GWS) API, it eliminates the manual overhead of sheet management, ensuring consistency across recurring reports. It is particularly useful for project managers, accountants, and data analysts who maintain monthly logs and need a reliable, error-free way to initialize new tracking periods.

主な機能

01Automated template duplication within existing Google Spreadsheets

02Seamless integration with Google Workspace via GWS commands

03Dynamic sheet renaming for accurate monthly organization

04Cross-spreadsheet cloning support via destination IDs

05Reduction of manual data entry errors during sheet setup

060 GitHub stars

ユースケース

01Creating standardized monthly inventory sheets for warehouse management

02Initializing recurring project performance logs at the start of each month

03Generating a new monthly expense tracking tab from a master template

主な機能

01Automated template duplication within existing Google Spreadsheets

02Seamless integration with Google Workspace via GWS commands

03Dynamic sheet renaming for accurate monthly organization

04Cross-spreadsheet cloning support via destination IDs

05Reduction of manual data entry errors during sheet setup

060 GitHub stars

ユースケース

01Creating standardized monthly inventory sheets for warehouse management

02Initializing recurring project performance logs at the start of each month

03Generating a new monthly expense tracking tab from a master template