Automate your processes with Sheetgo for Google Sheets
Working with Sheetgo for Google Sheets is a great way of optimizing your data connections, by linking information from different spreadsheets into a single file. You can take this a step further by automating your connections, this will allow you to always have the most updated data, without having to manually run your connections.
To start automating your connections you need to first open Sheetgo for Google Sheets.
If you've already built a connection you will be able to see the Trigger button, at the middle of the connection box.
Click on the Trigger button and a new box will appear where you can choose the frequency you want to connection to run automatically. To start slide the toggle button to Run automatically.
Multiple times a day
If you select the Multiple times a day option you will need to specify the connection will run every hour, 2, 4, 6, 8, or 12 hours. Choose the Time Zone the connections will run on. Specify which Days the connections will run, it can be every day, Monday through Friday, and finally, the Time Range when the connections run. In the image above the connection runs every hour, from Monday through Friday, between 6 AM and 6 PM.
Once a day
If you select the Once a day option you need to choose the Hour when the connection will run. Specify the Time Zone. And select the Days when the connection will run. In the image above the connection runs between 4AM and 5AM, from Monday through Friday.
Once a month
If you select the Once a month option you need to choose the Day when the connection will run. Specify the Hour and the Time Zone. In the image above the connection runs on the 1st of every month, between 4AM and 5AM.
After you've selected the frequency that you want the workflow to run you will be able to see a message telling you how many transfers the setup will consume in a month. If you are happy with your set up click on Save.
After saving you will be back on the Connections box, if you hover your mouse over the Trigger button you can check how frequently this connection will run automatically. If you need to change this setup just click on the Trigger and follow the steps above to set the trigger that you want.