Automate BigQuery reporting in Sheets. Connect, query data from sheets & automate it on a schedule. Bypass 50,000 rows and other limitations.
Listing updated:March 26, 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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Ievgen Krasovytskyi
February 15, 2024
Really love it. Day to day. Every day.
Is this review helpful?
Yes
No
Profile Picture
Andrew
September 9, 2023
I love this add-on so mush because it does my work easier and fast 🔥
Is this review helpful?
Yes
No
Profile Picture
تیم امنیتی شبکه های اجتماعی SM-SECURITY-TEAM-AF
January 18, 2024
ilove the google services
Is this review helpful?
Yes
No
Profile Picture
John Hicks
August 25, 2021
Good plugin, does exactly what I needed and does it well. Thanks OWOX for leaving this be free and also maintaining it.
Is this review helpful?
Yes
No
Profile Picture
IT Admin
November 11, 2020
We use this tool all the time and find it really good. We moved a report that had schedules in it to a Team drive and looks like we can no longer access the Schedule as it says "Null is the owner". Can this be fixed or is it recommended not to have active sheets with this add on in a shared drive?
Is this review helpful?
Yes
No
Profile Picture
A User of OWOX BI BigQuery Reports
October 17, 2016
I liked this. It would be great if you can make the query editer larger. It's too small for daily use.. **Update** Developer reacted my review quickly and my concern is fixed. Great team, thanks!
Is this review helpful?
Yes
No
Profile Picture
A User of OWOX BI BigQuery Reports
September 1, 2017
perfect for me... now i'm exploring data with bigquery + google spreadsheet + owox bi tools:) it's awesome experience among all! the gimmick user can define parameter field is good idea! it will help us a lot.
Is this review helpful?
Yes
No
Profile Picture
A User of OWOX BI BigQuery Reports
April 30, 2018
Love this. Is so so handy. Thanks OWOX for leaving this be free and also maintaining it so well.
Is this review helpful?
Yes
No
Profile Picture
A User of OWOX BI BigQuery Reports
May 15, 2019
Great Add-on, wondering if it would be possible to improve the scheduler so I could run a report multiple times a day at set times.
Is this review helpful?
Yes
No
Profile Picture
Felmart Reyes -
August 12, 2020
good
Is this review helpful?
Yes
No
1-10 of 17
Search
Clear search
Close search
Google apps
Main menu