---
id: ssh2-recipe-copy-sheet-for-new-month
name: "recipe-copy-sheet-for-new-month"
url: https://skills.yangsir.net/skill/ssh2-recipe-copy-sheet-for-new-month
author: googleworkspace
domain: data-analysis
tags: ["google-sheets", "spreadsheet-templates", "monthly-reporting", "data-duplication", "workflow-automation"]
install_count: 14700
rating: 4.50 (144 reviews)
github: https://github.com/googleworkspace/cli
---

# recipe-copy-sheet-for-new-month

> 复制Google表格中的模板标签页，用于创建新月份的数据分析或报告，简化每月重复操作，提高数据处理效率。

**Stats**: 14,700 installs · 4.5/5 (144 reviews)

## Before / After 对比

### 快速复制表格模板，简化月度数据追踪。

## Readme

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



---
*Source: https://skills.yangsir.net/skill/ssh2-recipe-copy-sheet-for-new-month*
*Markdown mirror: https://skills.yangsir.net/api/skill/ssh2-recipe-copy-sheet-for-new-month/markdown*