[Update: December 2020] Users will no longer need to individually share each sheet with the Castodia service account as described in the video. Users will instead be required to authenticate with their Google Account only once and this will automatically enable auto-refresh for any sheet. Please refer to the Getting Started guide for a step-by-step guide on how to Authenticate with Google to allow Enable the auto-refresh feature.
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:
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.
Try Castodia free for 14 days, no credit card required.