Shopify Data to Excel & Google Sheets

Skip to content

Home
Features
Connectors
Pricing
Support
- Contact
- Docs

Get Started

Home
Features
Connectors
Pricing
Support
- Contact
- Docs

Setup

6

Is the Agent Online? What Offline Means and How to Fix It
How to Install the Query Streams Agent on Windows
How to Install the Query Streams Agent on Linux
How to Install the Query Streams Agent on macOS
Query Streams Access Level Permissions: Complete User Role Management Guide
How to Install the Query Streams Google Sheets Addon

Nova AI

8

Nova Concierge Mode: A Personal Data Analyst for Every User
Nova Taught Knowledge: How Verified Learning Works
How Nova AI Learns Your Database Schema Automatically
AI Data Analytics: Query Any Database Without a BI Tool
BI and Data Analytics Without Tableau or Power BI
Text to SQL: How Nova AI Turns Questions Into Database Queries
AI Powered Analytics: Ask Questions, Get SQL + Charts
Natural Language to SQL: How Nova AI Turns Questions Into Database Queries

API to SQL Connector Setup

14

How to Connect iTick to Google Sheets — Live Stocks, Crypto, and Forex Data
How to Connect iTick to Microsoft Excel — Live Stocks, Crypto, and Forex Data
How to Connect Google Analytics to Google Sheets – Query Web Analytics with SQL
How to Connect Google Analytics to Excel – Query Web Analytics with SQL
How to Connect Google Search Console to Google Sheets – Query SEO Data with SQL
How to Connect Google Search Console to Excel – Query SEO Data with SQL
How to Connect HubSpot to Google Sheets – Query CRM Data with SQL
How to Connect HubSpot to Excel – Query CRM Data with SQL
How to Connect ShipStation to Excel – Query Shipping Data with SQL
How to Connect ShipStation to Google Sheets – Query Shipping Data with SQL
How to Connect Shopify to Google Sheets – Query E-Commerce Data with SQL
How to Connect Shopify to Excel – Query E-Commerce Data with SQL
How to Connect Stripe to Google Sheets – Query Payment Data with SQL
How to Connect Stripe to Excel – Query Payment Data with SQL

Data Connector Setup

26

Set up the PostgreSQL connector
Set Up the Microsoft SQL Server Connector: Server Name, SQL Express, Logins and Cloud
Open a Firewall Port on Windows for SQL Server, PostgreSQL, MySQL or Oracle
Create a read-only database user for the Agent
Where the Agent Can Read Files From: Drive Letters, Shares, Cloud Folders, Mac and Linux
Set Up the Microsoft Access Connector: Database Engine and File Path
How to Connect BigQuery to Google Sheets – Stream Live Data Warehouse Analytics
How to Connect Oracle to Google Sheets – Stream Live Enterprise Database Data
How to Connect Oracle to Excel – Stream Live Enterprise Database Data
How to Connect BigQuery to Excel – Stream Live Data Warehouse Analytics
How to Connect DuckDB to Google Sheets – Stream Live Analytics Database Data
How to Connect DuckDB to Excel – Stream Live Analytics Database Data
How to Connect Snowflake to Excel – Stream Live Data Warehouse Analytics
How to Connect Snowflake to Google Sheets – Stream Live Data Warehouse Analytics
How to Connect Microsoft Access to Excel – Stream Live Database Data
How to Connect Microsoft Access to Google Sheets – Stream Live Database Data
How to Connect MariaDB to Google Sheets – Stream Live Database Data
How to Connect MariaDB to Excel – Stream Live Database Data
How to Connect MySQL to Google Sheets – Stream Live Database Data
How to Connect MySQL to Excel – Stream Live Database Data
How to Connect SQLite to Google Sheets – Stream Live Lightweight Database Data
How to Connect SQLite to Excel – Stream Live Lightweight Database Data
How to Connect PostgreSQL to Google Sheets – Stream Live Database Data
How to Connect PostgreSQL to Excel – Stream Live Database Data
How to Connect Microsoft SQL Server to Google Sheets – Stream Live Database Data
How to Connect Microsoft SQL Server to Excel – Stream Live Database Data

Articles

51

Airtable Automation — Sync Live Database and API Data Automatically
Real-Time Analytics: Live Database Queries and Streaming Data in Spreadsheets
Excel Automation: Automate Live Database Reports Without Macros or VBA
ETL Tools Alternative: Skip the Pipeline, Query Your Database Live
Data Visualization Tools: Create Charts & Dashboards from Live SQL Queries
Data Integration Platform: Connect Any Database to Excel, Sheets & More
Database Analytics: Query, Analyze & Visualize Your Data Without a BI Platform
Data Democratization: Give Every Team Member Access to Database Insights
Data Analytics Platform: SQL-Powered Analytics for Every Database
Business Intelligence Software: Lightweight BI for Teams That Don’t Need Tableau
BI Tools for Spreadsheet Users: Real Analytics Without Leaving Excel or Google Sheets
Smartsheet Database Automation — Sync Live SQL Data Without Zapier
ODBC Alternative for Google Sheets
SeekWell Alternative — SQL to Spreadsheets Without Slack
SQL Server Reporting Without SSRS: Live Reports in Excel and Google Sheets
Oracle Reporting: Live Oracle Data in Excel and Google Sheets
Mixed Analytics Alternative for Google Sheets
Microsoft Access Reports: Build Better Reports from Your Access Database
Flatly Alternative for Google Sheets — Live SQL Without CSV Exports
Database Reporting Tool: SQL Reports Without a BI Platform
Database Automation: Schedule SQL Reports to Excel, Sheets and Airtable
Database Dashboard: Build Live SQL Dashboards in Excel and Google Sheets
Data Query in Excel: Pull Live Database Results into Any Spreadsheet
Connect REST APIs to Excel Without VBA or Power Query
Conversational BI: Query Any Database in Plain English
Airtable Reporting: Sync Live Database Results to Airtable
Connect Cloud Databases to Excel and Google Sheets (AWS RDS, Azure SQL, Google Cloud SQL)
Apipheny Alternative — API to Sheets Without Limits
Build No-Code Database Apps with Live SQL Data
Query Streams vs Coupler.io: Which Data Connector Is Right for You?
Skyvia Alternative 2026: Live Database Queries Without ETL
Google Sheets Reporting: Automate Live Database Reports
How to Import Any Database into Excel
Database vs Spreadsheet: When to Use Each and How to Connect Them
How to Run SQL Queries in Excel
SQL Reporting: Build Live Database Reports Without a BI Tool
Google Sheets Database 2026: Connect Any SQL Database to Sheets
Data Analytics to Increase Sales: Live CRM and Database Reporting in Sheets and Excel
Database Automation for IT Teams and DBAs: Secure Self-Service Data Access
BI Tools for Small Business: Analytics in Excel and Sheets Without Expensive Software
Financial Data Analytics: Live Database Queries in Excel and Google Sheets
SQL for Data Analysts: Live Database Queries in Excel and Google Sheets
Coefficient for Google Sheets: A Smarter Alternative for Database Users
ODBC Driver for Excel: Why You Don’t Need One Anymore
Supermetrics Alternative: SQL Databases + APIs in One Platform
Power BI Alternative: Live SQL in Excel & Google Sheets
Share ERP Data with External Partners Without System Access
Run SQL in Google Sheets Without Apps Script JDBC
SQL Global Database Access Without Drivers or Gateways
Microsoft Excel Power Query Alternative
Power Query for Google Sheets

Airtable Automation

16

Sync Google Search Console to Airtable on a Schedule
Sync Google Analytics 4 to Airtable on a Schedule
Sync ShipStation to Airtable on a Schedule
Sync HubSpot to Airtable on a Schedule
Sync Shopify to Airtable on a Schedule
Sync Stripe to Airtable on a Schedule
Sync Microsoft SQL Server to Airtable on a Schedule
Sync PostgreSQL to Airtable on a Schedule
Sync DuckDB to Airtable on a Schedule
Sync Google BigQuery to Airtable on a Schedule
Sync Snowflake to Airtable on a Schedule
Sync Oracle to Airtable on a Schedule
Sync Microsoft Access to Airtable on a Schedule
Sync SQLite to Airtable on a Schedule
Sync MariaDB to Airtable on a Schedule
Sync MySQL to Airtable on a Schedule

Anvil.works automation

16

