Rapidly shortlist all the vendors that work with your existing Shopify retailer customers to generate leads on the fly.

1. Kick off a new base using the Shopify template and some starter data

  1. Head over to Clay and select the Prioritize your list of Shopify stores template.
  2. Whether using customer names or domains, use the respective template table to paste in your data and watch your table autocomplete with product, collection, vendor and other data for each retailer.

2. Extract and shortlist vendors

Use the Write Lists to Other Table action to extract your vendors into a new table.

  1. Create a new table to store the extracted vendors

  2. Add the Write Lists to Other Table action to the original table with Get Products.

<aside> 💁🏾 Quick note: This action is currently in beta, so contact us to get access or try it yourself How do I write a list to another table?

</aside>

c. Specify your inputs. Make sure to use Get Products > Vendors as the source, specify maximum amount of vendors to pull per store, select the right base to copy from and the right table and column to paste into.

https://i.gyazo.com/88fa822de300fed2f4f170f9876b7ba4.gif

🏁 BONUS

Try out some small additions we've seen in the Clay community.

1️⃣ Target vendors by location After enriching the the names of vendors with Get Domain from Company Name and Enrich Company, extract the location into its own column. Normalize the data using the Mapbox Normalize Location action. Extract the relevant attribute, whether it is locality or country, and filter your view.

2️⃣ See if an entry is in another table to filter out vendors you've already contacted

Easily mark off which leads you've already spoken to by checking if a lead is part of the companies you've already contacted. Learn how to use Clay's Lookup In Other Table action.