How to Connect Google Analytics to Google Sheets – Query Web Analytics 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 Google Analytics 4 data into SQL-queryable tables, letting you import live traffic, engagement, and e-commerce metrics directly into Google Sheets. No API coding, no manual exports—just write SQL queries and get GA4 analytics in your spreadsheet. Sign up free at QueryStreams.com and start querying your GA4 data in minutes.

What Google Analytics 4 Data Can You Access?

Query Streams syncs your GA4 data to an AES-256 encrypted local cache, transforming it into SQL-queryable tables. Note that GA4 data is typically 24–48 hours delayed by Google’s processing pipeline.

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: Create a Google Cloud Service Account

1. Go to the Google Cloud Console and create or select a project
2. Navigate to APIs & Services → Library → enable Google Analytics Data API and Google Analytics Admin API
3. Go to IAM & Admin → Service Accounts → Create Service Account
4. Name it (e.g., “query-streams-ga4”) and click Create and Continue
5. Skip the optional role assignment → click Done
6. Click on the service account → Keys tab → Add Key → Create new key → JSON
7. The JSON key file downloads automatically — save it securely

Grant Access in GA4

1. Go to Google Analytics and select your GA4 property
2. Click Admin → Property Access Management
3. Click + → Add users
4. Paste the client_email from your JSON key
5. Select the Viewer role → click Add

Step 3: Add the Google Analytics 4 Connector

1. Open the Network Agent interface at http://localhost:1823
2. Click Add Connection and select Google Analytics 4
3. Paste the contents of your Service Account JSON key (or upload the file)
4. Select your GA4 Property from the dropdown
5. Click Next to configure sync schedules and install pre-built queries

Step 4: Configure Your Sync Schedule

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 Google Analytics 4 SQL Queries

SELECT
    DATE_TRUNC('week', date) AS week,
    SUM(sessions) AS sessions,
    SUM(total_users) AS users,
    SUM(new_users) AS new_users,
    ROUND(AVG(bounce_rate) * 100, 1) AS avg_bounce_rate_pct
FROM ga4.traffic_overview
WHERE date >= CURRENT_DATE - INTERVAL '90 days'
GROUP BY DATE_TRUNC('week', date)
ORDER BY week DESC;

SELECT
    session_default_channel_group AS channel,
    SUM(sessions) AS sessions,
    SUM(total_users) AS users,
    SUM(conversions) AS conversions,
    ROUND(AVG(engagement_rate) * 100, 1) AS engagement_rate_pct
FROM ga4.traffic_sources
WHERE date >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY channel
ORDER BY sessions DESC
LIMIT 10;

SELECT
    event_name,
    SUM(event_count) AS total_events,
    SUM(total_users) AS unique_users,
    ROUND(AVG(event_count_per_user), 2) AS events_per_user
FROM ga4.events
WHERE is_conversion = true
  AND date >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY event_name
ORDER BY total_events DESC;

Share GA4 Reports Without Sharing Credentials

Frequently Asked Questions

Related Guides

Category: API Connectors

Tags: Google Analytics, GA4, Google Sheets, API, Web Analytics, SQL, Traffic, Conversions

Meta Description: Connect Google Analytics 4 to Google Sheets with SQL. Query traffic, engagement, and e-commerce data — no API coding required. Step-by-step setup guide.