Introduction
Exporting data from Onboarding.online with filters such as date, country, platform, and userId gives you direct access to:
Google Sheets connected in real time to BigQuery,
automatic updates with no need to import CSV files,
the ability to run custom SQL queries using BigQuery Standard SQL.
This setup enables you to:
build advanced, tailored reports,
analyze detailed user behavior,
track conversions and drop-offs,
create dynamic visualizations inside Google Sheets.
In short: Google Sheets acts as a live front-end for BigQuery.
Your data remains in BigQuery,
Sheets simply queries it and displays the results instantly.
How to connect
Go to "Analytics" section and click "Add" next to Onboarding.online analytics
Once connected you can view all the user events in the "View sessions" section
Initial State and Workflow
When you first connect Google Sheets to BigQuery through Onboarding.online, you will see two tabs in the spreadsheet:
Sheet1
This is your main working sheet.
Contains the processed results from your BigQuery query.
Data starts loading automatically from cell A1.
Designed for reporting and visualization.
You can use this tab to:
build pivot tables,
add charts,
run calculations,
sort and filter without altering the original query.
Connected Sheet 1
This is your data source tab. It includes:
The raw query results,
Connection settings,
A preview of the data coming directly from BigQuery.
⚠️ Important: You don’t edit this sheet manually.
Instead:
All query modifications and data source changes are made here,
Once updated, the results automatically appear in Sheet1.
Summary
Connected Sheets transforms Google Sheets into a live analytics interface powered by BigQuery. Instead of working with static exports, you get real-time access to event data stored in jsonPayload, with the flexibility to build reports and visualizations directly in Sheets.
The workflow is organized into two main tabs:
Sheet1 — the processed dataset you use for charts, pivot tables, and reports,
Connected Sheet 1 — the raw query results and connection settings.
By modifying queries in Connection settings, you can tailor analytics to your needs: track funnels, measure conversions, and analyze screen drop-offs. Filtering by parameters such as userId, eventName, or eventTime ensures precise insights.
This approach eliminates manual CSV handling and provides a clean, dynamic setup for continuous experimentation and decision-making.