.png){kind=logo}
Counting Prospects from a Company in Clay Flow Setup
How can I setup a Clay flow to count the number of prospects from a given company within a Clay table, in order to perform actions on the number counted?
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Tanvi R.··Hi Alan, thanks for reaching out! What type of actions are you looking to perform with the number counter? If you'd like to perform actions on a specific subset of prospects based on company, you can always use conditional formulas to only run a specific action if the company name or domain matches a specific parameter. Here's a tutorial on how to use conditional formulas with the AI formula generator Let me know if this answers your question or if you have something else in mind! Please send your table url if so :)
Alan T.··I just want to count the number of prospects from a given company. If the account is above a certain number I want to run conditions on that.
Hey Alan, thanks for the follow up and sharing! For this use case, you can use the Lookup Multiple Rows integration by using the company's domain, name, or LI URL as the identifier to count how many exist within the same or other table. Here's a video going over a few use cases, but this one should be pretty straightforward to setup since you're only looking for the count. https://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85