Enhance Apollo Search Output by Adding Results Count Column

·

Hi Support. When I run a Find People at Company from Apollo, I would like to get the number of results found as a number in a separate column. The reason for this is so I can write any company where Apollo found no results to another table to enrich using different providers. This will help me enrich my CRM with new contacts that I don't already have saved. Let me know how I can do this.

4 comments

· Sorted by Oldest

Eamon Bradley
·
·
https://app.clay.com/workspaces/228088/tables/t_YBsdb9hUQmAK/views/gv_rEgjx8sGytv4 Table where it would be helpful if you want to set it up for me 🙂
Muhammad
·
·
You can use this formula.
Loading attachments

Muhammad

·

{{APOLLO FINDPEOPLE COLUMN NAME}}?.results?.people?.length

Eamon Bradley
·
·
Thanks Muhammad. Had to do two columns and change "people" to "contacts" then do a Sum column to get the total - but got there in the end 🙂

Eamon Bradley
·
·
https://app.clay.com/workspaces/228088/tables/t_YBsdb9hUQmAK/views/gv_rEgjx8sGytv4 Table where it would be helpful if you want to set it up for me 🙂
Muhammad
·
·
You can use this formula.
Loading attachments

Muhammad

·

{{APOLLO FINDPEOPLE COLUMN NAME}}?.results?.people?.length

Eamon Bradley
·
·
Thanks Muhammad. Had to do two columns and change "people" to "contacts" then do a Sum column to get the total - but got there in the end 🙂