recipe-copy-sheet-for-new-month
SolidDuplicate a Google Sheets template tab for a new month of tracking.
AI & Automation 26,720 stars
1406 forks Updated today Apache-2.0
Install
Quality Score: 94/100
Stars 20%
Recency 20%
Frontmatter 20%
Documentation 15%
Issue Health 10%
License 10%
Description 5%
Skill 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"}}]}'`
Details
- Author
- googleworkspace
- Repository
- googleworkspace/cli
- Created
- 3 months ago
- Last Updated
- today
- Language
- Rust
- License
- Apache-2.0
Integrates with
Similar Skills
Semantically similar based on skill content — not just same category
AI & Automation Solid
recipe-compare-sheet-tabs
Read data from two tabs in a Google Sheet to compare and identify differences.
26,720 Updated today
googleworkspace AI & Automation Solid
recipe-create-expense-tracker
Set up a Google Sheets spreadsheet for tracking expenses with headers and initial entries.
26,720 Updated today
googleworkspace AI & Automation Solid
recipe-create-events-from-sheet
Read event data from a Google Sheets spreadsheet and create Google Calendar entries for each row.
26,720 Updated today
googleworkspace Data & Documents Solid
recipe-create-doc-from-template
Copy a Google Docs template, fill in content, and share with collaborators.
26,720 Updated today
googleworkspace Data & Documents Solid
recipe-generate-report-from-sheet
Read data from a Google Sheet and create a formatted Google Docs report.
26,720 Updated today
googleworkspace