Sync Google Search Console to Anvil.works on a Schedule
Sync Google Analytics 4 to Anvil.works on a Schedule
Sync ShipStation to Anvil.works on a Schedule
Sync HubSpot to Anvil.works on a Schedule
Sync Shopify to Anvil.works on a Schedule
Sync Stripe to Anvil.works on a Schedule
Sync Microsoft SQL Server to Anvil.works on a Schedule
Sync PostgreSQL to Anvil.works on a Schedule
Sync DuckDB to Anvil.works on a Schedule
Sync Google BigQuery to Anvil.works on a Schedule
Sync Snowflake to Anvil.works on a Schedule
Sync Oracle to Anvil.works on a Schedule
Sync Microsoft Access to Anvil.works on a Schedule
Sync SQLite to Anvil.works on a Schedule
Sync MariaDB to Anvil.works on a Schedule
Sync MySQL to Anvil.works on a Schedule

Baserow Automation

16

Sync Google Search Console to Baserow on a Schedule
Sync Google Analytics 4 to Baserow on a Schedule
Sync ShipStation to Baserow on a Schedule
Sync HubSpot to Baserow on a Schedule
Sync Shopify to Baserow on a Schedule
Sync Stripe to Baserow on a Schedule
Sync Microsoft SQL Server to Baserow on a Schedule
Sync PostgreSQL to Baserow on a Schedule
Sync DuckDB to Baserow on a Schedule
Sync Google BigQuery to Baserow on a Schedule
Sync Snowflake to Baserow on a Schedule
Sync Oracle to Baserow on a Schedule
Sync Microsoft Access to Baserow on a Schedule
Sync SQLite to Baserow on a Schedule
Sync MariaDB to Baserow on a Schedule
Sync MySQL to Baserow on a Schedule

Query Streams docs category icon for Google Sheets automation, showing a cell grid with scheduled refresh arcs and the Google Sheets mark

Google sheet Automation

16

Sync Google Search Console to Google Sheets on a Schedule
Sync Google Analytics 4 to Google Sheets on a Schedule
Sync ShipStation to Google Sheets on a Schedule
Sync HubSpot to Google Sheets on a Schedule
Sync Shopify to Google Sheets on a Schedule
Sync Stripe to Google Sheets on a Schedule
Sync Microsoft SQL Server to Google Sheets on a Schedule
Sync PostgreSQL to Google Sheets on a Schedule
Sync DuckDB to Google Sheets on a Schedule
Sync Google BigQuery to Google Sheets on a Schedule
Sync Snowflake to Google Sheets on a Schedule
Sync Oracle to Google Sheets on a Schedule
Sync Microsoft Access to Google Sheets on a Schedule
Sync SQLite to Google Sheets on a Schedule
Sync MariaDB to Google Sheets on a Schedule
Sync MySQL to Google Sheets on a Schedule

SeaTable Automation

16

Sync Google Search Console to SeaTable on a Schedule
Sync Google Analytics 4 to SeaTable on a Schedule
Sync ShipStation to SeaTable on a Schedule
Sync HubSpot to SeaTable on a Schedule
Sync Shopify to SeaTable on a Schedule
Sync Stripe to SeaTable on a Schedule
Sync Microsoft SQL Server to SeaTable on a Schedule
Sync PostgreSQL to SeaTable on a Schedule
Sync DuckDB to SeaTable on a Schedule
Sync Google BigQuery to SeaTable on a Schedule
Sync Snowflake to SeaTable on a Schedule
Sync Oracle to SeaTable on a Schedule
Sync Microsoft Access to SeaTable on a Schedule
Sync SQLite to SeaTable on a Schedule
Sync MariaDB to SeaTable on a Schedule
Sync MySQL to SeaTable on a Schedule

Smartsheet Automation

16

Sync Microsoft SQL Server to Smartsheet on a Schedule
Sync Google Search Console to Smartsheet on a Schedule
Sync Google Analytics 4 to Smartsheet on a Schedule
Sync ShipStation to Smartsheet on a Schedule
Sync HubSpot to Smartsheet on a Schedule
Sync Shopify to Smartsheet on a Schedule
Sync Stripe to Smartsheet on a Schedule
Sync DuckDB to Smartsheet on a Schedule
Sync Google BigQuery to Smartsheet on a Schedule
Sync Snowflake to Smartsheet on a Schedule
Sync Oracle to Smartsheet on a Schedule
Sync Microsoft Access to Smartsheet on a Schedule
Sync SQLite to Smartsheet on a Schedule
Sync MariaDB to Smartsheet on a Schedule
Sync MySQL to Smartsheet on a Schedule
Sync PostgreSQL to Smartsheet on a Schedule

Data

2

Share Live Data, Not Credentials
WordPress MySQL server using Query Streams, hosted on Siteground

MCP Server

60

