Castodia lets you connect Google Sheets to your databases and auto-refresh data on a custom schedule, with down to 1 minute auto-refresh frequency.
Connect Google Sheets to your databases and data warehouses such as PostgreSQL, Snowflake, Redshift, MySQL, MariaDB, Oracle Database, or Microsoft SQL Server Run. Run and save SQL queries. Auto-refresh data on any schedule, once, or every 1 minute. No more manual CSV data exports that don’t auto-refresh.
Castodia Database Connector customers use this add-on to automate reporting, for example, by creating an auto-refresh schedules that runs on Monday morning at 8am, before arriving to work.
Our product is designed for teams in sales, marketing, operations, and finance who prefer working directly on Google Sheets. Instead of manually exporting data, asking developers for CSV files, or waiting days or weeks to get data, you can now get data quickly and more frequently.
- Schedule data refreshes with options to schedule once, any day or time, down to every 1 minute for all plans.
- Direct SQL querying of your database
- Load complex queries that take longer minutes
- Save and edit queries
- Oracle Database
- Microsoft SQL Server