How to Get Product Listing from a Prospect’s Shopify Website Using Clay
Learn how to use Clay to easily extract product listings from Shopify stores. Improve your sales prospecting with these straightforward steps.

Christy Cañete
Updated February 16, 2024

get Shopify product listings using Clay
Reading Time: 3 minutes
Effective prospecting starts with understanding who you’re selling to.
If you’re a sales professional targeting Shopify stores, knowing their product listings can give you an edge. For instance, you can:
- determine if they are fit for your ideal prospect profile
- effectively create personalized emails
- offer tailored solutions to meet their needs
- ensure that your marketing approach resonates with the prospect’s product focus
Prospecting can be time-consuming and challenging. It requires a lot of hard work.
Instead of manually searching for product listings, why not automate the entire process? This is exactly where Clay comes in.
Clay is designed with built-in enrichment tools to help you streamline and optimize your prospecting efforts. In this guide, I’ll show you how to put this powerful tool to work for your advantage.
So, read on!

Steps to Get Product Listings from Shopify Websites Using Clay
1) Create Your List
Open Clay and set up a blank table. Input your list directly or upload a CSV file. Ensure it includes the Shopify URLs of your target stores. We'll tap into these URLs to pull product details from Shopify.

2) Add Enrichment
Click the "Add" button on your Clay table and tap ‘Add Enrichment.’

A window will pop up. Look for the ‘Get Products’ option and click it, as shown here.

3) Set Up the Input
Now, input the Shopify URL to enrich your data. For now, we’ll keep the other settings unchanged. Click on ‘Continue to Add Fields.’

4) Choose Data to Display
Here, you'll get options for additional data columns. For this guide, select product title, product type, product count, product collections, and vendor name. After selecting, save and run the app.

5) Review Your Data
Once the app runs, your table will show new columns—the ones you set earlier. If you wish to modify the data displayed, you can easily adjust the settings.

Each row under 'Get Products' shows multiple results or objects. To better manage these lists, consider using the ‘Write to Other Table’ feature in Clay. For more on this, see our tutorial titled "Using Clay to Identify Potential Competitors."
What’s Next?
Clay offers various enrichment tools to help you fetch data from target companies, like Shopify product listings, which we've covered here.
With this information, I suggest you try Clay's other functionalities to optimize your workflow.
For example, use Clay to find the tech stack of e-commerce websites you're eyeing. If you're in sales, this info will help you determine if they are a great fit to the products or services you’re offering..
Hope this guide proves useful! Got questions? Drop them in the comments, and we'll be there to help!
Want to Learn Even More?
If you enjoyed this article, subscribe to our free newsletter where we share tips & tricks on how to use tech & AI to grow and optimize your business, career, and life.