ScraperCity logo

Integration Guide

ScraperCity + Clay

Enrich your Clay tables with B2B contacts from the Lead Database. Map a company domain or job title column and Clay pulls matching contacts for every row.

How It Works

Clay’s HTTP API enrichment column lets you call any external API for every row in your table. You add a column, point it at the ScraperCity endpoint, map your table columns to the query parameters, and Clay runs the request for each row automatically.

The most common pattern: you have a table of company domains and you want to find decision-makers at each company. The enrichment column calls the Lead Database API with that domain and returns contacts with name, email, title, and LinkedIn URL.

Setup

1

Add an HTTP API enrichment column

In your Clay table, click “Add enrichment” and search for “HTTP API.” Select it. You will land on the Configure tab.

2

Configure the request

Method:GET
URL:https://app.scrapercity.com/api/v1/database/leads
3

Add the Authorization header

In the Headers section, add:

Header Name:Authorization
Header Value:Bearer YOUR_API_KEY
4

Map query parameters to your table columns

In the Query Parameters section, add the filters you want. Use curly braces to reference table columns dynamically:

companyDomain = {Company Domain}
hasEmail = true
limit = 5
title = {Target Title}

You can reference any column in your table and map it to any API filter: title, seniority, industry, country, state, city, companyName, minEmployees, maxEmployees.

5

Set rate limits

In the enrichment settings, configure rate limiting:

Request Limit:10
Duration:1000 (milliseconds)
6

Test on a single row

Click “Test” to run the enrichment on one row. Verify the response contains the data array with contact records. If it works, run the full table.

Extracting Fields from the Response

The API returns a JSON object with a data array. After the HTTP API column runs, add “Extract Values from Data” columns to pull out individual fields:

data[0].emailFirst Contact Email
data[0].first_nameFirst Contact Name
data[0].titleFirst Contact Title
data[0].linkedin_urlFirst Contact LinkedIn
data[0].company_nameCompany Name
pagination.totalTotal Matching Leads

Change the array index (0, 1, 2...) to extract multiple contacts per company. Or use Clay’s “Insert all items” option to expand the full array into separate rows.

Common Patterns

Account-Based Enrichment

Start with a table of target account domains. Map companyDomain to each row. Set limit=5 and seniority=c_suite to find top executives at every account.

ICP Search

Create a single-row table with static query parameters (title=CTO, industry=computer software, country=United States, hasEmail=true, limit=100). Run once to pull 100 leads matching your ideal customer profile.

Waterfall Enrichment

Use the ScraperCity HTTP API column as one step in a Clay waterfall. If your primary email provider returns no result for a contact, fall back to ScraperCity to find the email.

FAQ

Get API access to the Lead Database: