Skip to main content

Log in with the PostgreSQL Connector

You can use Awesome Table Connectors to export data from PostgreSQL to Google Sheets by logging in with the PostgreSQL connector.

Prerequisites

  1. In the Awesome Table add-on Home screen, click Create new request.


    The list of available connectors is displayed.

  2. Open the PostgreSQL connector.

    The PostgreSQL connector is listed in the Databases category of the add-on

  3. On the Connect to PostgreSQL screen, enter the following credentials:

    PostgreSQL credentials are entered into their respective fields, which are: Host, Port (Optional), Database name, Username, and Password.

  4. (Optional) If your database is protected by network security, you must add Awesome Table's static IP address (34.133.53.19) to your whitelist.

    1. Connect to your PostgreSQL server using the client of your choice.
    2. Log in as a user with administrative privileges.
    3. Open the pg_hba.conf file, which is typically located in the PostgreSQL data directory.
    4. In the pg_hba.conf file, add a new line that allows access to the database from the IP address you want to whitelist. The format of the line should be:
      host    database_name    user_name    34.133.53.19/32    auth_type
      Where:
      • "database_name" is the name of the database you want to grant access to
      • "user_name" is the name of the user you want to grant access to
      • "auth_type" is the authentication method you want to use
    5. Save the pg_hba.conf file and restart the PostgreSQL server to apply the changes.

  5. Click Test & Save.

You are now logged in with the PostgreSQL connector. The Select data drop-down shows the data you can export to Google Sheets.
The list of options to export from PostgreSQL connector
What’s next
You can now use Awesome Table Connectors to export data from PostgreSQL to Google Sheets.