Airboxr Google Sheets Add-On

All the documentation about the Airboxr Add-on for Google Sheets.

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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:

Avatar

By Saptarshi Nath

September 1, 2022

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 (...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

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...

Avatar

By Saptarshi Nath

September 1, 2022

FAQs

Troubleshooting