Hari P.

FYR

Let me jump in Ideally the next column would be your enrichment column. You can add a condition formula to run only if 'Number Of Results' is empty

Using lookup multiple rows, you will know whether there was a result or not

FYR - https://www.clay.com/university/guide/lookup-rows

Check this - https://www.clay.com/university/lesson/write-to-table-clay-101

this should help - https://phantombuster.com/automations/sales-navigator/9068/sales-navigator-url-converter/tutorial

You can use formula to extract the response. Example: if the response says 'Yes/ No' then write a formula to extract this

Add double quotes to Clay fields and try again. It should work Basically { "fullName": "NormaliseFullNameParse", "domain": "Company Domain", "realtime": true }

You can use the waterfall enrichment process here. In a nutshell, use multiple email providers until you find a valid email address. Credits are only charged when a valid email is found, and the charge is attributed to the provider that successfully identifies the email.

If it's people data, almost all the providers pull the data from LinkedIn. Go ahead and use Clay's LinkedIn data as even Apollo, they refresh every few months which is not always up-to-date