How to setup Sheet Director
Open a new Spreadsheet.
Click on "Add-ons" Menu > Sheet Director > Start Setup
Select the required app needed.
Configure Apps and Services:
Mention a name for the service.
Select the application required.
Select the service corresponding to the application selected.
Run automatically is switched on to schedule a service.
Scheduling service is done to run a service in the background at a regular interval of time.
This Schedule process runs in the background for the selected time interval and executes the services over that particular period of time.
Scheduling is done by selecting a particular time interval and the corresponding period.
Select the interval as Hourly.
The time period for hourly can be scheduled for every 1 hour, 2 hours ...... until every 12 hours.
Less than 1 hour cannot be scheduled in the scheduling process.
The time period for daily looks like the following image in the screenshot.
Click on "Execute" to execute the services, the execute function automatically saves the services also.
Click on "Save" to save the services.
Click on "Back" to exit the services.