Welcome to the OWOX: Reports, Charts & Pivots (Sheets, BigQuery) extension guide, which helps you set up all features and get analytics-ready data for your reports.
The "OWOX: Reports..." extension is a part of the OWOX BI platform, and you need to install the extension from the official Google Workspace Marketplace.
Core features
This extension allows you to do the following:
- create reports in Google Sheets based on query results in Google BigQuery;
- use dynamic parameters in Queries;
- apply Filters, Limits, and Sorting to fields in the report;
- schedule automatic updates of Google Sheets reports;
- import Google Sheets reports to Google BigQuery;
- automated Pivots & Charts for data visualizations.
Getting started requirements
- You are using the Google Cloud Platform and have an active project (how to set up GCP).
- The data you will work with is stored in Google BigQuery.
- To import data from BigQuery to Google Sheets, you need the following minimum required roles: BigQuery Job User (at the project level) and BigQuery Data Viewer.
- To import data from Google Sheets to BigQuery, you need either the BigQuery Admin or BigQuery Data Owner roles.
- The "OWOX: Reports..." extension is available in your subscription.
Terms of Usage and Report Runs
Read the terms of use in this article with examples.
0 Comments