How to enable auto-refresh on your Google Sheets?

Allowing Castodia access to your Google Sheet

[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:

  1. In the Toolbar, click "Add-Ons," hover over the "Castodia Database Connector" and click "Settings"
  2. Within the database tab, the Castodia email is provided in "Note 2"
  3. Click the copy icon, go to share, paste the email, and make sure to turn on the "can edit" option

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.

Connectors

Start free trial

Try Castodia free for 14 days, no credit card required.