Back to Details

recipe-copy-sheet-for-new-month

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Copy a Google Sheet for a New Month

为新月份复制Google Sheet

PREREQUISITE: Load the following skills to execute this recipe: 
gws-sheets
Duplicate a Google Sheets template tab for a new month of tracking.
前提条件： 加载以下技能以执行此方案：
gws-sheets
复制Google Sheets模板标签以用于新月份的追踪记录。

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"}}]}'
  1. 获取电子表格详情：
    gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}'
  2. 复制模板工作表：
    gws sheets spreadsheets sheets copyTo --params '{"spreadsheetId": "SHEET_ID", "sheetId": 0}' --json '{"destinationSpreadsheetId": "SHEET_ID"}'
  3. 重命名新标签：
    gws sheets spreadsheets batchUpdate --params '{"spreadsheetId": "SHEET_ID"}' --json '{"requests": [{"updateSheetProperties": {"properties": {"sheetId": 123, "title": "February 2025"}, "fields": "title"}}]}'