Skip to content
ClickRuntime

Connect Google Sheets to Hunter.io

A sheet is where most prospect lists start: names, companies and domains collected from events, directories or research. Hunter finds and checks the email addresses. Connecting them fills in the missing addresses, checks the ones you have, and keeps the results next to the rest of your notes.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Hunter.io

Email finding, verification and lead research for the people and companies in your sheet. These are ready-made starting points. Anything else you can describe works too.
Every 15 minutesAI

Find prospects' emails and draft a first message in your sheet

For each new name and company domain in your sheet, Hunter finds the email address and a short, personal first email is written beside it.

See how it works
Every 30 minutes

List the people at each company in your sheet

For each company domain you add, up to five contacts with their names, roles and emails are added to your Contacts tab.

See how it works
The moment it happens

Check new form leads with Hunter and log them in a sheet

Every form lead is checked with Hunter, logged in your sheet with its verification result and company details, and you get an email for the valid ones.

See how it works
On a schedule

Verify every email address in your outreach sheet

Each night, unchecked emails in your sheet are verified with Hunter and marked deliverable, risky or invalid.

See how it works
Every 30 minutesAI

Score local business leads and find the owner's email

Each business in your sheet gets a fit score for your offer, and the good fits get a decision-maker's email from Hunter.

See how it works
Every 60 minutes

Copy Hunter leads to Google Sheets

Leads saved in a Hunter leads list are copied to a Google Sheets tab with name, email, company, position and verification status.

See how it works
Every 30 minutes

Find company details for domains in Google Sheets

For each domain in the sheet without details, Hunter's company data fills in name, industry, headcount, country and LinkedIn.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and Hunter.io, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and Hunter.io automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Hunter.io in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Only look up rows where the title includes "Head", "VP" or "Director", and stop for the day when 50 lookups are used.

Mark emails with confidence under 70 as "risky" and do not move them to the outreach tab.

Use cases

Why people connect Google Sheets and Hunter.io

How the two apps work together

  • A check every few minutes finds new rows that lack an email or verification status.
  • The script calls Hunter's email finder, domain search or verifier.
  • It writes the email, confidence score and status back to the row.

  • SDRs building prospect lists

    Names and company domains in a sheet get work emails from Hunter. Lists are ready for outreach.

  • Recruiters finding candidates' emails

    Candidate names and companies are enriched with emails. Outreach is direct.

  • Marketers verifying lists

    Each email in a sheet is verified before a campaign. Bounces drop.

  • Founders researching companies

    A domain returns the people and roles Hunter knows. Target lists form quickly.

More apps

Google Sheets, Hunter.io and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Send after verify

For each row in my sheet with a verified email, send a personalised email from Gmail and mark the row sent.

Push to HubSpot

Add verified contacts from my sheet to HubSpot with source "Hunter".

Add to lemlist

Add rows with verified emails and confidence over 90 to my lemlist campaign.

Setup

Connect Google Sheets and Hunter.io once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

Hunter.io

Email finder

  1. Sign in to Hunter and open the API keys page in your dashboard.
  2. Copy your key, or generate a new one.
  3. In the ClickRuntime dashboard, open Connections & secrets and save the key as a secret for Hunter. It is sent in the X-API-KEY header.

FAQ

Questions about connecting Google Sheets and Hunter.io

Do I need a Hunter account?
Yes. You save your Hunter API key in your ClickRuntime dashboard. Each search or verification uses credits from your Hunter plan.
Will it look up the same row twice?
No. Rows that already have a result are skipped, so your Hunter credits are spent only on new rows.
Which columns does it need?
For finding an email, a first name, last name and company domain. For verifying, just the email address. Tell your AI assistant which columns hold them.
Is it suitable for cold outreach?
It finds and checks addresses. Make sure your outreach follows the rules that apply to you, such as giving people a way to opt out.
How many lookups does a row use?
An email finder or verification usually uses one Hunter request. Hunter's plan limits apply.
Can it find emails from a domain alone?
Yes. Domain search returns the emails Hunter has for that domain.
Does it overwrite existing emails?
No, unless you ask. It skips rows that already have one.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Hunter.io should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude