Importing MySQL Data to Google Sheets – Amigo Data Add-on

Importing MySQL Data to Google Sheets – Amigo Data Add-on
Reading Time: 4 minutes

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 Data 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 importing 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.

  1. Select Data Source
  2. Choose Metrics and Time period
  3. Pull Data

And there you go!

Why choose Amigo Data?

There are various plugins available that can be used to import 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.

Problems faced Vs Solutions Provided while Importing MySQL Data to Google Sheets using Amigo Data Add-on.
Figure 1: Problems faced Vs Solutions Provided while Importing MySQL Data to Google Sheets using Amigo Data

With the help of Amigo Data, importing MySQL Data to Google Sheets will become quite effortless.

How to Import MySQL Data to Google Sheets?

Google Workspace Marketplace Link to Amigo Data 

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. 

Installing Amigo Data Add-on from Google Workspace Marketplace for Importing MySQL Data to Google Sheets
Figure 2: Installing Amigo Data Add-on from Google Workspace Marketplace to import MySQL Data to Google Sheets

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’.

Video 1: Launching and Connecting Amigo Data Add-on for importing MySQL Data to Google Sheets

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’.

Video 2: Importing MySQL Data to Google Sheets using Amigo Data Add-on

Step 5: View Data on Google Sheets

The final result would look like this. You have successfully imported MySQL Data to Google Sheets.

Final View after importing MySQL Data to Google Sheets
Figure 3: Final View of MySQL Data imported 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.

Scheduling Automatic Refresh Dialog Box using Amigo Data Add-on on Google Sheets
Figure 4: Scheduling Automatic Refresh Dialog Box using Amigo Data Add-on on Google Sheets

Importing MySQL Data to Excel

To import MySQL Data to Excel, simply ‘Download‘ in Excel format from Google Sheets.

File > Download > Microsoft Excel(.xlsx)

Importing MySQL Data to Excel using Download option from File Tab
Figure 5: Importing MySQL Data to Excel

Conclusion

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.

Hope this article helped you!

For more information regarding the Add-on, check out the Amigo: No-code Data Integration and Real-Time Metrics.

See Also

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.

One response to “Importing MySQL Data to Google Sheets – Amigo Data Add-on”

Leave a Reply