Import BigQuery™ data, Save, Share & Re-use SQL Data Marts. Filter & Sort. Automatically Generate Charts. Schedule refreshes. AI-Copilot. No row limits.
Listing updated:November 27, 2024
Works with:
165K+
Overview
With OWOX Reports, you can query BigQuery™ data right from spreadsheets, 
Create a library of data marts (queries), and share those data marts with team members so they can run reports, schedule refreshes, filter & sort data, & generate pivots & charts automatically. 
Deliver trusted data marts with joined data for reports and stunning visuals for business decisions, faster. 100% Safe & Secure.

📊Get trusted reports with your context in less than 1 minute:
1️⃣ Add SQL query. Save Data Mart.
2️⃣ Share Data Marts with business users (They don’t need GCP access to run)
⏭️[Skip this step if you are alone… But better - bring your business team in, it’s a collaborative reporting tool 😉]
3️⃣ Business users can run reports, apply filters, and sort data without editing your SQL query.
4️⃣ Create full reports with a single click - Automatically generate Pivots & Charts in Google Sheets™!
5️⃣ Set up flexible schedules to receive fresh data as often as needed.
✅Finally, everybody can access fresh, visually appealing & reliable data. Forever.

➡️ Build reports with Google Sheets™
Connect your BigQuery™ to Google Sheets™ in one click.
Create your corporate collection of Shared SQL Queries - Data Marts, share across your team with or without BigQuery Access, then - re-use.
Apply pre-generated FILTERs, SORT & LIMIT your data before you retrieve them. 
Automatically get live pivot tables & charts generated for you and 🔄updated automatically.

🕐 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.
You don’t need to check or manually update reports (and visualizations) ever again.

🤖Hire AI to streamline your SQL generation (or editing)
Use OWOX AI-SQL Copilot for BigQuery to generate reliable SQL Queries faster: https://owox.com/c/gpt.
Share table IDs, find JOIN keys, get your query built for you (or edited), and even test before your run.

📊Your Data to Dashboards in just 1 Click
Get automatically generated pivots & charts that update when new data arrives. You don’t need to spend time detecting and visualizing key data points anymore. OWOX BI will handle that with one click.

🔗 1-Click Connections
Connect Google Sheets™ to Google BigQuery™ by just selecting your GCP project.
🔄2-Way Sync
Automatically upload data from Sheets™ into your BigQuery™ with 2-way sync.
💾 Create Your Collection of Data Marts
Write SQL queries to pull data into sheets,
Save queries into a library,
Share with team members 
Or Delete when you don’t need that anymore.
👫Access Management
Share data marts permissions without sharing BigQuery™ access.
The data team will get access automatically,
Plus, you can share it with business users Indirectly so they run reports without asking a data professional to act like a CSV-extracting machine
🔄 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).
🟢OWOX BI is designed to avoid any limitations
* Unlimited sharable data marts,
* Unlimited reports,
* Unlimited file size,
* Unlimited rows and columns,
* Unlimited charts.


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. Plus you get automated charts & pivots built for you in a single click.
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
OWOX: Reports, Charts & Pivots (Sheets, BigQuery) will ask for the permissions shown below. Learn more
OWOX: Reports, Charts & Pivots (Sheets, BigQuery) will need access to your Google account
This will allow OWOX: Reports, Charts & Pivots (Sheets, BigQuery) 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
Yaroslav Samovar
August 27, 2024
This plugin has been a game-changer for our business. We were struggling with manually updating reports and managing large datasets across various platforms. This extension allowed us to connect Google Sheets directly to BigQuery, making it incredibly easy to create and share SQL queries without any hassle. The automatic generation of pivot tables and charts saved us so much time, and the scheduling feature ensures our reports are always up-to-date without any manual intervention. This tool has truly simplified our reporting process, enabling our team to make faster, data-driven decisions. Highly recommended for anyone dealing with complex data!
Is this review helpful?
Yes
No
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
Test Testovich
November 5, 2024
OWOX Reports has simplified my workflow by letting me query BigQuery data directly in spreadsheets. I can easily share data marts with my team, automate updates, and create visuals—all in one place. It saves time and ensures that everyone has access to accurate data for faster decision-making.
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
Ruslan Obolonsky
September 27, 2024
finally, I've found an add-on simple enough to get data from BigQuery for my reports in sheets. Also, I've seen a few cool updates in the last months. Kudos to the team. Keep going
Is this review helpful?
Yes
No
Profile Picture
Anna Shostak
July 17, 2024
A very convenient extension for creating reports, especially the ability to configure a schedule. Now I can work with ready data, knowing that it has already been updated. I also like the new filters, they have made it even more usability. Regular updates to the extension also seems useful
Is this review helpful?
Yes
No
Profile Picture
Victoria Ruban
July 22, 2024
We've created our reports in Sheets and automated its regular scheduled updating using this tool. Great service for reducing manual work, thanks.
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
Anastasiia Zhartovska
September 12, 2024
An excellent solution for streamlining my reporting process. The scheduling feature is a game-changer—it ensures I’m always working with the latest data. The interface has become even more user-friendly with the addition of new filters. I’m also impressed by how regularly new features and updates are rolled out, always adding value and improving efficiency.
Is this review helpful?
Yes
No
Profile Picture
Maryna Khurudzhi
August 21, 2024
Great tool to work with different reports in Sheets, really useful for my tasks.
Is this review helpful?
Yes
No
1-10 of 30
Search
Clear search
Close search
Google apps
Main menu