Import data, Save, Share & Re-Use Queries, Filter, Limit & Sort automatically, then Schedule Refreshes. Use AI-SQL Copilot to craft queries faster. Bypass rows limits.
Listing updated:July 17, 2024
Works with:
156K+
Overview
With OWOX BI, you can access, visualize & share BigQuery™ data right from spreadsheets. Deliver actionable reports with joined data for business decisions, faster. 100% Safe & Secure.

📊 Build reports with Google Sheets™
Connect your BigQuery™ to Google Sheets™ in one click.
Create your collection of SQL Queries, share it with your team, and re-use.
Apply automatically generated FILTERs, SORT & LIMIT your reports before you retrieve them into sheets. 
Get live charts, pivot tables, and formulas on top of your database.


🕐 Schedule refreshes & share reports
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 OWOX AI-SQL Copilot for BigQuery to generate reliable SQL Queries faster: 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.


➡️Get trusted reports with your context in less than 1 minute:
Step #1: Add a SQL query yourself, or hire an AI SQL Copilot, to craft actionable report faster. Save & run just once.
Step #2: Share queries with spreadsheet users. 
Step #3: Business users can run reports, apply dynamic filters, sort & limit data.
Step #4: Set up flexible schedules to receive fresh data as often as needed.
Finally, everybody can access fresh & reliable data. Forever.
You don’t need to check or manually update 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 Collection of Queries
Write SQL queries to pull data into sheets:
Save queries and share them with your team;
Business users then run reports without asking a data professional.
🔄 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 file size,
* Unlimited rows and columns,
* Unlimited seats.


In addition, feel free to visit our help center for tutorials, guides, and FAQs at https://www.owox.com/c/FAQs


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.
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
Victoria Prokopets
July 10, 2024
I frequently use this extension for my small reports and have never encountered any issues or problems. I upload data to BigQuery and regularly refresh reports on a schedule. It is very easy to use and well-maintained, and the help center articles cover all the necessary features. I highly recommend it.
Is this review helpful?
Yes
No
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
Yevheniia Hryshchenko
July 5, 2024
Easy to manage some ad-hoc reports, built on the data, that is stored in BQ. Really helpful. I wish there was the same extension for excel.
Is this review helpful?
Yes
No
Profile Picture
Andrey Benke
July 10, 2024
Very good extension
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
1-10 of 24
Search
Clear search
Close search
Google apps
Main menu