Copy sheets and formatting with Google Apps Script based on values in Google Sheets on a specified schedule

■Overview

Do you find it time-consuming to copy sheets and formatting every time you create a recurring report in Google Sheets? With this workflow, Google Apps Script automatically copies the sheet and its formatting based on values in Google Sheets according to a specified schedule, freeing you from repetitive manual tasks. Automate recurring sheet creation and improve your productivity.

■Who This Template Is For

• Anyone who regularly creates standardized formats such as weekly or monthly reports in Google Sheets
• Teams looking to eliminate the hassle of manually copying sheets and prevent formatting errors
• Anyone who wants to automate Google Sheets operations using Google Apps Script

■Benefits of Using This Template

• Automatically create sheets on a specified schedule and reduce the time spent manually copying and configuring them.
• Prevent human errors such as forgetting to copy a sheet or applying incorrect formatting by consistently creating sheets in the same format without manual intervention.

■Flow

1. First, connect Google Apps Script and Google Sheets to Yoom.
2. Next, select the schedule trigger and set the action to “When the specified schedule is reached.”
3. Then, set the Google Sheets “Get values” action in an operation to retrieve information from the source sheet.
4. Finally, set the Google Apps Script “Run script” action in an operation to run a script that copies the sheet and its formatting based on the retrieved information.

■Customization Options

• In the schedule trigger, set the frequency (daily, weekly, monthly, etc.) and date and time when you want the workflow to run.
• In the Google Sheets “Get values” action, set the spreadsheet ID and sheet name (tab name) of the source sheet.
• In the Google Apps Script “Run script” action, configure the script for copying the sheet and its formatting as needed.

■Notes

・Connect both Google Sheets and Google Apps Script to Yoom.

・“Switch destination” is an operation available on the Personal plan and higher. On the Free plan, operations configured in the flow bot will result in an error.

・Paid plans, including the Personal plan, come with a two-week free trial. During the free trial, you can use apps and features (operations) that are otherwise subject to restrictions.