recipe-copy-sheet-for-new-month

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

INSTALLATION
npx skills add https://github.com/googleworkspace/cli --skill recipe-copy-sheet-for-new-month
Run in your project or agent environment. Adjust flags if your CLI version differs.

SKILL.md

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

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

Let your agent run on any real-world website

Bypass CAPTCHA & anti-bot for free. Start local, scale to cloud.

Explore BrowserAct Skills →

Stop writing automation&scrapers

Install the CLI. Run your first Skill in 30 seconds. Scale when you're ready.

Start free
free · no credit card