[Update: December 2020] This feature has changed. Users will no longer require to share each Google Sheet with the Castodia Service Account as described in the video and in the steps below. Instead, users will authorize Castodia once and this will enable auto-refresh in any Google Sheet for the specific user account. Please refer to the Getting Started guide for instructions on how to Authorize with Google to enable the auto-refresh feature on your Google Sheets.
If you've scheduled your sheets and notice that your data is not updating regularly, it is likely that you haven't shared your Google Sheet with our Castodia email. This step needs to be completed for both scheduled auto-refreshes and for long and complex query functions.
How to enable auto-refresh:
And you're done!
Please note that if you plan to use either of these features in another spreadsheet, make sure to re-share the sheet with our email.
Try Castodia free for 14 days, no credit card required.