Automate BigQuery reporting in Sheets. Query data from sheets & schedule refreshes. Bypass 50,000 rows limitation. Use AI-SQL Copilot to craft queries faster.
Listing updated:June 17, 2024
Works with:
156K+
Overview
With OWOX BI, you can access BigQuery™ data right from Google Sheets™. Deliver actionable reports with joined data for business decisions, faster. 100% Secure.

Use advanced OWOX SQL Copilot for BigQuery to generate reliable SQL Queries faster: https://owox.com/c/gpt

📊 Build reports with Google Sheets™
Connect your BigQuery™ to Google Sheets™ in one click.
Create your collection of SQL Queries and share it with your team.
Use flexible dynamic filters & aggregations.
Get live charts, pivot tables, and formulas on top of your database.

🕐 Schedule refreshes & share dashboards
Automatically deliver live data to your sheets exactly when you need them.
Daily, weekly, hourly, twice a day, your schedule - your rules.
Share up-to-date reports with your team or stakeholders.

🤖 Hire AI and streamline your query generation
Use our SQL Copilot for BigQuery in ChatGPT to generate reliable queries: https://owox.com/c/gpt
Share your tables, find JOIN keys, visualize relationships, get your query built for you, and even test before your run.

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

🔗 1-Click Connections
Connect Google Sheets™ to Google BigQuery™ by just selecting your GCP project.

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

💾 Create your Own Collection of Queries
Write SQL queries to pull data into sheets:
* Save queries and share with 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, 8 am and 4 pm every weekday, your schedule - your rules.
* Share any query and let team members refresh data when they need it.

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

👫 Access Management
Share reports and data marts without sharing BigQuery™ access.

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

🟢 OWOX BI is designed to avoid any limitations
* Unlimited reports,
* Unlimited import file size,
* Unlimited rows,
* Unlimited seats.

It’s the easiest to use and the most comprehensive alternative to Connected Sheets, MythicalReports, Awesome Table, SyncWith, Two Minute Reports, Database Browser, Supermetrics, Funnel, Coupler, SheetGo, Coefficient, Dataslayer.It’s the easiest to use and the most comprehensive alternative to Connected Sheets, MythicalReports, Awesome Table, SyncWith, Two Minute Reports, Database Browser, Supermetrics, Funnel, Coupler, SheetGo, Coefficient, Dataslayer.

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
Olena Serdiuk
June 12, 2024
This plugin is fantastic to automate the refreshing of reports in Sheets. Initially, I used it for ad-hoc reports, but now I also use it for regular reports because they are super easy to debug, understand, and share with others. Currently it doesn't support other data warehouses, but we've managed to use other Google Sheets as a source in some cases, which works fine. The extension is continually evolving with many new features being added. I also had to contact their support once, and it was an amazing experience. ❤️
Is this review helpful?
Yes
No
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
A User of OWOX BI BigQuery Reports
August 3, 2021
An employee who has since left used this plugin to set-up a scheduled report. Their emails are getting forwarded to me. There's no way to stop this scheduled report - even after installing the addon and having full permissions to the sheet in question- obviously the login of the individual doesn't work anymore. It doesn't seem the developers have considered this scenario. I'm basically deleting OWOX emails every single day now with no way to stop them.
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
1-10 of 20
Search
Clear search
Close search
Google apps
Main menu