LeadOcean + Clay: enrich a list with fundraising information

You get a Clay table that takes a column of company domains and returns total raised, last round type, last round date and lead investors from one API call. LeadOcean answers from its own company records, so there is no search and no page scrape. Funding is held for a small fraction of companies, so some rows come back without it (LeadOcean docs, September 2026). Clay's HTTP API column needs Growth or higher (Clay pricing, September 2026).

Clay's own template takes a different route. It runs a Google search for the Crunchbase link, confirms the link, then scrapes it with ZenRows (Clay template, September 2026). That is three steps per row and a scraper bill. This recipe is one step per row.

How it works

1. Add your domains. Create a text column named Domain, one bare domain per row, like acme.com. Strip https:// and www. first.
2. Add an HTTP API column. Method POST, URL https://api.leadocean.io/v1/companies/enrich.
3. Send the domain. The body is { "domain": "/Domain" }, where /Domain is Clay's reference to the column (Clay docs, September 2026). Add your key in the x-api-key header.
4. Return the funding block. Set the field path to data.company_data.company_funding. Clay documents dot notation for field paths.
5. Split it into columns. Add one formula column per field you want: total raised, round type, round date, lead investors.
6. Skip finished rows. Use an "Only run if" formula so the column skips rows that are empty or already filled (Clay docs, September 2026).
7. Test on five rows, then run the table.

Configuration

The column setup in Clay:

Method:   POST
URL:      https://api.leadocean.io/v1/companies/enrich
Headers:  x-api-key: <your LeadOcean key>
          content-type: application/json
Body:     { "domain": "/Domain" }
Field paths to return:
          data.company_data.company_funding

Test the same call from a terminal with a placeholder domain.

curl -s -X POST "https://api.leadocean.io/v1/companies/enrich" \
  -H "x-api-key: $LEADOCEAN_API_KEY" \
  -H "content-type: application/json" \
  -d '{"domain":"acme.com"}'

A company LeadOcean holds returns 200 and the funding block sits at data.company_data.company_funding. A company it does not hold returns 404. To find funded companies instead of enriching a list, the company search filters fundingType, minFunding, maxFunding, minLastFundingYear and maxLastFundingYear find funded companies directly (LeadOcean docs, September 2026).

Field mapping

Cost at 10,000 rows

10,000 domains cost LeadOcean up to 10,000 records, with no per-record price on a paid plan.

LeadOcean. A company found is one record, even when it has no funding block. A 404 costs nothing (LeadOcean docs, September 2026). Free holds 1,000 records for life, so it covers a test of one tenth of the list. Solo is $97 a month with a fair-use pace of 10k enrichments every 5 hours. Agency is $497 a month (LeadOcean pricing).

Clay. Each HTTP API call uses one Action, so 10,000 rows use 10,000 Actions. Growth includes 40,000 Actions a month and costs $495 a month billed monthly, or $446 billed yearly (Clay pricing, September 2026). This recipe spends no Data Credits.

Clay's Crunchbase template. It runs a Google search, a link check and a ZenRows scrape per row, so each row is three steps to pay for instead of one (Clay template, September 2026).

Troubleshooting

FAQ