Automate BigQuery reporting in Sheets. Connect, query data from sheets & automate it on a schedule. Bypass 50,000 rows and other limitations.
Listing updated:April 11, 2024
Works with:
155K+
Overview
With OWOX BI, you can access BigQuery™ data right from Google Sheets™. So you can make deliver accurate reports with blended data for business decisions, faster.
Get 100% Data Security and Ownership.

🟢 Build reports with Google Sheets™
Connect your BigQuery™ to Google Sheets™ in one click.
Use flexible dynamic filters & aggregations.
Get live charts, pivot tables, and formulas on top of your database.

🟢 Automatically update & share dashboards
Automatically refresh live data into your sheets weekly, daily or hourly.
Share up-to-date reports with your team or stakeholders.
Use pre-built templates or create your own.

🟢 Report on what's important to you
Every business is unique. Your reporting should reflect your business goals and needs.
Setup all your reports in one place and never check and configure them again.

🔹 1-Click Connections
Connect Google Sheets™ to Google BigQuery™ with our one-click connector.

🔹 Create your Own Collection of Queries
Write SQL queries to pull data into sheets (or even upload data back to BigQuery™).
* Save queries for your team.
* Create dynamic parameters for business users.

🔹 Automate Reports in Google Sheets™ and Save Time 
Refresh data in a single click. Or automatically refresh on any schedule.
* Schedule queries to run automatically exactly when you need the report: daily, hourly, weekly, 8am and 4pm every weekday, your schedule - your rules.
* Share any query and let team members refresh data when they need.

🔹Data that Matters
Import only the data you need. Keep your spreadsheets to the point. Filter & limit any dataset.

🔹2-Way Sync
Automatically bulk upload data from Sheets™ into your BigQuery™ with 2-way sync.

🔹Instant Notifications
Track the signals you care about. Trigger email notifications to notify you when a data is updated (or isn’t).

🔹Access Management
Connect your BigQuery™ to Google Sheets™ just once. Share data marts without sharing BigQuery™.

🔹Enterprise SLA
OWOX BI guarantees uptime percentage to customer.

🔹 No limitations
OWOX BI is designed to avoid limiting you.
* Unlimited reports,
* Unlimited import file size,
* Unlimited rows,
* Unlimited seats.

🔹 Build diagrams & charts
Build custom dashboards, pivots & charts, share data while enjoying the benefits of Google Sheets™.

In addition, feel free to visit our help center for tutorials, guides, and FAQs at https://www.owox.com/c/FAQs
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
OWOX BI BigQuery Reports will ask for the permissions shown below. Learn more
OWOX BI BigQuery Reports will need access to your Google account
This will allow OWOX BI BigQuery Reports to :
See, edit, create, and delete all of your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
View and manage your data in Google BigQuery and see the email address for your Google Account
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu