The Power Query Equivalent
Google Sheets Never Had
Microsoft Excel has Power Query. Google Sheets doesn’t – until now. Query Streams gives you live, on-demand SQL data with interactive filters, secure sharing, and no network changes.
Ask Nova, get SQL + charts
Meet Nova
One key per partner. No credentials shared.
Build an API
+more
Scheduled sync to 6+ platforms
Explore
+more
Query APIs with SQL, no code
Explore
+more
Claude, Cursor, ChatGPT & Grok talk to your data
Connect AIMicrosoft Excel has Power Query. Google Sheets doesn’t. Until now, getting reliable, filterable, and live database data into a Google spreadsheet meant cobbling together Apps Script, IMPORT statements, CSV uploads, or third-party tools with slow, scheduled refreshes. Query Streams changes that by giving you the missing piece: a secure, on-demand SQL connector with a polished Google Sheets add-on.
Does Google Sheets Have Power Query?
No. Google Sheets has no built-in Power Query feature. Its native QUERY() function only reshapes data that is already in the spreadsheet — it cannot connect to an external database. The closest Power Query equivalent for Google Sheets is Query Streams, a free add-on that pulls live data from SQL Server, PostgreSQL, MySQL, MariaDB, and more, with interactive filters and secure sharing.
What Google Sheets is Missing
No Native SQL Connector
Teams resort to Apps Script, IMPORTDATA, IMPORTXML, or manual CSV uploads to get database data into Sheets.
Stale Data
Most connectors rely on hourly or daily scheduled refreshes. You’re always working with yesterday’s numbers.
Sharing Friction
Exposing database credentials or shipping copies of data creates security risks and version confusion.
No Governance
Hard to keep queries read-only, auditable, and centrally managed. SQL code gets copy-pasted everywhere.
How Query Streams Fills the Gap
Live, On-Demand Data
Run queries instantly when you need them. No stale snapshots, no hourly polls – just fresh data on demand.
Real-TimeInteractive Filters
Query Streams auto-detects WHERE conditions and turns them into dropdowns, multi-selects, and date pickers.
No SQL EditsZero Network Changes
The Agent creates secure, outbound-only connections. No ports to open, no VPNs, no reverse proxies.
Outbound OnlyShare Capability, Not Code
Teammates run queries from their own Sheets without ever seeing SQL, credentials, or your database schema.
Secure SharingLive Data Flow to Google Sheets
How Query Streams Connects Your Databases to Sheets
Secure, real-time data streaming with no credentials exposed
Supported Databases
SQL Server
PostgreSQL
MySQL
MariaDB
SQLite
MS Access
BigQuery
Oracle
Snowflake
DuckDB
Plus cloud platforms: AWS RDS, Azure SQL Database, Google Cloud SQL. Deploy Agents anywhere – all databases appear in one unified dropdown.
API to SQL: Web Services Too
Beyond databases, Query Streams connects to popular APIs using SQL syntax:
Google Analytics
Search Console
HubSpot
Shopify
Stripe
ShipStation
Get Started in 3 Steps
Setting up Query Streams as your Power Query for Google Sheets takes just a few minutes:
- Install the Agent: Download the Query Streams Agent to any machine on your network. It connects to your databases using outbound-only, encrypted communication — no ports to open, no VPN required. Supports Windows, macOS, and Linux.
- Build and Save Queries: Use the visual Query Builder at my.querystreams.com to write SQL against SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, Microsoft Access, BigQuery, Oracle, Snowflake, DuckDB, or any supported database. Save queries and configure interactive filters — end users adjust parameters without ever seeing SQL code.
- Run from Google Sheets: Install the free Query Streams Google Sheets add-on, select your saved query, set any filters, and click Run. Data streams directly into your spreadsheet, on demand. Share queries with teammates or external partners by email — they never see your SQL, credentials, or schema.
No complex configuration, no Apps Script, no IMPORTDATA formulas. Your team runs live SQL queries from Google Sheets with full interactive filters and read-only security.
Query Streams vs Scheduled-Refresh Add-ons
| Feature | Scheduled Add-ons | Query Streams |
|---|---|---|
| Data Freshness | Hourly/daily snapshots | Live on-demand – always fresh |
| User Filters | Edit SQL or none | Auto-detected dropdowns, dates |
| Credential Security | Stored in sheet/script | Never leaves the Agent |
| External Sharing | Share credentials or data copies | Share by email – no credentials |
| Network Setup | Open ports or VPN | Outbound-only, zero config |
| Query Execution | Sequential, one at a time | Parallel – 5+ simultaneous |
| Data Transfer | Full uncompressed payloads | 65-95% adaptive compression |
| SQL Visibility | Anyone can see/copy SQL | SQL hidden from end users |
Why IMPORTDATA and Apps Script Fall Short
Google Sheets users often try IMPORTDATA, IMPORTXML, or IMPORTRANGE functions to pull external data. These built-in functions work for simple public data feeds, but they were never designed for database connectivity:
- IMPORTDATA only reads CSV/TSV from public URLs — it cannot connect to MySQL, PostgreSQL, SQL Server, or any private database behind a firewall
- No authentication layer — IMPORTDATA has no concept of database credentials, OAuth, or API keys for private data sources
- No interactive filters — you cannot parameterize an IMPORTDATA call with dynamic WHERE conditions or user-selectable dropdown filters
- Rate-limited and unreliable — Google aggressively throttles IMPORT* functions, causing
#N/Aerrors during peak usage - Apps Script JDBC requires coding — Google’s built-in JDBC connector demands JavaScript programming, exposes credentials in scripts, has execution time limits (6 minutes), and offers no UI for end users
- No sharing or governance — there is no way to share a parameterized query with a colleague without giving them access to the underlying SQL and credentials
Query Streams solves all of these limitations. It provides a dedicated Google Sheets add-on with a polished interface, connects securely to 10+ databases through an outbound-only Agent, and delivers interactive filters that non-technical users can operate without writing a single line of code. If you’ve been looking for an IMPORTDATA alternative that supports real databases, Query Streams is it.
Common Use Cases
Sales & RevOps
Stream pipeline and bookings by region with filters for dates, owners, and stages.
Operations
Pull inventory and fulfillment status for partners in shared Google Sheets.
Finance
Provide auditors and FP&A teams read-only access to specific SQL queries.
Education
Give students safe, real databases to query directly from Sheets – no credentials.
Frequently Asked Questions
Does Query Streams replace Power Query in Google Sheets?
Google Sheets doesn’t have a native Power Query. Query Streams delivers the missing capabilities – live SQL connectivity, interactive filters, secure sharing, and a first-class add-on experience. It’s everything Power Query does for Excel, built natively for Sheets.
Can I schedule automatic refreshes?
Query Streams is designed for on-demand, live runs so your data is always fresh when you need it. Many teams find this eliminates the need for schedules entirely. If you need automation, you can trigger runs from Google Apps Script or external automation tools.
Is my data secure?
Yes. The Query Streams Agent makes an outbound-only, encrypted connection from your network. Your database stays private behind your firewall. Users never see connection strings, credentials, or SQL code. All queries are read-only by design.
Which databases are supported?
Microsoft SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, Microsoft Access, BigQuery, Oracle, Snowflake, and DuckDB. Works across on-premise servers and cloud platforms like AWS RDS, Azure SQL Database, and Google Cloud SQL.
Can I share queries with external partners?
Absolutely. Enter anyone’s email in the Query Streams portal to grant access. They install the free Google Sheets add-on and can run your shared queries from anywhere. They never see your SQL, credentials, or schema. You can revoke access instantly with one click.
How do interactive filters work?
Query Streams analyzes your SQL and detects WHERE conditions. It automatically turns static values into dropdowns, multi-selects, or date pickers. You enable filters in the query’s Properties tab – no SQL edits required. End users adjust filters without seeing the underlying query.
What’s the difference from Apps Script JDBC?
Apps Script JDBC requires coding, exposes credentials in scripts, has strict quotas and timeouts, and offers no built-in filters or sharing. Query Streams handles all connectivity securely through Agents, provides a polished UI, supports interactive filters, and lets you share without exposing code or credentials.
How is Query Streams different from IMPORTDATA?
IMPORTDATA only reads CSV/TSV data from publicly accessible URLs. It cannot connect to private databases like MySQL, PostgreSQL, SQL Server, or SQLite behind your firewall. Query Streams connects securely to 10+ database types through an installed Agent, supports interactive filters, and delivers live, on-demand SQL results directly into Google Sheets — all without exposing credentials or requiring public URLs.
Does Query Streams work with Microsoft Excel too?
Yes. Query Streams offers both a Google Sheets add-on and a Microsoft Excel add-in. The same saved queries, filters, and sharing rules work across both platforms. Many organizations use Query Streams to serve live database data to teams split across Excel and Google Sheets.
How much does Query Streams cost?
Query Streams offers a free tier to get started with one Agent and core features. Paid plans add multiple Agents, automation integrations, team sharing, and priority support. Visit querystreams.com/pricing for current plan details.
Give Google Sheets Real Power Query Superpowers
Install the Query Streams add-on, connect your database, and run live SQL with interactive filters – no credentials shared.
Meta Description: Power Query for Google Sheets alternative – use Query Streams to connect live SQL data with interactive filters directly into Google Sheets. No credentials shared, no network changes.
Category: Product Guides
Tags: Google Sheets, Power Query Alternative, Live Data, SQL Connector, Secure Data Sharing, Interactive Filters
Author Bio:
The Query Streams Team comprises seasoned database experts, network security professionals, and enterprise networking veterans with over 25 years of combined experience in data management, analytics, and secure software development.
English 
Spanish 
German 
French 
Portuguese 
Japanese 
Korean 
Chinese 
Italian 
Dutch 
Indonesian 
Polish