SkillsSKILLS
Marketing

recipe-copy-sheet-for-new-month▌

googleworkspace/cli · updated Apr 8, 2026

$npx skills add https://github.com/googleworkspace/cli --skill recipe-copy-sheet-for-new-month
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
skill.md

1d:["$","div",null,{"className":"prose prose-invert max-w-none prose-headings:font-semibold prose-headings:tracking-tight prose-h1:text-4xl prose-h1:mb-2 prose-h2:text-2xl prose-h2:mb-2 prose-h3:text-lg prose-h3:mb-2 prose-p:text-muted-foreground prose-li:text-muted-foreground prose-code:bg-muted prose-code:text-foreground prose-code:px-1 prose-code:py-0.5 prose-code:rounded-sm prose-code:text-sm prose-code:before:content-none prose-code:after:content-none prose-pre:bg-muted prose-pre:text-foreground prose-pre:border prose-pre:border-border prose-pre:rounded-md [&_table]:!border-[color:var(--border)] [&_th]:!border-[color:var(--border)] [&_td]:!border-[color:var(--border)]","dangerouslySetInnerHTML":{"__html":"<h1>Copy a Google Sheet for a New Month</h1>\n<blockquote>\n<p><strong>PREREQUISITE:</strong> Load the following skills to execute this recipe: <code>gws-sheets</code></p>\n</blockquote>\n<p>Duplicate a Google Sheets template tab for a new month of tracking.</p>\n<h2>Steps</h2>\n<ol>\n<li>Get spreadsheet details: <code>gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'</code></li>\n<li>Copy the template sheet: <code>gws sheets spreadsheets sheets copyTo --params '{"spreadsheetId": "SHEET_ID", "sheetId": 0}' --json '{"destinationSpreadsheetId": "SHEET_ID"}'</code></li>\n<li>Rename the new tab: <code>gws sheets spreadsheets batchUpdate --params '{"spreadsheetId": "SHEET_ID"}' --json '{"requests": [{"updateSheetProperties": {"properties": {"sheetId": 123, "title": "February 2025"}, "fields": "title"}}]}'</code></li>\n</ol>"}}]