Connect Nile to Claude with MCP
Connect Koyeb to Claude with MCP
Connect Prisma Postgres to Claude with MCP
Connect PlanetScale Postgres to Claude with MCP
Connect Timescale Cloud to Claude with MCP
Connect Xata to Claude with MCP
Connect MariaDB SkySQL to Claude with MCP
Connect IBM Cloud Databases for PostgreSQL to Claude with MCP
Connect MySQL HeatWave to Claude with MCP
Connect OCI Database with PostgreSQL to Claude with MCP
Connect Scaleway Managed Databases to Claude with MCP
Connect OVHcloud Managed Databases to Claude with MCP
Connect Vultr Managed Databases to Claude with MCP
Connect Fly.io Postgres to Claude with MCP
Connect Railway to Claude with MCP
Connect Render to Claude with MCP
Connect Heroku Postgres to Claude with MCP
Connect Crunchy Bridge to Claude with MCP
Connect Aiven to Claude with MCP
Connect DigitalOcean Managed Databases to Claude with MCP
Connect Google AlloyDB to Claude with MCP
Connect Google Cloud SQL to Claude with MCP
Connect Azure SQL to Claude with MCP
Connect Azure Database for MySQL to Claude with MCP
Connect Azure Database for PostgreSQL to Claude with MCP
Connect Amazon RDS to Claude with MCP
Connect Neon to Claude with MCP
Connect Any Log File to Claude with MCP
Connect Syslog and journald Logs to Claude with MCP
Connect JSON Application Logs to Claude with MCP
Connect Docker Container Logs to Claude with MCP
Connect Nginx, Apache and IIS Logs to Claude with MCP
Connect CNC and Machine Logs to Claude with MCP
Connect Multi-Record CSV Files to Claude with MCP
Connect a Folder of JSONL Files to Claude with MCP
Connect a Folder of SQLite Databases to Claude with MCP
Connect a Folder of Excel Files to Claude with MCP
Connect a Folder of Parquet Files to Claude with MCP
Connect a Folder of CSV Files to Claude with MCP
Connect Your File System to Claude with MCP
Connect iTick to Claude with MCP
Connect ShipStation to Claude with MCP
Connect Supabase to Claude with MCP
Connect Query Streams to Claude via MCP: Setup, Permissions and Troubleshooting
Connect Stripe to Claude with MCP
Connect Shopify to Claude with MCP
Connect Snowflake to Claude with MCP
Connect HubSpot to Claude with MCP
Connect DuckDB to Claude with MCP
Connect Google BigQuery to Claude with MCP
Connect MySQL to Claude with MCP
Connect Microsoft SQL Server to Claude with MCP
Connect Google Analytics 4 to Claude with MCP
Connect Microsoft Access to Claude with MCP
Connect Oracle to Claude with MCP
Connect Google Ads to Claude with MCP
Connect SQLite to Claude with MCP
Connect MariaDB to Claude with MCP
Connect PostgreSQL to Claude with MCP
Connect Google Search Console to Claude with MCP

Query Streams docs category icon for Security and Trust, showing a shield with a verification check and a secure outbound connection

Security & Trust

1

How Query Streams Keeps Your Data Secure

File Set Connectors

14

Custom Log Analysis with SQL: Parse Any Text Log
Query Linux Syslog Files with SQL
Query Application Logs with SQL (JSON and Text)
Query Docker Container Logs with SQL
Query nginx, Apache and IIS Logs with SQL
CNC Machine Monitoring with SQL from Controller Log Files
Index a File System and Query It with SQL
Query Multi-Record CSV Files with SQL
Query a Folder of Parquet Files with SQL
Combine Multiple SQLite Database Files Into One Table
Turn a Folder of JSON Files Into SQL Tables
Merge Multiple Excel Files Into One Table
Combine Multiple CSV Files Into One Table
How to Query a Folder of Files with SQL

Filter Parameters

1

Query Streams SQL Filters and Parameters Overview

Query Streams docs category icon for the REST API platform, showing an endpoint plate with an access key and ribbons fanning out

Database REST API

61

