Connect Google Sheets™ to your databases, data warehouses, CRMs, APIs, SaaS, and web applications such as Airtable, Hubspot, Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, Shopify, Snowflake, and Stripe.

Castodia is easy to use. 3 simple steps:

1. Connect data source.
2. Create query. Create, test, and save queries using SQL or UI query builder. 
3. Schedule query. Schedule your query to automatically import data to Google Sheets™ on any custom schedule. Even as often as every 1 minute. 

With Castodia there’s no more manual CSV data exports that don’t auto-refresh. Castodia customers use our Data Connector for Google Sheets™ to increase productivity when analyzing business data, automating business reports, or sharing up-to-date data with operations and fields teams, for example, by creating an auto-refresh schedules that runs Mon-Fri, between 9am and 5pm, every 1 minutes, or every Monday morning at 8am, before the day starts.

Our product is designed for teams in sales, marketing, operations, external partners, and finance who prefer working directly on Google Sheets™. Instead of manually exporting data from the source, asking developers for CSV files, or waiting days or weeks to get data, you can now get data quickly and more frequently, whenever you need it.


FEATURES
- Schedule data refreshes with options to schedule once, any day or time, down to every 1 minute for all plans.
- Direct SQL querying for databases and data warehouses
- Select tables, objects from your API/SaaS integrations and add filters
- Load complex queries that take minutes
- Save and edit queries
- Highly customizable calendar-like scheduling for queries. Our scheduler allows you to set up repeat schedules such as every day, specific days of the week/month/year, time ranges, and different repeat intervals such as every 1/5/10/20/30 minutes, or at different hourly intervals.
- Workspaces for teams, with Owner, Admin, Billing, and Editor permissions
- Enable and disable schedules
- Create multiple auto-refresh schedules per sheet
- Timezone support
- User friendly scheduler builder


CURRENT INTEGRATIONS

Databases
- MariaDB
- Microsoft SQL Server
- MySQL
- Oracle Database
- PostgreSQL

Data warehouses
- Redshift
- Snowflake


BETA INTEGRATIONS

SaaS and APIs
- Airtable
- Hubspot
- Shopify
- Stripe