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.
Connection name - Provide a nice name for the connection you're creating
Provide the configuration details which are mandatory
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