Find & verify business emails automatically with OpenRouter, Serper & Prospeo

Who is this template for?

Growth teams, SDRs, recruiters, or anyone who routinely hunts for hard‑to‑find business emails and would rather spend time reaching out than guessing formats.

What problem does this workflow solve?

Manually piecing together email patterns, cross‑checking them in a verifier, and updating a tracking sheet is slow and error‑prone. This template automates the entire loop—research, guess, verify, and log—so you hit Start and watch rows fill up with ready‑to‑send addresses.

What this workflow does

1. Pull fresh leads – Grabs only the rows in your Google Sheet where Status = FALSE. 2. Find the company pattern – Queries Serper.dev for snippets and feeds them to Gemini Flash (via OpenRouter) to spot the dominant email format. 3. Build the address – Constructs a likely email for every first/last name. 4. Verify in real time – Pings Prospeo by default (API) or lets you bulk‑clean in Sparkle.io. 5. Write it back – Updates the sheet with pattern, email, confidence, verification status, and flips Status to TRUE. 6. Loop until done – Runs batch‑by‑batch so you never hit API limits.

---

🆓 Work free‑tier magic (up to \~2,500 contacts/month)