How to Connect ShipStation to Google Sheets – Query Shipping Data with SQL

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 transforms your ShipStation shipping data into SQL-queryable tables, letting you import live shipments, labels, carriers, and fulfillment data directly into Google Sheets. No API coding, no manual exports—just write SQL queries and get real-time shipping analytics in your spreadsheet. Sign up free at QueryStreams.com and start querying your ShipStation account in minutes.

What ShipStation Data Can You Access?

Query Streams syncs your ShipStation API data to an AES-256 encrypted local cache, transforming it into SQL-queryable tables. Every table includes a raw_data JSON column with the complete API response—including ship-to/ship-from addresses, package dimensions, and customs information.

Prerequisites

Setup Guide

Step 1: Install the Query Streams Network Agent

1. Log in to my.querystreams.com
2. Navigate to Network Agents in the left sidebar
3. Click Download Agent and run the Windows installer
4. The agent installs as a Windows service and connects automatically
5. Your agent appears as “Online” in the portal within 30 seconds

Step 2: Get Your ShipStation API Key

1. Log in to your ShipStation account
2. Go to Settings → Account → API Settings
3. Click Generate API Keys if you don’t have one yet
4. Copy your API Key — treat it like a password and keep it secure

Step 3: Add the ShipStation Connector

1. Open the Network Agent interface at http://localhost:1823
2. Click Add Connection and select ShipStation
3. Paste your API Key into the API Key field
4. Click Test Connection — Query Streams validates your key
5. On success, you’ll see your ShipStation account confirmation with carrier list
6. Click Next to configure sync schedules and install pre-built queries

Step 4: Configure Your Sync Schedule

All 14 tables sync by default. Disable any table by setting its interval to Never. Click Save — the initial sync starts immediately.

Step 5: Install the Google Sheets Add-on

1. Open Google Sheets in your browser
2. Go to Extensions → Add-ons → Get add-ons
3. Search for “Query Streams”
4. Click Install and grant the required permissions
5. Access it via Extensions → Query Streams → Open
6. Sign in with your Query Streams account credentials
7. Or install directly: Install Query Streams for Google Sheets

Example ShipStation SQL Queries

SELECT
    shipment_status,
    COUNT(*) AS count,
    DATE_TRUNC('day', created_at) AS date
FROM shipstation.shipments
WHERE created_at >= NOW() - INTERVAL '7 days'
GROUP BY shipment_status, date
ORDER BY date DESC, count DESC;

SELECT
    c.carrier_name,
    COUNT(l.label_id) AS label_count,
    SUM(CAST(json_extract_string(l.raw_data, '$.shipment_cost.amount') AS DECIMAL)) AS total_cost,
    AVG(CAST(json_extract_string(l.raw_data, '$.shipment_cost.amount') AS DECIMAL)) AS avg_cost
FROM shipstation.labels l
JOIN shipstation.carriers c ON l.carrier_id = c.carrier_id
WHERE l.created_at >= NOW() - INTERVAL '30 days'
  AND l.status = 'completed'
GROUP BY c.carrier_name
ORDER BY total_cost DESC;

SELECT
    DATE_TRUNC('day', f.created_at) AS date,
    COUNT(DISTINCT f.order_id) AS orders_fulfilled,
    SUM(CASE WHEN f.customer_notified THEN 1 ELSE 0 END) AS customers_notified,
    ROUND(100.0 * SUM(CASE WHEN f.customer_notified THEN 1 ELSE 0 END) / COUNT(*), 1) AS notification_rate_pct
FROM shipstation.fulfillments f
WHERE f.created_at >= NOW() - INTERVAL '14 days'
GROUP BY date
ORDER BY date DESC;

Share Shipping Reports Without Sharing Credentials

Frequently Asked Questions

Related Guides

Category: API Connectors

Tags: ShipStation, Google Sheets, API, Shipping, SQL, Carrier Analytics, Fulfillment, Real-Time Data

Meta Description: Connect ShipStation to Google Sheets with SQL. Query shipments, labels, carriers, and fulfillment data live — no API coding required. Step-by-step setup guide.