No-Code Enrichment with
Clearbit’s Autocomplete is a free API that lets you fetch company names and retrieve logo and domain information. We show you how to use it at scale, and without code.
Sign Up Free

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:
Provider Enrichment Docs:
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.

Screenshot of Clearbit cURL request in Custom Enrichment tool

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.

Screenshot of Clearbit cURL request being customized in Custom Enrichment tool

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. 

Screenshot of data that can be imported from Clearbit with the Custom Enrichment tool

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. 

Screenshot verifying data should be imported

Here’s an example of the results:

Screenshot of updated data in Gigasheet after Clearbit data has been imported

Try it Out

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever