Apollo helps you find and target your ideal buyers with the world's largest, most accurate B2B database. Apollo’s CSV enrichment tools are great, but what do you do when you need to enrich more than 10,000 contacts? With Gigasheet’s Custom Enrichment, you can use the Apollo API without writing any code to enrich thousands, or even millions of contacts. In this example we’ll be using the People Enrichment endpoint to enhance a list of individuals with all available data.
Provider Website: https://apollo.io
Provider Enrichment Docs: https://apolloio.github.io/apollo-api-docs/?shell#people-enrichment
Token / Registration Required: Yes
Step-by-Step: Enrich A Spreadsheet Using the Apollo.io API People Enrichment
You can pass Apollo any details you have about a contact, but in this example we’ll keep it simple and just use a name and company. However, the more information you pass in, the more likely the Apollo API will find a match!
Step 1. In Gigasheet, click the Enrichments button and select Apollo People Enrichment.
Step 2. Next enter your Apollo API key in the top field, and toggle on any of the inputs you have available. The more data you can provide Apollo.io about a person, the more likely it is to provide accurate context. In this example we have First Name, Last Name, and Email address. I've selected the corresponding column in my sheet for each field based on my column header names.
Step 3. Next click Test and Gigasheet will make requests for the first three rows and shows the Apollo.io API response. Select the enrichment fields, or attributes you want to be inserted into your sheet as new columns.
Step 4. Finally, click Apply and 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.
Gigasheet will enrich your sheet with new columns using the selected data from the Apollo API People Enrichment response!