Copy a Google Sheet for a New Month

SkillDev tools

This skill lets your AI set up a new month of tracking in Google Sheets. Once added, it can duplicate your template tab and rename it for the new month, so a fresh tracking page is ready to go. It suits anyone who keeps monthly records in a spreadsheet.

Available today. Use it from your connected AI after setup.

After adding it, tell your AI which sheet holds your template tab and ask it to set up the new month. Then ask again whenever a new month begins.

Then ask your AI: use the Copy a Google Sheet for a New Month skill

What your AI can do with it

  • Duplicate a Google Sheets template tab
  • Rename the copied tab for the new month
  • Create a fresh page of tracking without manual copying
  • Reuse the same template layout every month

What this skill tells your AI

The instructions your AI receives, as published by googleworkspace/cli in skills/recipe-copy-sheet-for-new-month/SKILL.md and read by ahel’s review.

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

Signals

GitHub stars
31k
Forks
2k
Last commit
Sep 2026
Advanced
Catalog kind
skill
Gateway key
recipe-copy-sheet-for-new-month
Source
github.com/googleworkspace/cli