How to Connect PostgreSQL to Google Sheets – Stream Live Database Data

CONNECTOR GUIDE

PostgreSQL ➤ Google Sheets

PostgreSQL

Query Streams

Google Sheets

No VPN Required

Live Data

Open Source

See everything Query Streams can do beyond this guide Get Started Free

Supports

+more

Live Data

Replace exports with on-demand SQL

Excel Sheets

BI & AI Analytics

Ask Nova, get SQL + charts

Meet Nova

Database REST API

One key per partner. No credentials shared.

Build an API

+more

Automation

Scheduled sync to 6+ platforms

Explore

+more

API to SQL

Query APIs with SQL, no code

Explore

+more

AI Database MCP

Claude, Cursor, ChatGPT & Grok talk to your data

Connect AI

Query Streams enables you to connect PostgreSQL databases directly to Google Sheets, streaming live data without VPNs, firewall changes, or complex ODBC configuration. Sign up for free at QueryStreams.com and start pulling live Postgres data into your spreadsheets in minutes.

This guide shows you how to establish a secure, real-time connection between your PostgreSQL database and Google Sheets. Whether you’re running on-premise Postgres, AWS RDS for PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL, Query Streams provides a simple solution for building live dashboards, automating reporting, and securely sharing database queries with teams worldwide.

What You’ll Accomplish

By the end of this guide, you’ll be able to:

• Connect Google Sheets to PostgreSQL – On-premise, AWS RDS, Azure, or Google Cloud SQL
• Execute PostgreSQL queries in real-time from Google Sheets
• Build live dashboards and reports with auto-refreshing data
• Share secure database access with colleagues globally

Prerequisites

Step 1: Access the Query Streams Agent Interface

With your agent installed and running, configure your PostgreSQL connection through the local agent interface.

1. Open your web browser and navigate to the agent interface: https://localhost:1823
2. Navigate to Data Connections: Click Data Sources in the sidebar, then select Connections
3. Add a new connection: Click the Add Connection button

Step 2: Select PostgreSQL as Your Connection Type

1. Choose PostgreSQL: Click on the PostgreSQL tile (it will highlight with a green border when selected)
2. Alternative – Use search: Type “PostgreSQL” in the search bar to quickly find it
3. Proceed to next step: Once selected, click Next

Step 3: Configure Your PostgreSQL Connection Details

You’re now on Step 2: Configure Connection where you’ll enter your PostgreSQL credentials.

Required Connection Details:

1. Connection Name (required) – A friendly name like “Production PostgreSQL” or “AWS RDS Postgres”
2. Server (required) – Hostname or IP address. Examples: 192.168.1.100, mydb.us-east-1.rds.amazonaws.com, localhost
3. Port (required) – Default is 5432. Change only if using a custom port.
4. Database (required) – Specific database name (e.g., myapp, analytics)
5. Username (required) – PostgreSQL database user
6. Password (required) – Database password (click eye icon to toggle visibility)
7. Connection Timeout – Default 30 seconds. Increase for slower networks.

Once all fields are completed, click Next to proceed.

Step 4: Select Your Data Realm

A Data Realm determines your query processing capacity – how much data can flow through your queries, measured in MB/GB based on your subscription.

1. Review available realms: You’ll see options based on your subscription tier
2. Select realm: Choose “Default Data Realm” for most use cases
3. Click Next to test the connection

Step 5: Test Your Database Connection

Query Streams will verify your PostgreSQL is accessible with the credentials provided.

1. Automatic testing: The agent attempts to connect to your PostgreSQL
2. Review results: Success shows server version, database name, and connection details
3. Click Next if successful

Step 6: Finish Setup

1. Review configuration: Verify all settings are correct
2. Click Finish to save your PostgreSQL connection

Your PostgreSQL connection is now ready! Next, you’ll install the Google Sheets add-on to start querying.

Step 7: Install Add-On and Run Your First Query

Install the Query Streams add-on from Google Workspace Marketplace:

After installation, open the add-on from Extensions > Query Streams and create your first PostgreSQL query:

1. Click “Stream a Query” to begin creating a new query
2. Select your PostgreSQL connection from the Data Source dropdown
3. Choose the database from the Database dropdown
4. Write your PostgreSQL query in the editor

SELECT 
    customer_id,
    first_name,
    last_name,
    email,
    country
FROM customers
WHERE country = 'USA'
ORDER BY last_name
LIMIT 100;

5. Configure destination: Choose “Create a new tab” for your first query
6. Click the Play button to execute the query

Next Steps: Save and Share Queries

Use the Query Streams web portal to build, save, and manage your PostgreSQL queries:

• Save queries: Store frequently used SQL for easy reuse
• Add parameters: Create dynamic filters users can adjust without seeing SQL
• Share globally: Let colleagues run queries from anywhere in the world
• Access from add-on: Saved queries appear in the “Saved Queries” menu

Frequently Asked Questions

Related Guides