The majority of e-commerce businesses today run on Shopify. As of January 2022, Shopify is the largest e-commerce platform in the U.S., with 32% of the market share. Shopify provides many useful metrics on orders, customers, billing, inventory, and other types of data, which you can use Airboxr to import into your Google Sheet.
In this article, we’ll show you how to import Shopify data into Google Sheets in 5 steps:
- Install the Airboxr add-on for Google Sheets.
- Create a Private App in Shopify and get your API Key.
- Enter your Shopify Admin URL, API Key and Password into Airboxr to connect to your account.
- Select the Shopify data you want to import. Filter and Summarize your data as needed.
- Finally, Import your data.
Step 1: Install the Airboxr add-on for Google Sheets
Airboxr is a Google Sheets add-on which allows you to do your data analysis with ease. You can also use it to automate repetitive analyses using AirHops.
Note: Before installing any Google Apps, first make sure you are only logged in to one Google Account on your browser. (You may wish to create a separate browser profile e.g. for your work logins.)
To install Airboxr, go to our webpage and choose to install from the Google Workspace Marketplace or to get a guided installation.
After installing, open a Google Sheet and click on the Add-Ons or Extensions menu option at the top of the sheet.
Step 2: Create a Private App in Shopify and get your API Key
- In your Shopify store, find Apps on the left menu and click onto it.
- Click on Manage Private Apps, a small link below the main card, then on the next page click Create Private App.
- Under ‘Private app name’ type Airboxr; under ‘Emergency developer email’ type in your email.
- Show inactive Admin API permissions. Give Read access to Customers, Orders, and Products. Then, click Save and Create app.
- You will receive your API key and password.
You can also watch this video on how to create a Private App in Shopify:
Step 3: Connect your Shopify account to Airboxr
- Launch Airboxr and click on Import.
2. Add Shopify as a source.
3. Enter your Shop Admin URL, API Key, and Password as indicated. Then, click Connect.
Step 4: Select the Shopify data you want to import
- From the Airboxr homepage, click Import.
- Select Shopify.
- Select which table of data you want to import.
- Select columns you want to import.
If you want to transform your data before import, you can filter and summarize your data.
- Filter: select the parameters you want to filter by, e.g. “Total Price is greater than 10”
- Summarize: select the parameters you want to summarize by, e.g. “Maximum of Total Price”
Step 5: Click Import to pull your Shopify data into Google Sheets
That’s all! 🎉 You have your data in your Google Sheets for easy analysis.
Bonus: Save your analysis as a Hop
From here, you may also save your analysis as a Hop so you don’t have to make the same query twice to find the same information. Simply click Save and you will be prompted to name your Hop for future reference.
Airboxr also comes pre-loaded with many Hops for quick analysis, such as Products Sold, Fulfilled Items, Item x Shipper, Payment Status, and Customers over the last 30 days. You can edit these to a date range of your preference.
You can also watch our demo video to see how to import Shopify data and save your analysis in Google Sheets.