This integration allows you to connect and pull data from your Shopify store into your data notebooks.
In this guide:
To connect Shopify with your data notebooks you need to have the following:
- Shopify account
- Generated private app on Shopify with the appropriate permissions
- Intersect account and owner access level
Connecting your Shopify account
You can add the Shopify integration from the Dashboard > Integrations > Add integrations > Add Shopify section.
One-click on the Shopify box and the connection portal will open. These are the fields that are required for the connection to be successful:
- Integration name
- API Key
- Example URL
To access these parameters, you need to create a private app on your Shopify store account. You should be able to do it on your own, by following the official Shopify documentation. If you set up the private app successfully, Shopify will provide the API key, Password, and Example URL (as shown in the image below) directly in your Admin API.
You can then proceed to fill the connection portal in Intersect. If the connection is successful, you should be able to see your new Shopify integration on your Integrations page.
Pull data from Shopify
After you configure your Shopify integration, you can import your e-commerce data into your notebook. To do that, click Import data > E-Commerce data > Read from Shopify (Add).
Once you select the integration, a new “Read from Shopify” step will be added to your data notebook. To successfully pull data you will need to select the store that you've connected (in our case it’s called: Shopify store). Then, from the dropdown, you can select the type of data that you'll want to pull.
Remember: During the API access configuration process on Shopify, you can also configure which types of data the Intersect app will be allowed to collect. In our case, we've enabled customers, orders, and inventory.
If the step is successfully configured you will see an output with your sourced data.
If you wish to preview the table you can expand the Output step, which will preview the table that was sourced.
What can you do with your Shopify data?
You can easily analyze and visualize your Shopify sales and engagement data using Intersect's building blocks. These blocks allow you to sort, filter, aggregate, visualize and perform a variety of other data tasks, without coding.
Here are some data apps ideas that you can build with Intersect:
- Send an email with abandoned cart accounts every Monday
- Analyze and visualize the customer journey funnel
- Segment your most loyal customers and export in Google Sheets
- Build sales and KPI reports and dashboards