1) Install Instant Data Scraper

For this tutorial, we’re going to use Instant Data Scraper to pull relevant data from Capterra. So go ahead and install the Instant Data Scraper extension for Google Chrome.

2) Scrape Leads from Capterra

Let’s say we’re interested in getting leads from Digital Marketing Agencies in New York.

Visit Capterra and go to Service Categories > Digital Marketing Agencies.

On the left side, you should see some filter options to narrow down your results. In this case, we’ve entered New York City on the location field. We’ve also chosen ‘Information Technology and Services’ for the ‘Industries Served.’ 

Feel free to modify your filter options to meet your needs.

Now you have the filtered results, it’s time to pull the data. Click the Instant Data Scraper icon from the toolbar.  

On the pop-up window, you can set the minimum and maximum waiting time for each request. The purpose of the delays is to mimic a human-like behavior when browsing the website. Doing so will prevent your IP from getting banned or rate-limited. 

You can also enable the infinite scroll to capture all the results on the page. Once you’re done, click ‘Start crawling.’ 

Once the process is complete, the app will show you the number of pages scraped as well as the number of rows collected and working time. You’ll also be presented with different options to download your data.

In our example, we’ve chosen CSV.

3) Import Your Data On Clay

Create a new table on Clay and import the CSV file. You should now see all the information we’ve just scraped from Capterra.

So, go ahead and remove the information that you don’t need. In this case, I’ve retained the company name, location, and services, and deleted the rest. I’ve also renamed these columns to make it easier to refer to them later on.

4) Get the Company Domain

Right-click your table and select ‘Add enrichment.’

On the pop-up window, look for an integration tool to get the company domains from your list.

Clay supports several apps to help you pull the website URL of any company. In this tutorial, we’re going to select Clearbit because it’s free.

On the settings page, you can choose which API key to use. By default, Clay’s Clearbit API Key is selected, so we’ll leave this as is.

For the input, simply select the ‘Company Name’ column from the dropdown. Click ‘Continue to Add Fields.’

Choose the data you want to be added to your table. Let’s choose the domain. Then, click save and run.

Your table should now be populated with the website URLs of your target companies. 

5) Find the Decision Makers

Now that we have the company name and domain, all we need to do is enrich the table further to find the decision makers.

Normally, you’d have to enrich your table multiple times to find the names and work emails of your leads. But with Clay's 'recipe' feature, you can gather all the info you need in just one go.

Once again, add an enrichment to your table. On the pop-up, click ‘Recipes’ and choose ‘SMBs - Find and Verify Decision Makers + Contact Information.’

On the settings page, almost everything you need should be set already. However, you can change the apps from the dropdowns if you wish. For this guide, we're keeping the default settings.

All we need to do now is set the inputs for the business name and business website. After that, click ‘Apply & Run First 10 Rows.’

Your table should now have the email addresses of your target prospects.