How to Connect Snowflake to Google Sheets – Stream Live Data Warehouse Analytics

CONNECTOR GUIDE

Snowflake ➤ Google Sheets

Snowflake

Query Streams

Google Sheets

Cloud Native

Live Data

Secure

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 Snowflake Data Warehouse directly to Google Sheets, streaming live cloud data without Apps Script, ODBC drivers, or complex configuration. Sign up for free at QueryStreams.com and start pulling live warehouse data into your spreadsheets in minutes.

This guide shows you how to establish a secure, real-time connection between your Snowflake data warehouse and Google Sheets. Whether you’re analyzing marketing data, building executive dashboards, or sharing analytics with stakeholders worldwide, Query Streams provides a simple solution for accessing your cloud data warehouse.

What You’ll Accomplish

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

• Connect Google Sheets to Snowflake – Cloud data warehouse access
• Execute Snowflake SQL in real-time from Google Sheets
• Build live warehouse dashboards with auto-refreshing data
• Share secure warehouse access with stakeholders globally

Prerequisites

Step 1: Access the Query Streams Agent Interface

With your agent installed, configure your Snowflake 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 Snowflake as Your Connection Type

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

Step 3: Configure Your Snowflake Connection Details

Required Snowflake Connection Details:

1. Connection Name – Friendly name (e.g., “Snowflake Warehouse”)
2. Account Identifier – Your Snowflake account ID (e.g., KOCIDTQ-DK94312)
3. Region (optional) – Region if not in account ID (e.g., us-east-2.aws)
4. Warehouse (optional) – Compute warehouse name
5. Database – Snowflake database name
6. Schema (optional) – Default schema (defaults to PUBLIC)
7. Role (optional) – Snowflake role for this connection
8. Username – Snowflake username
9. Password – Snowflake password

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 Snowflake Connection

Query Streams will verify your Snowflake credentials.

1. Automatic testing: Agent attempts to connect to Snowflake
2. Review results: Success shows Snowflake version, warehouse, and permissions
3. Click Next if successful

Step 6: Finish Setup

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

Your Snowflake 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 Snowflake query:

1. Click “Stream a Query”
2. Select your Snowflake connection
3. Choose database and schema
4. Write your Snowflake SQL:

SELECT 
    customer_id,
    customer_name,
    email,
    total_purchases,
    country
FROM customers
WHERE total_purchases > 1000
ORDER BY total_purchases DESC
LIMIT 100;

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

Next Steps: Save and Share Queries

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

• Save queries: Store warehouse queries for reuse
• Add parameters: Create dynamic filters for data exploration
• Share globally: Let stakeholders run queries from anywhere
• Access from add-on: Saved queries appear in “Saved Queries” menu

Frequently Asked Questions

Related Guides