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

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

PostgreSQL is a database used to store information. For example, in the case of an E-commerce website, the database will have information related to customers, sales, usage data, and so on.

But then what next? Next, you’ll need to import the data from the database to Google Sheets for further analysis. Now, this step in itself might be quite tiring since you’ll have to copy-paste the data for hours, which may even lead to errors and outdated data.

Well, Amigo Data Google Sheets Add-on is the perfect tool to import PostgreSQL in Google Sheets, and by the end of this article, you’ll have entire information from installing the extension to importing the data from PostgreSQL in Google Sheets.

You can also refer to the following video for the same.

YouTube Video: Importing PostgreSQL Data to Google Sheets

What is Amigo Data Add-on?

With Amigo, you can easily sync data from databases such as PostgreSQL and MySQL to Google Sheets without writing a single line of code or SQL.

The Amigo Data Add-on eases you with the process of generating business reports in no time through a simple three-step process.

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

And you are all set to go!

Why Amigo Data?

Even though there are a number of plugins to import the Postgres Data to Google Sheets, many of them contain several bugs and hence aren’t reliable enough. Hence, we suggest using Amigo Data Add-on.

Problems faced Vs Solutions Provided while Importing PostgreSQL Data to Google Sheets using Amigo Data.
Figure 1: Problems faced Vs Solutions Provided while Importing PostgreSQL Data to Google Sheets using Amigo Data

Importing PostgreSQL in Google Sheets will now become easier than ever with the help of the Amigo Data Add-on. 

How to Import PostgreSQL Data to Google Sheets?

Google Workspace Marketplace Link to Amigo Data 

Step 1: Installing the Amigo Data Add-on from Google Workspace Marketplace

To install the Amigo Data Add-on, open Google Workspace Marketplace, search for ‘Amigo Data’, and click on the ‘Install’ button. 

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

Now, log in to your Google Account and press Next. That’s it! The Amigo Data Add-on has been installed and linked to your account.

Step 2: Go to Extensions and launch Amigo Data Add-on

Next, select the Amigo Data Add-on in Google Sheets from the ‘Extensions’ in the top bar and select ‘Connect‘.

Extensions > Amigo Data > Connect

Step 3: Go to Import Data > PostgreSQL > Login Credentials

Click on PostgreSQL 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 PostgreSQL Data to Google Sheets

Step 4: Select metrics to import > Click on Import

Select a Table from the left column of the dialog box to preview. Now, choose all the metrics you wish to import into the Google Sheets for the given data using the checkboxes. 

For example, we deselected the km_driven, fuel metrics from the Metrics column on the left. 

Finally, click on ‘Import’.

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

Step 5: View Data on Google Sheets

The final result would look something like this. The data from PostgreSQL has been imported into Google Sheets.

Final View of PostgreSQL Data imported to Google Sheets
Figure 3: Final View of PostgreSQL Data imported to Google Sheets

Step 6: Schedule Automatic Refresh (Optional)

You can also schedule automatic hourly, weekly, or custom days of the week refresh on your report to always stay updated.

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

Importing PostgreSQL Data to Excel

This can be easily achieved using the Download Option in Google Sheets.

File > Download > Microsoft Excel(.xlsx)

Figure 5: Importing PostgreSQL Data to Excel

Conclusion

Importing data from PostgreSQL in Google Sheets can be easily executed using the Amigo Data Add-on and you can shift your focus towards analyzing the data imported instead. 

Here is a link for installing the Amigo Data Add-on on Google Workspace Marketplace.

Hope this article helped you!

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