Optimizing Job Posting Searches by Location in Existing Workbooks

·Oct 16, 2025 03:22 PM·

is there a good way to in a existing workbook (with lets say job postings), find people at those companies with different locations since each ob may be in a different place? for example not every job posting at a list of target accounts may be in the same geography (city, state, country, etc.) im using the find people at company enrichment but it isnt working well 😞 and im not sure how to use it best

11 comments

· Sorted by Oldest

Done M.
·
·
Yeah, ai. add a new column, give it all parameters and tell it to return you the desired outcomes. I.e. if you find a location "Chicago" return the name of the person in the location.
Garrett W.
·
·
ugh i dont want to use ai for this tho lol, this should be like product funcionality lol
Garrett W.
·
·
fair though
Garrett W.
·
·
totally fair shout
Done M.
·
·
({{Lookup Multiple Rows in Other Table}}?.records?.[0]?.Title) ({{Lookup Multiple Rows in Other Table}}?.records?.[1]?.Title) etc Since i pull these from the lookup multiple rows, this is how each of those fields look
Done M.
·
·
oh wait, this one and the other pic is the prompt:
Done M.
·
·
the prompt just goes through this list basically and checks each of them:
Done M.
·
·
what's your end goal btw? i might be able to write the prompt for you and you can just plug it in, if i understand your goal and output you expect
Garrett W.
·
·
read the bottom part of this thread if you dont mind - im trying to get a find people specific to location and title for each row https://clayrunhq.slack.com/archives/C025KSBLPGX/p1760558888644499
Done M.
·
·
{{Find people at company}}?.records?.[0]?.Title) {{Find people at company}}?.records?.[1]?.Title) up to [10] then also give {{Find people at company}}?.records?.[0]?.Location) (make sure the location field is called Location) up to [10] and then just prompt the AI to search for Barcelona and Software engineer, and if it finds them somewhere in the fields to return the title and the name of the person and their location.
Done M.
·
·
I can jump on a 10 min call with you if you want to help you too

Optimizing Job Posting Searches by Location in Existing Workbooks | Clay