recipe-copy-sheet-for-new-month

Name: recipe-copy-sheet-for-new-month
Author: googleworkspace

24kinstalls1.7kforks

How to install recipe-copy-sheet-for-new-month?

googleworkspace/cli/recipe-copy-sheet-for-new-month

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

Installs into the current project.

Summary

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

Files · 1

SKILL.md

1	# Copy a Google Sheet for a New Month
2
3	> PREREQUISITE: Load the following skills to execute this recipe: `gws-sheets`
4
5	Duplicate a Google Sheets template tab for a new month of tracking.
6
7	## Steps
8
9	1. Get spreadsheet details: `gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'`
10	2. Copy the template sheet: `gws sheets spreadsheets sheets copyTo --params '{"spreadsheetId": "SHEET_ID", "sheetId": 0}' --json '{"destinationSpreadsheetId": "SHEET_ID"}'`
11	3. Rename the new tab: `gws sheets spreadsheets batchUpdate --params '{"spreadsheetId": "SHEET_ID"}' --json '{"requests": [{"updateSheetProperties": {"properties": {"sheetId": 123, "title": "February 2025"}, "fields": "title"}}]}'`

6 picks

Type