Clay Icon

How to Call Find People from a Formula in a Google Sheets Column for Enriching Company Names

ยท
ยท

Is it possible to call "Find People" from a Formula in a Col ? My use case would be Step 1 - Get Company Name Step 2 - Enrich to get LI or www Step 3 - Enrich to get Data from LI Enrichment Step 4 - Score it based on Keywords Step 5 - Manual Review to select which rows (companies) are relevant And this is where I would like to automate the Find People - for the Company in that Row (I know I can filter and run Find People in view after the filter - but I am trying to make this a bit more foolproof)

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Hey Ian! You should be able to based on this and by applying this combination. Toggle this 'Off' and then apply the conditional formula so that it only runs after you check a box or meets a condition you add manually

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Of course, to create the People Search column in your company table you'll have to run and save an initial search.