Lookup Company Names and Pull Headcount in Find People Table

Alex J. · 2025-10-31 09:18:27.250672+00

is there any way in a find people table, to lookup the company name in the find company table and pull through the headcount?

15 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes! Clay automatically links your Find Companies table to your Find People table, allowing you to extract company attributes directly into your people data. [1]
You can use the Lookup Single Row or Lookup Multiple Rows actions to pull headcount data from your company table into your people table. [2]
For headcount specifically, you can also use enrichment integrations like:
Get Employee Count by Criteria with People Data Labs [3]
Find Employee Headcount by Criteria with Companies, People, Jobs [4]
These allow you to get headcount data based on company identifiers like LinkedIn URLs or domains that you already have in your people table.
Clay Support
APP
·
·
Was that helpful?
Alex J.
·
·
That first suggestion is 5 credits/row when the data already exists in the Find companies table.
Clay Support
APP
·
·
You can pull company headcount data into your Find People table by using the automatic linking between your Find Companies and Find People tables. This lets you extract company attributes, like headcount, directly into your people table without using additional credits or manual configuration. Just rerun the lookup column in your Find People table to sync any updated information from your Find Companies table. [1] [2] [3]
Clay Support
APP
·
·
Was that helpful?
Alex J.
·
·
How do i rerun the lookup
Clay Support
APP
·
·
To rerun the lookup and sync updated company information into your Find People table, click the header of the lookup column in your Find People table and select "Force Rerun Column." This will refresh the data and pull in any new or updated details from your Find Companies table. If you’ve added new columns to the company table, force running the column ensures those values appear in your people table as well. [1] [2]
Clay Support
APP
·
·
Did that answer your question?
Alex J.
·
·
No - i dont have a column for company headcount in the find people table..
Clay Support
APP
·
·
I'm connecting you to a human agent who can assist you further with this. Thank you for your patience.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Alex J.
·
·
How do i use the lookup multiple rows and then return the company size when it finds the company in the find companies table
Alex J.
·
·
ive ended up doing this; Lookup multiple rows, pull through that random code for "size" and then a formula that if result = 1 string then 51-200 or otherwise 201-500
Loading attachments
Andrew Q.
·
·
Hey Alex! Glad to hear you've figured it out! Let me know if you have any other questions!
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!

Clay Support
APP
·
·
Yes! Clay automatically links your Find Companies table to your Find People table, allowing you to extract company attributes directly into your people data. [1]
You can use the Lookup Single Row or Lookup Multiple Rows actions to pull headcount data from your company table into your people table. [2]
For headcount specifically, you can also use enrichment integrations like:
Get Employee Count by Criteria with People Data Labs [3]
Find Employee Headcount by Criteria with Companies, People, Jobs [4]
These allow you to get headcount data based on company identifiers like LinkedIn URLs or domains that you already have in your people table.
Clay Support
APP
·
·
Was that helpful?
Alex J.
·
·
That first suggestion is 5 credits/row when the data already exists in the Find companies table.
Clay Support
APP
·
·
You can pull company headcount data into your Find People table by using the automatic linking between your Find Companies and Find People tables. This lets you extract company attributes, like headcount, directly into your people table without using additional credits or manual configuration. Just rerun the lookup column in your Find People table to sync any updated information from your Find Companies table. [1] [2] [3]
Clay Support
APP
·
·
Was that helpful?
Alex J.
·
·
How do i rerun the lookup
Clay Support
APP
·
·
To rerun the lookup and sync updated company information into your Find People table, click the header of the lookup column in your Find People table and select "Force Rerun Column." This will refresh the data and pull in any new or updated details from your Find Companies table. If you’ve added new columns to the company table, force running the column ensures those values appear in your people table as well. [1] [2]
Clay Support
APP
·
·
Did that answer your question?
Alex J.
·
·
No - i dont have a column for company headcount in the find people table..
Clay Support
APP
·
·
I'm connecting you to a human agent who can assist you further with this. Thank you for your patience.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Alex J.
·
·
How do i use the lookup multiple rows and then return the company size when it finds the company in the find companies table
Alex J.
·
·
ive ended up doing this; Lookup multiple rows, pull through that random code for "size" and then a formula that if result = 1 string then 51-200 or otherwise 201-500
Loading attachments
Andrew Q.
·
·
Hey Alex! Glad to hear you've figured it out! Let me know if you have any other questions!
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!