How to Find Your Shopify Store's API Key

Accessing and processing data from Shopify to Google Sheets involves the use of APIs. Application programming interfaces, or APIs, gives its users a way to access the functions of an application or its data so that it can be processed by another application.

For this tutorial, we will access a Shopify API key that we can use to access its contents in another app like Google Sheets. We have already learned how to do so by using an external code and adding it as a script to your spreadsheet. What remains is to learn how to access a Shopify API key to make the code work.

Here are the steps:

Step 1: On the main sidebar on the left side of the main admin page, click Apps.

*Shopify main admin page. Apps option on the main sidebar highlighted.*

‍

Step 2: On the Apps page, scroll down to the end of the page. Notice the following line:

Working with a developer on your shop? Manage private apps

Click the Manage private apps link.

*Shopify admin Apps page. Highlighted is the link labeled Manage private apps, located on the end of the page.*

Step 3: The Private apps pages will be loaded. A button labeled Create new private app is present on the upper-right corner of the page. Click the button.

*The upper portion of the Private apps page. A Create new private app is present on the upper-right corner.*

Step 4: On the Create private app page, fill in the following details:

*The necessary app details are the private app name and the emergency developer email.*

‍

Next, scroll down to the section labeled Admin API and modify the permissions as needed. The permissions are needed to control what data can be accessed and whether the external app can write on the Shopify database or not.

Clicking the drop-down box lists the following options:

No access - the API key will not give you access to that data
Read access - the API key will give you access to that data but you cannot modify it via the external app. This is the best when you just need to access the data for analytics.
Write access - the API key will give you access to that data and you can add or modify entries to it via the external app. If you are developing a full-blown app to control your store, you should select this option.

There is a huge amount of Shopify store data that you can access through your API, so take your time on this portion so that you don’t need to generate a new API key when you need new permissions.

*The Admin API section lists all the possible data that can be accessed via the Shopify API. Take your time on this section.*

While being optional, you are also asked if you want to use Shopify’s Storefront API. Storefront API is an advanced API that allows you more flexibility in connecting to your store. Checking this option offers you more options.

Storefront API section on Shopify — *The Shopify Storefront API gives you more access and flexibility.*

Step 5: Once you are done, click Save. A pop-up box will appear that will remind you of the importance of keeping your private API safe.

Create private app pop-up box on Shopify — *A reminder by Shopify to keep your API key safe. Click Create app button once you are done reading it.*

Once you have read the reminder, click Create app.

Step 6: Go back to the Private apps page by clicking the back arrow on the upper-left portion of the page (not the back button of the browser!). The new private app will be listed on the table in the Private apps page.

*A table listing the private app with the corresponding API key. The details shaded for obvious reasons.*

‍

Click the listed private app name to access the API key.

A new table will appear on the page, which contains the API key and the password. A sample URL is also included so you don’t have to parse the API key and the password when using your external app.