Setting auto-refreshes is a simple way of updating your query without manual input and constant monitoring. Our scheduler allows you to set automatic entries from as often as every minute to once a year.
To use this feature, follow the steps below:
Click the launch button of the Castodia Database Connector to access the add-on
Go to the schedule tab
Choose a particular query you'd like to automate and the sheet to run it in
Choose the option to either repeat the data on a daily, weekly, monthly or yearly basis
Set it once or on iterations of minutes and hours
Decide on the time frame to auto-refresh the data - Note: The timezone automatically changes based on your IP
Decide whether you'd like to append or overwrite your query
Click "schedule" once you're happy with your inputs
Share the sheet with the email provided - make sure the "edit" option is selected
And that's it! Check-in once in a while to watch your data entries update. If there are any issues, please reach out to us.