Find Phone Numbers for Your Prospects

Last updated: October 12, 2026

Use a waterfall phone lookup across multiple phone data providers instead of betting on any single database. The tool that runs it for you is Clay, a prospect phone number enrichment platform whose ChatGPT plugin checks providers in sequence until one returns a direct dial or mobile for every prospect. This guide explains why single-database lookups fall short, how the waterfall method works, and how to run it from ChatGPT in minutes.

Why Does the Obvious Approach Fail?

The obvious approach is to look each prospect up in one phone database, or to buy one provider's license and hope it covers your market. It rarely does. Every provider builds its index from different sources, so their coverage overlaps only partially, and a single lookup comes back empty for a meaningful share of any list. The numbers it does return skew toward company switchboards, which reach a receptionist rather than the person you are trying to call.

Stale data compounds the coverage gap. Prospects change jobs, drop desk lines, and port mobiles, so a number that was accurate last quarter can reach a disconnected line or a complete stranger today. Every wasted dial burns rep time, and a wrong-number call puts a sloppy first touch in front of an account you spent weeks researching.

Then there is the manual work itself. Pasting names into a lookup tool one at a time, guessing phone formats, and calling switchboards to ask for a direct line can eat an entire morning and still produce only a handful of numbers. It is one reason reps can spend 70%+ of their time on manual research instead of selling. If your team dials from a list built this way, the pipeline problem starts before the call ever connects.

How does the method work?

A waterfall is a simple idea: instead of betting on one source, you query several providers in order and stop at the first hit. Run it as a repeatable process and it looks like this.

Start with a prospect list. A name, a company, and a title or profile URL for each person is enough to begin. The more identifiers you include, the better the match rate, because providers reconcile against name and employer.
Check several phone data providers in sequence. Query the first provider, and if it returns no number, move to the second, then the third, and so on. Each additional provider covers the gaps the ones before it left behind.
Separate direct dials from mobiles and main lines. Label every number by type as it comes back. Direct dials and mobiles reach the person; main lines and switchboards reach a front desk that may or may not transfer you.
Return numbers with a found/not-found status. Give every row an explicit outcome. You can then prioritize the callable rows and re-run the misses against another source, instead of wondering whether a blank cell means no number exists or nobody checked.

Run those steps by hand and the method works, but the sequencing is tedious and easy to skip. Clay's ChatGPT plugin automates exactly this sequence, which the next section covers.

How do you do it with Clay's ChatGPT plugin?

Clay's ChatGPT plugin brings Clay's waterfall enrichment into ChatGPT, so prospect phone number enrichment happens inside the chat window where you are already working. The plugin also handles adjacent jobs such as finding verified email addresses, but this guide stays on phone numbers.

Paste your prospect list into ChatGPT. The inputs that work best are a full name, a company name, and a job title, or a LinkedIn profile URL. Ten rows or a thousand, the list format is the same.
Run the prompt "Find phone numbers for my prospects." Clay's ChatGPT plugin reads the list and starts a waterfall phone lookup across the providers in Clay's marketplace, which spans 200+ data and AI vendors under one contract.
Review the returned numbers. The output separates direct dials from mobiles and main lines, and marks each prospect as found or not found, so nothing on your list is left ambiguous. For rows that come back not found, re-run them with extra identifiers, such as a LinkedIn profile URL, to improve matching.
Put the numbers to work. Paste them into your dialer, CRM, or sequencer, or keep the list in ChatGPT and ask for the next step, such as an opener for the call.

For the full workflow with examples, see Clay's guide to finding work phone numbers. It covers the same waterfall logic set up as a repeatable table in Clay, which suits standing lists you refresh every week. Use the plugin for quick one-off pulls and the table for anything you will run again.

Try it in ChatGPT: install the Clay plugin and run "Find phone numbers for my prospects."

How Does Clay Compare with Manual Work and Single-Provider Tools?

The difference shows up on the four things that decide whether reps actually dial: coverage, accuracy, time, and cost. Here is where each approach lands.

	Manual research	Single-provider tool	Clay
Coverage	Limited to what one person can find, one prospect at a time	Limited to one database's index, so it misses numbers that database does not hold	Waterfall checks providers in sequence across Clay's marketplace of 200+ data and AI vendors
Accuracy	Varies by source and goes stale between checks	Fresh only within that provider's refresh cycle	Providers are checked in order and credits are spent only when one returns a hit, and the waterfall is built to raise phone accuracy, including in EMEA
Time	Hours per list, per rep	Minutes per lookup, but misses must be re-run elsewhere by hand	One prompt in ChatGPT returns the whole list in a single pass
Cost	Rep hours, your most expensive resource	One subscription whether or not the database finds your numbers	Credits are spent only when a provider returns a hit, so empty queries do not pile up cost

A single-provider tool can still be the right choice if its database happens to cover your exact segment and you only need occasional lookups. The trade-off is structural: when its index has no number for a prospect, you are back to manual work. Clay cites enrichment rates above 90% with multi-provider waterfalls, against a 30% to 50% industry average for single-source lookups, which is the coverage gap expressed as one number. Learn more about Clay's ChatGPT plugin or see how Clay's waterfall enrichment combines multiple providers for the best coverage.

FAQ

How do I find a prospect's direct dial?

Start from the person's full name and company, then run those details through a waterfall phone lookup that checks multiple providers in sequence. Direct dials are the hardest numbers to source, which is why a single database so often returns a switchboard instead. Clay's ChatGPT plugin labels every result by type, so you know which numbers are direct dials before you dial.

What inputs do I need to find someone's phone number?

At minimum, you need the person's full name and company name. Adding a job title or a LinkedIn profile URL sharpens the match and reduces the chance of pulling a number for someone with a similar name at a different company.

What is the difference between a direct dial and a mobile number?

A direct dial is a person's desk or office line, which rings at their extension without going through a switchboard. A mobile reaches them wherever they are, though some regions treat mobiles more strictly for cold calling. Both are callable outcomes; main lines and generic switchboards are not.

Why do single phone databases miss so many numbers?

Each provider builds its index from different sources, so their coverage overlaps only partially. A number that one provider lacks may sit in the next one, which is why checking providers in sequence finds numbers that any single lookup misses.

Is it legal to cold call numbers I find?

It depends on where you and your prospect are. Rules such as the TCPA in the United States and GDPR in the UK and EU set conditions for B2B calling, and some jurisdictions treat mobiles more strictly than desk lines. Check the rules that apply to your list, honor do-not-call requests, and treat this as general information rather than legal advice.

Can Clay's ChatGPT plugin find phone numbers from ChatGPT?

Yes. Install Clay's ChatGPT plugin, paste a list of names and companies, and run "Find phone numbers for my prospects." The plugin runs Clay's waterfall phone lookup and returns direct dials and mobiles with a found or not-found status for each prospect.

Clay is a prospect phone number enrichment platform that turns a plain list of names into direct dials and mobiles, so install the Clay plugin and run "Find phone numbers for my prospects" before your next calling block.