You connect Shopify by creating a small private app in your Shopify admin, then pasting its Client ID and Client Secret into Merchant Sheets. The app has read-only access, so Merchant Sheets can never change anything in your store. Setup takes about 10 minutes.
If you'd rather do it together, book a setup call and we'll walk through it with you live.
Before you start
You need:
Store owner access, or a staff account with permission to develop apps
A Merchant Sheets account
About 10 minutes
Quick checklist
If you've done this before, here's the short version. Each item has its own section in this article with full steps and screenshots.
Copy your .myshopify.com address from Settings > Domains.
Open Settings > Apps > Develop apps > Build apps in Dev Dashboard.
Select Create app > Create app manually and name it Merchant Sheets Connection.
Set the App URL to https://merchantsheets.com, pick the newest Webhooks API version, and paste the seven read-only scopes.
Release the version, then release a second version that adds read_all_orders.
Install the app on your store.
Copy the Client ID and Client secret from App settings.
In Merchant Sheets, paste your store URL, Client ID, and Client Secret, then select Connect.
Find your store URL
Merchant Sheets connects through your store's .myshopify.com address, even if your customers see a custom domain.
Sign in to your Shopify admin.
Select Settings at the bottom of the left menu.
Select Domains, then copy the address that ends in .myshopify.com, such as your-store.myshopify.com. Keep it handy for the last stage.
Create the app in the Dev Dashboard
In Settings, select Apps, then Develop apps.
Select Build apps in Dev Dashboard. The Dev Dashboard opens on your list of apps.
Select Create app, then Create app manually.
Enter Merchant Sheets Connection as the app name.
Set the app's URL and scopes
The app's version sets where it points and what it can read. You release two versions, because Shopify only offers read_all_orders once the app already has a released version. That scope lets Merchant Sheets read orders older than 60 days.
Under URLs, enter https://merchantsheets.com in App URL. Leave Embed app in Shopify admin unselected, and leave the other URL fields blank.
In Webhooks API version, select the newest version.
In Scopes, paste this list:
Select Release, then select Release again to confirm.
Start a new version of the app. It keeps the settings from the version you released.
In Scopes, add ,read_all_orders to the end of the list.
Select Release, then select Release again to confirm. The app now has all eight scopes.
read_orders,read_products,read_inventory,read_locations,read_discounts,read_price_rules,read_shopify_payments_payouts
Every scope starts with read_, so the app can only read. Shopify permissions we ask for, and why explains each one.
Install the app on your store
In the Dev Dashboard, open the app's home page.
On the Installs card, select Install app.
In the tab that opens, select your store.
Review the read-only permissions, then select Install.
Copy the Client ID and Client Secret
In the app, select App settings.
Copy the Client ID.
Copy the Client secret. Treat it like a password, and don't send it by email or chat, including to us.
Connect the store in Merchant Sheets
In the Merchant Sheets web app, go to Data Connectors. If you're setting up a new workspace, you're already on the Connect Shopify step.
In Store URL, enter your .myshopify.com address.
Paste the Client ID and Client Secret into their fields.
Select Connect. Merchant Sheets checks the keys with Shopify and starts your first sync.
What happens after you connect
The first sync usually takes a few minutes, longer for a large order history. Data Connectors shows its progress, and you can keep working while it runs. Your first sync: what to expect covers timing and what you'll see when it finishes.
Merchant Sheets syncs your orders from January 1, five years before the year you first connect. How far back your data goes explains what that covers.
Each store counts toward your plan's store limit. To add another store, repeat these steps for it, or see Connect more than one Shopify store.
If the connection doesn't work
When the connection doesn't work, Merchant Sheets shows a message under the form. Shopify connection failed lists every message with its fix.
Optional: forward privacy requests from Shopify
If your app's version settings include privacy compliance webhooks (customer data request, customer data erasure, and shop data erasure), set all three to the address shown under How to get your keys on Data Connectors. Shopify then forwards your shoppers' data requests to us. Disconnecting a store always deletes its data, with or without these webhooks.