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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Timothy Harvath
October 8, 2023
Sheeple Peeps
Is this review helpful?
Yes
No
Profile Picture
Taha Zinifi
April 25, 2022
Super buggy, can't authorize my account.
Is this review helpful?
Yes
No
Profile Picture
Paul Flynn
December 3, 2020
Doesn't run against Snowflake and keeps spitting out that the query needs refining, not so useful
Is this review helpful?
Yes
No
Profile Picture
JUAN DAVID VIZCAYA
February 8, 2021
Does not work with MySql
Is this review helpful?
Yes
No
Profile Picture
Vien Hoc
November 18, 2020
thank your connector. It is so useful !!
Is this review helpful?
Yes
No
Profile Picture
cool dude
October 10, 2020
Works greatly with my PostgresQL Database. Love the auto-refreshes so much easier. 👍
Is this review helpful?
Yes
No
Profile Picture
Israel Edwards
December 25, 2020
this is soo cool
Is this review helpful?
Yes
No
Profile Picture
A User of Castodia Data Connector
March 16, 2020
Thought it would have had MySQL integrated already.
Is this review helpful?
Yes
No
Profile Picture
Samson Assefa
December 7, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
1-9 of 9
Search
Clear search
Close search
Google apps
Main menu