Gold Penguin Logo with Text

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.
Updated March 4, 2024
get Shopify product listings using Clay
get Shopify product listings using Clay
Difficulty: Easy. Might help to know the basics of this tool/topic
Time Required: ~10 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!

get Shopify product listings using Clay

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.

add a list on Clay

2) Add Enrichment

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

add enrichment on Clay table

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

get products on Shopify

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.’

add website URL as input

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.

add data as column on Clay

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.

get Shopify product listings using Clay

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 monthly newsletter
where we share tips & tricks on how to use tech & AI to grow and optimize your business, career, and life.
Written by Christy Cañete
Christy Cañete is a software engineer who's passionate about front-end web design. Not only can she code, but she writes too! She loves breaking down technical topics into super easy tutorials. If you're looking to learn without the jargon, she's your go-to.
Notify of

Inline Feedbacks
View all comments
Join Our Newsletter!
If you enjoyed this article, subscribe to our newsletter where we share tips & tricks on how to make use of some incredible AI tools that you can use to grow and optimize a business