Recipe Copy Sheet For New Month

by googleworkspacea3768d0e82adNo licenseListed Oct 8, 2026Updated Oct 8, 2026

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

AI-generated overview

Duplicates a Google Sheets template tab and renames it for a new month of tracking.

What it does: This recipe walks through copying a template tab inside a Google Sheets spreadsheet so a new month of tracking can begin. It uses the gws command-line tool to fetch spreadsheet details, copy the template sheet to the same spreadsheet, and rename the new tab. The result is a fresh, renamed sheet ready for the new month's data.
When to use it: Use it at the start of a new tracking period when a spreadsheet already has a template tab that should be reused. It suits recurring monthly logs where the same layout is duplicated each month.
Requirements: Requires the gws command-line binary and the gws-sheets skill. It needs access to the target Google Sheets spreadsheet and its spreadsheet and sheet IDs. No scripts ship with the skill; it is instructions only.

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.

Get spreadsheet details: gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'
Copy the template sheet: gws sheets spreadsheets sheets copyTo --params '{"spreadsheetId": "SHEET_ID", "sheetId": 0}' --json '{"destinationSpreadsheetId": "SHEET_ID"}'
Rename the new tab: gws sheets spreadsheets batchUpdate --params '{"spreadsheetId": "SHEET_ID"}' --json '{"requests": [{"updateSheetProperties": {"properties": {"sheetId": 123, "title": "February 2025"}, "fields": "title"}}]}'

License: No license

Content belongs to its original authors. SourceWeft indexes it from a public repository.