recipe-copy-sheet-for-new-month

Vercel

All-time installs

27.4K

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

Install

Other options

Summary

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

Automates the three-step workflow: retrieve spreadsheet metadata, copy a template sheet, and rename the new tab with a month identifier
Requires the gws-sheets skill and uses Google Sheets API commands for sheet operations
Ideal for recurring monthly tracking workflows where a consistent template structure needs to be replicated with minimal manual effort

Raw SKILL.md

1,002 bytes

---
name: recipe-copy-sheet-for-new-month
description: "Duplicate a Google Sheets template tab for a new month of tracking."
metadata:
  version: 0.22.5
  openclaw:
    category: "recipe"
    domain: "productivity"
    requires:
      bins:
        - gws
      skills:
        - gws-sheets
---

# 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.

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

Security audits

SnykPASS

SocketPASS

Gen Agent Trust HubPASS