How to connect a PostgreSQL database to Google Sheets?
Connecting your internal PostgreSQL database with Castodia
In order to run queries, you must set up your database first.
To connect a Postgres database to Google sheets, follow the steps below:
Create a new Google Sheet.
In the toolbar section, click on "Add-Ons" to access the Castodia Database Connector.
You will see two options as you hover over the add-on: launch and settings. Click "Settings."
You will see the Database Setup area, where you will be able to use either a sample or an internal database to test the Castodia add-on.
Gather and enter your database connection information. There are five components needed:
Click the "Test" button to run the database and verify your credentials.
A green notification indicates the add-on was successfully installed. A pink notification indicates that there may be an issue with the installation. If that is the case, please reach out to our support team.
And that's it! Enjoy running your queries.
Note: if you don't have a database setup, you can use one of our sample databases.