Before you begin
- Install API Importer for Google Sheets
The following guide is based on the Shopify Docs
Login to your store
Navigate to https://accounts.shopify.com/store-login?redirect=apps and select your store
Click on "Manage private apps"
Create a new private app
Give your app a name and fill in your email address
Read the modal, then click "I understand, create the app"
Copy your App's password
In Google Sheets, go to Add-ons -> API Importer -> My Requests