← All integrations
Shopify

Shopify → Google Sheets

Shopify store orders, products, customers, and inventory data.

API key
Example prompts
“List orders from mystore.myshopify.com”
“List products from mystore.myshopify.com or paste a Shopify Admin store URL”
“List customers from mystore.myshopify.com”
How to get credentials
Step 1 — Create the app
  1. Go to the Shopify Developer Dashboard.
  2. Click Apps in the left sidebar.
  3. Click Create app, give it a name (e.g. “API Import”), and click Create.
Step 2 — Configure scopes
  1. On the page that opens, go to the Configuration tab.
  2. Click Configure next to Admin API integration.
  3. Add the scopes you need. Copy and paste these to get started:
read_orders
read_products
read_customers
  1. Click Save.
  2. Click Release to apply the scopes to your app.
Step 3 — Install the app on your store
  1. In the left sidebar, click Home.
  2. Scroll down and click Install app.
  3. Select your store and click Install.
Step 4 — Copy your credentials
  1. In the left sidebar, click Settings.
  2. Copy your Client ID and Secret.
  3. Note your store domain — the subdomain before .myshopify.com. For example, if your store URL is mystore.myshopify.com or test-store-123.myshopify.com, enter the full subdomain.
Step 5 — Connect in API Import
  1. Open API Import for Sheets from the Google Sheets Extensions menu.
  2. Select Shopify from the API selector.
  3. Under Credentials, click Add Shopify credential.
  4. Enter your Client ID, Client Secret, and Store Domain (e.g. mystore or test-store-123 — the part before .myshopify.com).
  5. Click Connect Shopify — the add-on fetches and stores your token automatically.
  6. Select the saved credential from the dropdown and run your prompt.
✓ Tokens are refreshed automatically — you never need to rotate them manually.

Ready to connect Shopify to Google Sheets?

Install the free add-on and start pulling data in minutes.

Install Free on Google Sheets