How to Connect Microsoft SQL Server to Google Sheets – Stream Live Database Data

CONNECTOR GUIDE

SQL Server ➤ Google Sheets

SQL Server

Query Streams

Google Sheets

No VPN Required

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 Microsoft SQL Server databases directly to Google Sheets, streaming live data without VPNs, firewall changes, or complex configuration. Sign up for free at QueryStreams.com and start pulling live enterprise database data into your spreadsheets in minutes.

This guide shows you how to establish a secure, real-time connection between your Microsoft SQL Server database and Google Sheets. Whether you’re running on-premise SQL Server, Azure SQL Database, AWS RDS, 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 SQL Server – On-premise, Azure, AWS RDS, or Google Cloud SQL
• Execute T-SQL 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 SQL Server 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 Microsoft SQL Server as Your Connection Type

After clicking “Add Connection,” you’ll see the New Connection wizard.

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

Step 3: Configure Your SQL Server Connection Details

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

Required Connection Details:

1. Connection Name (required) – A friendly name like “Production SQL Server” or “Azure SQL DB”
2. Server (required) – Hostname or IP address. Examples: 192.168.1.100, myserver.database.windows.net, localhost
3. Port (required) – Default is 1433. Change only if using a custom port.
4. Database (required) – Specific database name (e.g., Northwind, AdventureWorks)
5. Username (required) – SQL Server login or Windows authentication account
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 your 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 SQL Server is accessible with the credentials provided.

1. Automatic testing: The agent attempts to connect to your SQL Server
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 SQL Server connection

Your SQL Server connection is now ready! Next, 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 T-SQL query:

1. Click “Stream a Query”
2. Select your SQL Server connection from the Data Source dropdown
3. Choose the database from the Database dropdown
4. Write your T-SQL query:

SELECT TOP 100
    CustomerID,
    CompanyName,
    ContactName,
    City,
    Country
FROM Customers
ORDER BY CompanyName;

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 T-SQL queries:

• Save queries: Store frequently used T-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