How to Connect DuckDB to Google Sheets – Stream Live Analytics Database Data

CONNECTOR GUIDE

DuckDB ➤ Google Sheets

DuckDB

Query Streams

Google Sheets

Fast Analytics

Live Data

Portable

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 DuckDB directly to Google Sheets, streaming live analytics data without Apps Script, ODBC drivers, or file uploads. Sign up for free at QueryStreams.com and start pulling live DuckDB analytics into your spreadsheets in minutes.

This guide shows you how to establish a secure, real-time connection between your DuckDB database file and Google Sheets. Perfect for data analysts, developers, and teams working with high-performance analytical databases – Query Streams makes DuckDB’s blazing-fast queries accessible from anywhere while keeping your database files secure.

What You’ll Accomplish

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

• Connect Google Sheets to DuckDB – Fast analytical database queries
• Query Parquet, CSV, and JSON files directly through DuckDB
• Execute high-performance OLAP queries from Google Sheets
• Share analytical insights without exposing database files

Prerequisites

Step 1: Access the Query Streams Agent Interface

With your agent installed, configure your DuckDB connection.

1. Open your web browser and navigate to: https://localhost:1823
2. Navigate to Data Connections: Click Data Sources > Connections
3. Add a new connection: Click Add Connection

Step 2: Select DuckDB as Your Connection Type

1. Choose DuckDB: Click on the DuckDB tile (green border when selected)
2. Alternative – Use search: Type “DuckDB” to quickly find it
3. Click Next to proceed

Step 3: Configure Your DuckDB Connection Details

Required DuckDB Connection Details:

1. Connection Name – Friendly name (e.g., “Analytics DuckDB”)
2. Database File Path – Full path to your .duckdb file (e.g., C:\Analytics\data.duckdb). Click folder icon to browse.
3. Default Schema (optional) – Leave blank to access all schemas
4. Thread Count (optional) – Uses CPU count if blank
5. Temp Directory (optional) – Custom temp file location

Once completed, click Next.

Step 4: Select Your Data Realm

Select your Data Realm – your query processing capacity.

1. Review available realms: Based on your subscription
2. Select realm: Choose “Default Data Realm”
3. Click Next to test the connection

Step 5: Test Your DuckDB Connection

Query Streams will verify your DuckDB file is accessible.

1. Automatic testing: Agent attempts to open the DuckDB file
2. Review results: Success shows DuckDB version, tables, and schemas
3. Click Next if successful

Step 6: Finish Setup

1. Review configuration: Verify file path is correct
2. Click Finish to save your DuckDB connection

Your DuckDB connection is ready! Next, install the Google Sheets add-on.

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

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

After installation, open Extensions > Query Streams and create your first DuckDB query:

1. Click “Stream a Query”
2. Select your DuckDB connection
3. Write your SQL query:

SELECT 
    customer_id,
    first_name,
    last_name,
    total_spent,
    country
FROM customers
WHERE total_spent > 1000
ORDER BY total_spent DESC
LIMIT 100;

4. Configure destination: Choose “Create a new tab”
5. Click Play to execute

Next Steps: Save and Share Queries

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

• Save queries: Store analytical SQL for reuse
• Add parameters: Create dynamic filters for data exploration
• Share insights: Let stakeholders run queries without file access
• Access from add-on: Saved queries appear in “Saved Queries” menu

Frequently Asked Questions

Related Guides