← All integrations
Shopify

Shopify → Google Sheets™

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

API Import for Google Sheets™ lets you connect Shopify with the most popular apps, so you can automate your work and have more time for what matters most — no code required.

Google OAuth

Shopify is the e-commerce platform powering millions of online stores — it manages orders, products, customers, inventory, and fulfilment from a single dashboard. While Shopify's built-in export covers recent orders, it caps at 250 rows and goes stale the moment you download it. By connecting Shopify to Google Sheets™ through API Import, you can pull your full order history, live product inventory, and customer records into a spreadsheet and refresh them on any schedule — no developer and no manual export required.

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
Quick connect: If you already have access to a Shopify store, you can connect it in two clicks — no app setup required. Just type your store domain and click Connect Shopify Store in the sidebar.
Step 1 — Open the sidebar
  1. Open API Import for Sheets from the Google Sheets™ Extensions menu.
  2. Select Shopify from the API selector.
Step 2 — Connect your store
  1. Under Authentication, type your store domain in the Store Domain field (e.g. mystore — the part before .myshopify.com).
  2. Click Connect Shopify Store.
  3. Authorize in the popup. Your store will be listed as connected once the window closes.
  4. Select the connected store from the Saved Credential dropdown and run your prompt.
✓ Access tokens are permanent — you only connect once per store.
Use your own Shopify app (advanced)
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.
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 Authentication, click Add Shopify credential.
  4. Enter your Client ID, Client Secret, and Store Domain (e.g. mystore — 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.
→ View in docs

Ready to connect Shopify to Google Sheets™?

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

Install Free on Google Sheets™