What is Airboxr?
Airboxr is a data analysis productivity tool that allows you to load, transform, and integrate data across multiple platforms, without having to spend hours cleaning data every time you put together a report. Gathering data can involve lots of tim...
What are Google Sheets add-ons?
Add-ons are third party plugins that take your Google Apps usage to the next level. Airboxr in its current form exists as a Google Sheets add-on, which means you would install it as a plugin onto Google Sheets. Next: How do I install Airboxr as a...
How do I install Airboxr as a GSheets add-on?
Installing Airboxr is not complicated, but there are some important things you have to take note of first to make sure the process goes smoothly. Before Installing Airboxr Sign in to Google Chrome and Google Workspace using your Google Workspace...
How do I access my data through Airboxr?
After you have installed Airboxr as a Google Sheets add-on, you'll immediately be prompted to connect Airboxr to your data sources - for example, Shopify, Facebook, Google Analytics and so on. Connecting your data sources means that Airboxr will...
What can I do with Airboxr?
Airboxr is a powerful tool that lets you do many different tasks critical for your company or business, all in one spreadsheet. Airboxr offers one-click analytics across data platforms for your marketing teams. Watch this video for a walkthrough o...
Integrations
How do I connect to MySQL Databases?
Airboxr helps you import data from your MySQL database without writing any code or leaning on your tech team for help. To begin, you must first connect your database to Google Sheets using Airboxr. Step 1: Launch Airboxr on any Google Sheet. Go to...
How do I connect to Hubspot?
When you connect Hubspot as a data source, you also need to choose any possible Custom Properties you may have to sync with Airboxr. To connect Hubspot as a data source, follow these steps: Once Airboxr is launched, click on Import . Add Hubspot...
How do I connect to HubSpot Marketing?
You need to be subscribed to Marketing Hub Professional account on HubSpot before connecting HubSpot Marketing to Airboxr. To connect HubSpot Marketing as a data source, follow these steps: Once Airboxr is launched, click on Import . Add HubSpo...
How do I connect to another spreadsheet?
Do you already have data in a spreadsheet, which you want to churn through Airboxr, or combine with your other data sources like Google Analytics or Hubspot? Not a problem. We'll show you how. Ensure the source spreadsheet has headers in the first...
How do I manage my data connections?
If you ever need to change or reset a connection, you can access it via two ways: Airboxr Home Screen → Import Airboxr Home Screen → Lookup Where you see the data connections listed, if you have already connected them, there will be a button besid...
How do I connect Airboxr to Google Data Studio?
Get the step-by-step instructions with screenshots from our blog post . Or, follow the steps below: In Google Data Studio, click Create, then Data Source. Select the Google Sheets connector. Select the Google spreadsheet you want to use as your d...
Analysis
How do I do a Lookup?
LOOKUP - now that you have data in your spreadsheet, you may want to compare it with other data from a different data source. Similar as with import, select your data source and filter accordingly. Make sure you select at least one property that...
How do I combine data from multiple sources?
You can easily combine data from multiple sources using the Lookup function . Here's a video showing how you can compare data from Google Analytics and Google Search Console:
How do I Import data?
IMPORT - this is where you get your data from various data sources into your spreadsheet. From the Home Screen, click Import. Select your data source, then click the button to go to the next page where you'll be asked to choose which properties (...
What are Templates and how do I use them?
Templates are created by the Airboxr team to make it even easier for you to use Airboxr. All you have to do is install Airboxr, fire up a template, and click Refresh Template Data. In one click, all the data updates and you can get straight to you...
How do I use AirHops?
AIRHOPS - a special feature in Airboxr that allows you to perform one-click queries to help automate your reporting. Airboxr comes pre-loaded with some AirHops for you to use immediately. If you prefer to make your own queries, you could also sav...
FAQs
What advantages does Airboxr have over Hubspot native reporting?
It depends on which Hubspot plan you are on, but generally: Airboxr is more flexible (as much as a spreadsheet) and can help you combine data from multiple sources. Oftentimes, you will need to combine data from Hubspot (e.g., number of leads adde...
How secure is my data?
At Airboxr, we ensure that your data is secure and protected at all times. Here's a brief summary of what that means for different sections of our systems: Data at Rest We do not store any data from third-party sources that you connect through Air...
Troubleshooting
My Airboxr plugin is stuck at loading. Why?
You may see different versions of this issue when trying to load Airboxr (or, in most cases, any Google Sheet plugin): You may see a broken :-( icon where the Airboxr app should be. The app might get stuck at loading. The app might load to a blank...
Can I make a copy of my Template into another GSheets workbook?
Unfortunately, you aren't able to copy your Template sheet into another workbook. But you can copy your other sheets into your Template workbook. Our Dynamic Templates run on multiple other hidden sheets that are loaded into the workbook, so simpl...