Airboxr - No-code querying and data-enrichment interface for GSheets. | Product Hunt

Google Sheets


The Definitive Guide to Conditional Formatting on Google Sheets.

Definitive Guide to Conditional Formatting on Google Sheets.

There's a lot of fun stuff you can do to make your GSheet tables look better.Last week, my colleague Sona Maharjan talked about how to merge cells and data to make your tables look cool. Conditional formatting is another easy way to format your data for easy reading. In this …

Continue reading

Merging cells and data in Google Sheets

Merging cells and data in Google Sheets

Merging cells is a very handy tool in google sheets. It allows you to combine two or more cells horizontally, vertically, or both. One of the main reasons people merge cells is to extend a title or any content across multiple cells.How do we merge cells in google sheets?It is …

Continue reading

Guide to Pivot Tables on Google Sheets.

Guide to Pivot Tables on Google Sheets.

Pivot tables on Google Sheets enable you to organize your data without manual work. Here is how you can create one.

Continue reading

Why is your Google Sheet so slow? And how you can speed it up.

Why is your Google Sheet so slow? And how can you speed it up.

Import functions are great until they start slowing down Google Sheet performance. Find out how Airboxr can import data without long loading times.

Continue reading

How to combine data from Facebook Ads and Google Ads

How to combine data from Facebook Ads and Google Ads

The hard way and the easy wayIf you're reading this, you're probably using both Facebook ads and Google ads. You target different audiences on their respective platforms. Facebook ads target users who show interest in products similar to yours. On the other hand, Google ads focus on users who search …

Continue reading

How to combine data from Google Ads and Google Analytics

How to combine data from Google Ads and Google Analytics

Combining data from Google Ads and Google Analytics is tougher than it seems. Find out how you can do it through a simple two-step process with Airboxr.

Continue reading

Analyze Stripe charges with Airboxr

Analyze Stripe charges with Airboxr

With a little help from ZapierIf you use Stripe for your business, understanding how you're doing is essential to designing your marketing and sales strategy. While we do not connect natively to Stripe, you can quickly set up your Stripe integration with a little help from Zapier. Here are the …

Continue reading

How to get Google Analytics data into Google Sheets

How to get Google Analytics data to Google Sheets

And a hot tip to ensure you aren't slowing down your analysis.Google Analytics is the most popular analytics tool for websites around the world. I'm especially a big fan of the Real Time dashboard and the Source/Medium table that shows me where my traffic is coming from. However, it isn't …

Continue reading

How to import multiple columns with vlookup

How to import multiple columns with vlookup | Easier with Airboxr

The hard way and the easy wayWhen I try to pull data from another tab on my spreadsheet, I typically use the vlookup formula. But the vlookup formula only pulls one column at a time. This forces me to replicate the formula in multiple columns, only for my analysis to …

Continue reading

How to use query + importrange to filter data on multiple criteria

Using Query + Importrange to filter on multiple criteria | GSheet

With and without code.The query() function is an extremely handy function within Google Sheets, that makes it incredibly easy to filter data within your sheet. Let's take three minutes to see how it works. Case in Point: Pulling data from a Facebook Ads export based on multiple criteriaLet's say we …

Continue reading
Your cart