Castodia lets you connect Google Sheets™ to your data sources and auto-refresh data on a custom schedule, with down to 1 minute auto-refresh frequency.
Listing updated:June 26, 2023
Works with:
50K+
Overview
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
Additional information
PricingFree of charge trial
Privacy policy
Terms of service
Castodia Data Connector will ask for the permissions shown below. Learn more
Castodia Data Connector will need access to your Google account
This will allow Castodia Data Connector to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu