MySQL

 + Google Sheets

Auto-refresh data from MySQL to Google Sheets

Connect MySQL Database to Google Sheets

Castodia automatically imports fresh data from your MySQL Database to your Google Sheets on a highly customizable schedule. Auto-refresh data as often as every 1 minute for near real-time data.

How to Connect MySQL Database to Google Sheets

Castodia lets you pull data from your MySQL database directly into Google Sheets.

To connect your MySQL database, follow the steps below:

Step 1: Open the Castodia Admin Dashboard
Step 2:
From the Databases Menu, click on Create
Step 3:
Add a nickname for your database connection
Step 4:
From the dropdown menu, select MySQL
Step 5:
Gather and enter your database connection information. Note that you must whitelist our IP (54.177.198.56) if your database isn't open. Contact your IT team for help with this.

  • Host
  • Username
  • Password
  • Database
  • Port

Step 6: Click the "Test" button to verify your credentials
Step 7:
Click the "Save" button once a green notification pops up, indicating that the add-on was successfully installed.

And that's it! Enjoy running your queries.

Join 46,000+ users on Google Workspace Marketplace

Automate your reports in Google Sheets

Start automating your reports and analysis with Castodia today.
Start free trial