OpenSkillIndex← back to search
claude-code

Skillshub recipe-copy-sheet-for-new-month

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

install
source · Clone the upstream repo
git clone https://github.com/ComeOnOliver/skillshub
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/ComeOnOliver/skillshub "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/googleworkspace/cli/recipe-copy-sheet-for-new-month" ~/.claude/skills/comeonoliver-skillshub-recipe-copy-sheet-for-new-month && rm -rf "$T"
manifest: skills/googleworkspace/cli/recipe-copy-sheet-for-new-month/SKILL.md
source content

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