How to Connect Stripe to Google Sheets – Query Payment 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 connects your Stripe account to Google Sheets as SQL-queryable tables—customers, invoices, subscriptions, charges, and more, all accessible with standard SQL. No API programming, no manual exports, no CSV juggling. Just write SQL and get live Stripe data in your spreadsheet. Sign up free at QueryStreams.com and start querying your Stripe account in minutes.

What Stripe Data Can You Access?

Query Streams syncs your Stripe API data to an AES-256 encrypted local cache, transforming it into 15 SQL-queryable tables. Every table includes a raw_data JSON column with the complete Stripe API response—including all metadata fields.

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 Stripe Secret API Key

1. Log in to your Stripe Dashboard
2. Click Developers in the top navigation
3. Select API keys from the left sidebar
4. Copy your Secret key (starts with sk_live_ for production or sk_test_ for testing)
5. Keep this key secure — it provides full read access to your Stripe data

Step 3: Add the Stripe Connector

1. Open the Network Agent interface at http://localhost:1823
2. Click Add Connection and select Stripe
3. Paste your Secret API Key into the API Key field
4. Click Test Connection — Query Streams validates your key with Stripe
5. On success, you’ll see confirmation of your account mode (Live or Test)
6. Click Next to proceed to sync configuration

Step 4: Configure Your Sync Schedule

All 15 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 Stripe SQL Queries

SELECT
    DATE_TRUNC('month', created) AS month,
    COUNT(*) AS charge_count,
    SUM(amount) / 100.0 AS gross_revenue,
    SUM(CASE WHEN refunded THEN amount_refunded ELSE 0 END) / 100.0 AS refunds,
    (SUM(amount) - SUM(CASE WHEN refunded THEN amount_refunded ELSE 0 END)) / 100.0 AS net_revenue
FROM stripe.charges
WHERE status = 'succeeded'
  AND created >= CURRENT_DATE - INTERVAL '12 months'
GROUP BY DATE_TRUNC('month', created)
ORDER BY month DESC;

SELECT
    p.name AS product_name,
    pr.nickname AS plan_name,
    pr.interval AS billing_interval,
    pr.unit_amount / 100.0 AS price,
    COUNT(s.id) AS active_subscribers,
    COUNT(s.id) * pr.unit_amount / 100.0 AS mrr_contribution
FROM stripe.subscriptions s
JOIN stripe.subscription_items si ON si.subscription = s.id
JOIN stripe.prices pr ON pr.id = si.price
JOIN stripe.products p ON p.id = pr.product
WHERE s.status = 'active'
GROUP BY p.name, pr.nickname, pr.interval, pr.unit_amount
ORDER BY mrr_contribution DESC;

SELECT
    DATE(created) AS date,
    failure_code,
    failure_message,
    COUNT(*) AS failure_count,
    SUM(amount) / 100.0 AS lost_revenue
FROM stripe.charges
WHERE status = 'failed'
  AND created >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY DATE(created), failure_code, failure_message
ORDER BY date DESC, failure_count DESC;

Share Stripe Reports Without Sharing Credentials

Frequently Asked Questions

Related Guides

Category: API Connectors

Tags: Stripe, Google Sheets, API, Payment Data, SQL, Revenue Analytics, Subscriptions, Real-Time Data

Meta Description: Connect Stripe to Google Sheets with SQL. Query customers, invoices, subscriptions, and charges live — no API coding required. Step-by-step setup guide.