Query Stripe, HubSpot & Shopify with SQL.
The API Connector turns REST APIs into queryable tables. Write standard SQL — SELECT, WHERE, JOIN, GROUP BY — against Stripe, HubSpot, Shopify, Google Ads, GA4, ShipStation, Search Console and iTick, and stream the results into Excel or Google Sheets. It handles auth, pagination, rate-limit backoff and caching for you.
Free forever tier · No credit card required
Every API endpoint becomes a SQL table.
No pagination loops, no REST clients, no rate-limit headaches. Each connector maps its endpoints to virtual tables — stripe.subscriptions, hubspot.deals, shopify.orders — so you query them with the exact SQL you already use for databases.
Auth · pagination · retries — handled for you
SELECT id, customer, total
FROM stripe.subscriptions
WHERE status = 'active'
ORDER BY total DESCstripe.subscriptions · hubspot.deals · shopify.orders
API data, now queryable with SQL
SELECT,WHERE,JOIN,GROUP BY— the full dialect- The connector handles auth, pagination & retries
- Join across endpoints — Shopify orders to Stripe payments
8 connectors. One SQL dialect.
Each ships with a library of pre-built queries you can run as-is or customize — roughly 20–50 per connector.
StripePayments & billing
HubSpotCRM & marketing
ShopifyE-commerce
Google AdsAdvertising
Google Analytics 4Web analytics
ShipStationShipping & fulfillment
Search ConsoleSEO & search
iTickMarket dataWrite SQL. Get API data.
A live query against Stripe — the connector authenticates, paginates and returns clean rows.
SELECT plan_name,
COUNT(DISTINCT customer_id) AS subscribers,
SUM(amount) / 100 AS mrr_usd
FROM stripe.subscriptions
WHERE status = 'active'
GROUP BY plan_name
ORDER BY mrr_usd DESC;A connector, not a pipeline
Zapier and Fivetran are built for scheduled warehouse syncs. Query Streams is a lightweight API connector for ad-hoc reporting — run a query when you need it, get fresh data in seconds.
SQL you already know
Every API maps to a familiar schema, so you call it with the same SELECT / JOIN / GROUP BY you use for databases — no proprietary formula language, no REST client, no new tool to learn.
No code. No ETL. No Zapier.
Skip VBA, Apps Script and Power Query. The connector translates your SQL into authenticated API calls automatically — pagination, rate-limit backoff and retries all handled, with no warehouse or sync pipeline to maintain.
Encrypted cache, fewer calls
The API Cache syncs to an encrypted local store (AES-256 at rest) on configurable intervals. Run a hundred reports off the cache without ever hitting a provider rate limit — and keep costs down.
A query library, ready on day one
Install a connector and its pre-built reports come with it — run them as-is, or open them in the Query Builder and tweak.
Stripe- Monthly recurring revenue (MRR)
- Customer lifetime value
- Subscription churn analysis
- Invoice aging report
HubSpot- Deal pipeline summary
- Lead scoring breakdown
- Email campaign metrics
- Sales rep performance
Shopify- Product sales by variant
- Customer cohort analysis
- Inventory level alerts
- Discount code usage
Google Analytics 4- Traffic source breakdown
- Conversion funnel analysis
- User engagement metrics
- E-commerce performance
Set up in three steps
Credentials are added to your Network Agent and never leave it.
Connect your API
Add API credentials to the Query Streams Agent — OAuth or API keys, supported for every connector. They stay encrypted on the Agent.
Browse virtual tables
Each endpoint becomes a queryable table — stripe.customers, hubspot.contacts, shopify.orders — all in one schema.
Write SQL, get data
Standard SELECT statements pull live API data. Run from the portal, the Excel add-in, or the Google Sheets add-on.
Who queries APIs with SQL
SQL skills you already have — data you couldn’t easily reach before.
Finance & accounting
Revenue recognition, payment reconciliation and subscription metrics — straight from Stripe into a sheet.
Marketing teams
Campaign ROI, lead attribution and funnel analysis — combine HubSpot, GA4 and Search Console in one query.
E-commerce ops
Inventory alerts, order fulfillment and customer cohorts — from Shopify and ShipStation, joined and filtered.
Business analysts
Cross-platform reporting without API coding — the data you need, in the spreadsheet you already live in.
See API data in your spreadsheet
Live results from the API Connector, landed as normal cells.
API Connector FAQ
Do I need to know each API’s structure?
No. Query Streams maps each API to a familiar schema — stripe.customers, hubspot.contacts — so you browse tables and columns just like a database. Pagination, authentication and association endpoints are handled for you.
How is API data cached?
The connector syncs API data to an encrypted local cache (AES-256 at rest). Configure sync intervals from real-time to daily based on your needs and the provider’s rate limits — then run unlimited reports against the cache without hitting those limits.
Is it pre-built reports or raw tables?
Both. Every endpoint is a queryable virtual table you can write your own SQL against, and each connector also ships with a library of pre-built queries (roughly 20–50 per connector) — MRR, churn, deal pipeline, top products and more — ready to run or customize.
Can I share API reports without exposing my keys?
Yes. Share a saved query and recipients pull live API data in their own Excel or Google Sheets without ever seeing your API keys or OAuth tokens. Add dynamic filters so each person can adjust date ranges or IDs, and revoke access anytime from the portal.
Which APIs are supported?
Stripe, HubSpot, Shopify, Google Ads, Google Analytics 4, ShipStation, Google Search Console and iTick — with more on the way. The same SQL model works identically across every one.
Query your APIs like a database.
Connect an API, browse the tables, write a SELECT — and get live results in Excel or Google Sheets.
Free forever tier · No credit card required
English 
Spanish 
German 
French 
Portuguese 
Japanese 
Korean 
Chinese 
Italian 
Dutch 
Indonesian 
Polish