The ability to connect MariaDB with Google Sheets is essential for analysts. Google Sheets has become an indispensable tool for businesses, providing the flexibility to create reports and analyze data.
However, one of the limitations of Google Sheets is that it does not provide a straightforward way to import data from external databases, such as MariaDB.
Fortunately, Two Minute Reports makes it easy to bridge this gap, allowing users to connect MariaDB with their Google Sheets in a matter of minutes without writing a single line of code. You can easily reduce your time creating reports.
Step 1: Install and Launch Two Minute Reports
This simple add-on for Google Sheets enables you to pull data from a MariaDB database into Google Sheets. Install it from the GSuite marketplace here. Do follow the steps below and experience the full benefits before buying Two Minute reports.
Install Two Minute Reports, if you have not done already.
Sign in to any Google Sheet and go to Add-ons -> Get add-ons.
Search for Two Minute Reports and select Install.
Review and accept the permissions necessary to run Two Minute Reports. Two Minute Reports will be installed for you with the e-mail you are sign in to Google Sheets.
Open Google Sheets and go to Extensions -> Two Minute Reports -> Launch.
Step 2: Connect MariaDB to Google Sheets
Two Minute Reports allows you to Add data from a growing list of different Data Sources. You can add your MariaDB data source by going to the Data Sources section.
Fill-out your database details. Press Test connection once you are ready, your credentials will be validated and saved for future use.
If you get an error message, you might have to check your credentials or configure your MariaDB database to whitelist the IP address of Google Servers or our Amazon Server. The error message will help in taking the appropriate action.
We have also created simple scripts for you to quickly whitelist the required server IP addresses in your MariaDB database. You can find the script here.
After adding your MariaDB Data Source, you can add unlimited number of queries using the same Data Source. Your credentials are securely encrypted and stored within your Google Account. This makes sure your data does not leave the Google Servers and is not readable by anyone except you. Even when you share your Google Spreadsheet with others, they cannot read your credentials.
Step 3: Add SQL Queries to Google Sheets
Once you have added a Data Source, you can access it from any new or old spreadsheet within your Google Account. This makes it easy for you to connect to your MariaDB database and create queries from different spreadsheets without having to re-enter all the credentials.
You can go to the Data Queries section and add your MariaDB query. Start by selecting your newly added Data Source and enter your query in the dark SQL editor. Note that for security reasons we only allow “select” based sql queries to be executed in your MariaDB database.
When ready press “Run query”, and data will be fetched from your database and stored in the specified spreadsheet in Google Sheets.
Once a query is added it gets saved in your spreadsheet. You can then rerun the query or modify it and reuse it easily within the Data Queries section.
Also do note that the queries are securely stored locally in your Google Sheets. And so it can only be accessed from within the Google Sheets that created it. This makes it easier to manage multiple queries properly within different google sheets. This is different from how we store Data Sources, they can be accessed from any spreadsheet within that Google account.
Step 4: (Optional) Schedule Automatic data Refresh and email
Once you have fetched data once, you might want to get new data from your database at periodic intervals. You can do this creating a new schedule under the “Schedule Reports” section. You can schedule updates hourly, daily, weekly or monthly based on your needs.
You could also create a report and ask Two Minute Reports to email that report with updated data automatically. Under the email section enter the email Id of the recipients and save your new schedule.
When the time comes, Two Minute Reports will automatically fetch new data from your queries, and email your report to the said recipients. You have freed a lot of your time from mundane reporting tasks.
There are other features with Two Minute Report’s schedule refresh or data refresh feature. You may read our guide How to Refresh Data Automatically in Google Sheets.
Try Two Minute Reports for Free by installing from the GSuite marketplace, and start pulling data from MariaDB to your Google Sheets.