Use Clearbit To Enrich Millions Leads In A Spreadsheet

Clearbit’s Company Autocomplete is an API that lets you auto-complete company names and retrieve logo and domain information. The Autocomplete API is freely available and doesn’t require registration. 

Provider Website: https://clearbit.com
Provider Enrichment Docs: https://dashboard.clearbit.com/docs
Endpoint: https://autocomplete.clearbit.com/v1/companies/suggest?query=segment
Token / Registration Required: No

How To Enrich Rows With Clearbit

Check out this video which features Clearbit and ChatGPT enrichment, or walkthrough the detailed steps below:

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request from the Clearbit API docs.

‍

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight the segment text in the input, and then select our column with company names and click +Insert Column Reference. Then click Next.

‍

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the Clearbit response. At this point select the fields you want to be inserted into your sheet. Here we’ve selected domain and name. 

‍Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet. 

Here’s an example of the results:

‍