MySQL HeatWave REST API: Turn a SQL Query into an Endpoint
OCI Database with PostgreSQL REST API: Turn a SQL Query into an Endpoint
iTick Data REST API: Turn a SQL Query into an Endpoint
Scaleway Managed Databases REST API: Turn a SQL Query into an Endpoint
ShipStation Data REST API: Turn a SQL Query into an Endpoint
OVHcloud Managed Databases REST API: Turn a SQL Query into an Endpoint
Supabase REST API for Custom SQL Queries
Vultr Managed Databases REST API: Turn a SQL Query into an Endpoint
Custom Logs REST API: Turn a SQL Query into an Endpoint
Fly.io Postgres REST API: Turn a SQL Query into an Endpoint
System Logs REST API: Turn a SQL Query into an Endpoint
Railway REST API: Turn a SQL Query into an Endpoint
Application Logs REST API: Turn a SQL Query into an Endpoint
Render REST API: Turn a SQL Query into an Endpoint
Container Logs REST API: Turn a SQL Query into an Endpoint
Heroku Postgres REST API: Turn a SQL Query into an Endpoint
Web Server Logs REST API: Turn a SQL Query into an Endpoint
Crunchy Bridge REST API: Turn a SQL Query into an Endpoint
Machine Logs REST API: Turn a SQL Query into an Endpoint
Aiven REST API: Turn a SQL Query into an Endpoint
Multi-record CSV REST API: Turn a SQL Query into an Endpoint
DigitalOcean Managed Databases REST API: Turn a SQL Query into an Endpoint
JSONL Folder REST API: Turn a SQL Query into an Endpoint
Google AlloyDB REST API: Turn a SQL Query into an Endpoint
SQLite Folder REST API: Turn a SQL Query into an Endpoint
Google Cloud SQL REST API: Turn a SQL Query into an Endpoint
Excel REST API: Turn a SQL Query over Excel Files into an Endpoint
Azure SQL REST API: Turn a SQL Query into an Endpoint
Parquet Folder REST API: Turn a SQL Query into an Endpoint
CSV to REST API: Turn a SQL Query over CSV Files into an Endpoint
Azure Database for MySQL REST API: Turn a SQL Query into an Endpoint
File System REST API: Turn a SQL Query into an Endpoint
Azure Database for PostgreSQL REST API: Turn a SQL Query into an Endpoint
Nile REST API: Turn a SQL Query into an Endpoint
Amazon RDS REST API: RDS Data API Alternative for Any Engine
Koyeb REST API: Turn a SQL Query into an Endpoint
Neon REST API: Turn a SQL Query into an Endpoint
Prisma Postgres REST API: Turn a SQL Query into an Endpoint
Google Search Console Data REST API: Turn a SQL Query into an Endpoint
PlanetScale Postgres REST API: Turn a SQL Query into an Endpoint
Google Analytics 4 Data REST API: Turn a SQL Query into an Endpoint
Timescale Cloud REST API: Turn a SQL Query into an Endpoint
Google Ads Data REST API: Turn a SQL Query into an Endpoint
Xata REST API: Turn a SQL Query into an Endpoint
HubSpot Data REST API: Turn a SQL Query into an Endpoint
MariaDB SkySQL REST API: Turn a SQL Query into an Endpoint
IBM Cloud Databases for PostgreSQL REST API: Turn a SQL Query into an Endpoint
Shopify Data REST API: Turn a SQL Query into an Endpoint
Power BI REST API: Connect Live SQL Data Without ODBC Drivers
Stripe Data REST API: Turn a SQL Query into an Endpoint
MariaDB REST API: Turn a SQL Query into an Endpoint
Google BigQuery REST API: Turn a SQL Query into an Endpoint
MySQL REST API: Turn a SQL Query into an Endpoint
Microsoft SQL Server REST API: Turn a SQL Query into an Endpoint
Oracle REST API Without ORDS: Turn a SQL Query into an Endpoint
Snowflake REST API: An Alternative to the Snowflake SQL API
Microsoft Access REST API: Turn a SQL Query into an Endpoint
SQLite REST API: Turn a SQL Query into an Endpoint
DuckDB REST API: Turn a SQL Query into an Endpoint
PostgreSQL REST API: PostgREST Alternative for SQL Queries
Database REST API: Turn Any SQL Query into an Endpoint

View Categories

Home
Docs
shopify

shopify

Sync Shopify to Smartsheet on a Schedule
Sync Shopify to Google Sheets on a Schedule
Sync Shopify to Airtable on a Schedule
Sync Shopify to Anvil.works on a Schedule
Sync Shopify to Baserow on a Schedule
Sync Shopify to SeaTable on a Schedule
Supermetrics Alternative: SQL Databases + APIs in One Platform
Data Analytics to Increase Sales: Live CRM and Database Reporting in Sheets and Excel
Connect Shopify to Claude with MCP