Shopify API in Google Sheets

Knowledge Base

Importing Shopify API data to a spreadsheet doesn't have to be painful! In this guide, we'll walk you through the basics of importing Shopify API data to Google Sheets.

Before you begin

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

Login to your store/

Click on "Manage private apps"

Click on "Manage private apps"/

Create a new private app

Create a new private app/

Give your app a name and fill in your email address

Give your app a name and fill in your email address/

Read the modal, then click "I understand, create the app"

Read the modal, then click "I understand, create the app"/

Copy your App's password

Copy your App's password/

In Google Sheets, go to Add-ons -> API Importer -> My Requests

shopify



You can run this command with =api("shopify")