Show HN: Airboxr – Query Builder for Google Sheets

Hi everyone! Shubh, Saps and Mehmet here from Airboxr (https://airboxr.com/). We've built a Google Sheets add-on that lets you import and lookup data from external data sources without having to leave your spreadsheet.

We found most spreadsheet users (74% in our survey of over 900 users) are frustrated with all the data collection and cleaning they need to do before they can analyze data. Data today is distributed across various marketing, sales, financial, and operational sources. While power users can write scripts to collect and clean data, most business users end up applying a long series of copy-pastes and CSV imports to get their data ready for analysis. The process of importing data from multiple sources into a spreadsheet is complicated and unintuitive.

Airboxr is an interactive query builder inside your Google Sheets that enables you to import and lookup data across various sources. Much like SQL querying, it lets you filter and summarize data as you see fit, without requiring any SQL know-how.

In our current public-beta version, you can connect to any google sheet and start importing data as per your needs. The only requirement right now is that the google sheet you connect should have tabular data with headers in the first row.

Here's a quick no-frills demo (https://airboxr.com/demo) that you can play around with. If you're looking for a marketing specific use case, try this demo instead (https://www.airboxr.com/demo-marketing).

Thanks for reading - we'd love to get your thoughts, feedback, and ideas!

Your marketing demo had a facebook ads source but when I installed the add-on, I couldn't find a way to connect my own facebook ads account anywhere. How can I do this?