PostgreSQL

Google Sheets + PostgreSQL 

Query, Post and Sync Data from PostgreSQL

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho etc. 

It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on. 

What is PostgreSQL?

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.

Setting up PostgreSQL with Sheet Director

Choose the Microsft SQL Server(Premium app) from the list and choose the service which you want to perform

If you're opening it for the first time on the sheet, then you won't be having any connections.

Don't worry Sheet director provides a way to create a connection easily

To create the connection you have to provide the following details.

Test Connection

Once you have provided the credentials you can easily check the connectivity by clicking on the test connection button

Based on the credentials authenticity, you will be having the feedbacks from the test

Once after connecting successfully, you can save the conection and continue.

These connections can be reused anytime and from any services used on the same Google Sheets

Querying on PostgreSQL