recipe-copy-sheet-for-new-month
Duplicate a template tab in Google Sheets to create new monthly data analysis or reports, simplifying repetitive monthly operations and improving data processing efficiency.
npx skills add googleworkspace/cli --skill recipe-copy-sheet-for-new-monthBefore / After Comparison
1 组Whenever a new data tracking spreadsheet is needed each month, the Google Sheet template tab must be manually duplicated, which is time-consuming and prone to errors. This impacts the timeliness of data tracking.
Automatically duplicate Google Sheet template tabs for new monthly data tracking. Significantly saves manual operation time and ensures a smooth and efficient data tracking process.
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
- Get spreadsheet details:
gws sheets spreadsheets get --params '{"spreadsheetId": "SHEET_ID"}' - Copy the template sheet:
gws sheets spreadsheets sheets copyTo --params '{"spreadsheetId": "SHEET_ID", "sheetId": 0}' --json '{"destinationSpreadsheetId": "SHEET_ID"}' - Rename the new tab:
gws sheets spreadsheets batchUpdate --params '{"spreadsheetId": "SHEET_ID"}' --json '{"requests": [{"updateSheetProperties": {"properties": {"sheetId": 123, "title": "February 2025"}, "fields": "title"}}]}'
User Reviews (0)
Write a Review
No reviews yet
Statistics
User Rating
Rate this Skill