Last year, I created an add-on called API Connector for Sheets that pulls API data from Shopify and other platforms to Google Sheets. Shopify is one of the most popular data sources for users of my add-on, so I created a beginner-friendly, step-by-step tutorial for how to use API Connector with the Shopify API:
The tutorial walks through how to create a private app, get your API password, create an API request URL, and pull data into Google Sheets. It also discusses some common issues like setting scopes and dealing with pagination.
Creator, API Connector