To make the most of your Shopify data, you need to know how to create API credentials for Shopify. Creating API credentials also protects data and ensures smooth integration.
Setting up the Windsor.ai connector takes two steps: create a Shopify custom app to get a Client ID and Client Secret, then enter those in Windsor.ai to connect your store.
Step 1: Create your Shopify API credentials
Since January 1, 2026, Shopify no longer allows creating new legacy custom apps; new apps are created through the Shopify Dev Dashboard instead. Existing custom apps continue to work as before.
- Create an app in the Shopify Dev Dashboard.
- Set the App URL to
https://onboard.windsor.ai. - Add the required scopes:
read_customers, read_inventory, read_locations, read_marketing_events, read_orders, read_products, read_returns, read_all_orders, read_shopify_payments_accounts, read_shopify_payments_payouts. Leave all other settings at their defaults. - Release the app, then go to “Home” > “Select distribution method” and choose “Custom distribution.” Enter your shop name and open the generated URL in a new tab.
- Go through the authorization flow and install the app, then return to the Dev Dashboard (if you see an error at this step, the app is still installed, so continue).
- In the Dev Dashboard, open the app’s “Settings” and copy the Client ID and Client Secret.
For the full walkthrough with screenshots, see the Shopify Configuration Guide.
Step 2: Connect your store to Windsor.ai
- Go to onboard.windsor.ai and register or log in.
- Select Shopify as your data source, then enter your shop name, Client ID, and Client Secret from Step 1.
- Choose your destination and preview your data.
Turning connected Shopify data into e-commerce insights
Once Shopify is connected, Windsor.ai blends your order, customer, and revenue data with spend from your ad platforms (Google Ads, Facebook Ads, TikTok, and more) in one place, so you can see true ROAS and customer lifetime value per channel and campaign, not just per platform in isolation. This also removes the need for manual CSV exports or spreadsheet formulas to join Shopify data with ad performance, since it stays in sync automatically once set up.
Setting up the Windsor.ai Shopify Connector
Once your store is connected, choose the store or stores you wish to link, then select the destination.
There are multiple data destinations. It depends on your preference and the platform you use to analyze your data. As you can see, Tableau, Looker Studio, Google Sheets, Excel, Python, and more.
There are options for different purposes on Windsor.ai. But it also depends on your preferences and what type of reports you prefer. If you’re familiar with Windsor.ai, there’s no need to explain this step to you in great detail.
Finally, you can also choose the database or databases from which you can get the data. Google Big Query and Windsor.ai Cloud Database are among the offered options here.
How to use the Shopify Connector
Once it’s all set, let’s take a look at the options that the Shopify Connector offers. Here’s a sample of the structure:
The Shopify data is shown on an object level and if you specify the date fields you can use that as a filter to view data based on the period when it was collected, i.e. when the objects were created.
Some of the Customer available fields are:
- Customer created at, the date and time when the entry for a customer/visitor was created in the system
- Currency, this can be quite useful if you sell goods or services in multiple countries and your customers pay using different currencies.
- Email address, if the customer has provided an email address, which is usually the case, you can use it for remarketing purposes, cross-selling, and more.
- ID, this is the unique ID for each customer that is created in the system.
- Note, this is a customized note that you have created about the customer and it can refer to anything and everything. It depends on the nature of the business and the type of goods or services you offer.
The types of fields based on their function are timestamp, text, date numeric, and Boolean. All of the fields are explained and described in our API documentation. Just select the Shopify Connector, and you can read more details regarding the fields.
Conclusion
Shopify is one of the largest e-commerce platforms, and its analytics allow you to get insight into the recent activities of your visitors, their shopping patterns, and habits. However, you can also analyze aspects like the speed of online stores and more. Automating the data extraction is one of the key functions and benefits of the Windsor.ai API.

Get started for free
Access all your data from your favorite sources in one place.
Free forever plan, no credit card

