Introduction

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.