MySQL is an open-source database used to store, handle, and edit data. But what if you wish to import the MySQL Data to Google Sheets in less time? Importing MySQL to Google Sheets can be exhausting when done manually and you may end up losing a lot of time with plenty of inaccuracies.
This is where we provide you with the best alternative – Amigo Data Add-on, which will not only help you save time but also keep you updated with your data.
This article focuses on how to import MySQL Data to Google Sheets using the Amigo Data Add-on and, by the end of this tutorial, you’ll have everything you need to know about installing Amigo Data Add-on and importing MySQL data into Google Sheets.
What is Amigo Data Add-on?
Using Amigo Data, you can effortlessly sync data from databases such as MySQL and Postgres to Google Sheets without writing a single line of code or SQL.
Through a simple three-step process, the Amigo Data Add-on makes it super easy to generate business reports.
- Select Data Source
- Choose Metrics and Time period
- Pull Data
And there you go!
Why choose Amigo Data?
There are various plugins available that can be used to connect the MySQL Data to Google Sheets but you may face multiple issues with them and may seem unreliable. Therefore, we recommend using Amigo Data Add-on.
With the help of Amigo Data, importing MySQL Data to Google Sheets will become quite effortless.
How to Import MySQL Data to Google Sheets?
Step 1: Install the Amigo Data Add-on from Google Workspace Marketplace
The Amigo Data Add-on can be installed by simply opening Google Workspace Marketplace, searching for ‘Amigo Data’, and clicking on the ‘Install’ button.
Now, all you need to do is login your Google Account and click on ‘Next’. That’s it! Done!
The Amigo Data Add-on has been installed and linked to your account.
Step 2: Extensions Tab > Launch Amigo Data Add-on
Next, you need to select the Amigo Data Add-on in Google Sheets from the ‘Extensions’ tab and click on ‘Connect’.
Extensions > Amigo Data > Connect
Step 3: Go to Import Data > MySQL > Login Credentials
Click on MySQL and then ‘Import from Tables’. Enter your Login Credentials in the given fields and then click on ‘Connect’.
Step 4: Select Metrics > Import
Select a Table from the list on the left column to preview. Next, select all the metrics you want to be imported into Google Sheets using the checkboxes.
For example, we selected ‘ID’, ‘Name’, and ‘Age’ to be imported into Google Sheets.
Finally, click on ‘Import’.
Step 5: View Data on Google Sheets
The final result would look like this. You have successfully imported MySQL Data to Google Sheets.
Step 6: Schedule Automatic Refresh (Optional)
You can also schedule automatic refresh on hourly, weekly, or custom days of the week basis to stay updated.
Importing MySQL Data to Excel
To import MySQL Data to Excel, simply ‘Download‘ in Excel format from Google Sheets.
File > Download > Microsoft Excel(.xlsx)
The Amigo Data Add-on makes it simple to import MySQL Data to Google Sheets, allowing you to concentrate on analyzing the data instead.
You can install the Amigo Data Add-on on Google Workspace Marketplace from here. And connect mysql to google sheets very easily.
Hope this article helped you!
For more information regarding the Add-on, check out the Amigo: No-code Data Integration and Real-Time Metrics.
Want to know more about importing data from various databases to Google Sheets? Look at our definitive guide on Google Sheets which covers hundreds of topics here. Enjoy reading!
Importing PostgreSQL Data to Google Sheets: Learn how to import PostgreSQL Data to Google Sheets in three simple steps using Amigo Data Add-on.