All workflows
Google Sheets logoApollo logoHunter logoAnthropic logoGmail logo

Find people at the companies you name and send a first email

Finds people by job title at the companies you list, confirms a work address for each, records them, then sends a first email.

Run manually5 apps9 steps

Apps it connects

Authenticate each one once and the workflow is ready to run.

What it does

Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.

  1. 1Google SheetsCreate tabCreates the tab that records everyone contacted, when it does not exist yet in your spreadsheet.
  2. If sentLogIsNew

    1. 2Google SheetsAppend rowWrites the headings on a new tab, then logs each person's address, name, title and company before their email is sent.
  3. 3Google SheetsRead columnReads the addresses already on the record so nobody who has been contacted before is emailed a second time.
  4. 4ApolloSearch peopleSearches for people holding the job titles you want at the company domains you listed.
  5. For each person

    1. 5HunterEmail finderLooks up a likely work email address for each person by name at their company's own domain.
    2. 6HunterEmail verifierChecks each found address against the mailbox and only lets a confirmed one with a confident score through.
    3. 7AnthropicGenerate model responseAsks the AI to write a short first email from the person's name, title and company alone, with a subject line.
    4. 8Google SheetsAppend row
    5. 9GmailSendSends the drafted email to the confirmed address with your sign off and opt out line added at the end.

How it works

What happens on each run, in plain English.

Run it by hand whenever you want to reach new people and it does the whole first touch: finds people with the job titles you want at the companies you list, works out a work address for each, checks it is real, writes a short first email and sends it from your Gmail. Only people at companies you named yourself are contacted.

Everyone contacted is recorded on a tab in your Google Sheet, created on the first run and read before every run so nobody is emailed twice. No address is guessed: only one confirmed by a mailbox check, with a confident score and at the company's own domain, is written to. The AI writes each email from the person's name, job title and company alone, a draft that implies you have already spoken is discarded, and your sign-off and opt-out line are added to every message. Each send is recorded before it is made, so a failure leaves a recorded row rather than a stranger emailed twice. There is no schedule on purpose: cold outreach should not run unattended.

apollohuntergmailgoogle sheetsprospectingcold emailsales

Start from a workflow that already works.

Add "Find people at the companies you name and send a first email" to your workspace, connect its apps, and make it yours. No credit card required.

Free plan available · No credit card required