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.
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.
- Select Data Source
- Choose Metrics and Time period
- 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.
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?
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.
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’.
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’.
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.
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.
Importing PostgreSQL Data to Excel
This can be easily achieved using the Download Option in Google Sheets.
File > Download > Microsoft Excel(.xlsx)
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.