Try It

Find an email address from new rows on a Google Sheet with Hunter and update them

  1. When this happensStep 1: New Spreadsheet Row

  2. Then do thisStep 2: Find Email (Legacy)

  3. Then do thisStep 3: Update Spreadsheet Row

You have a list of people in a Google Sheets but sadly no email address for them? Don't panic! With Zapier, you can now find an email address from a domain name, a first name and a last name.

Note: This Zapier integration doesn't find email addresses for already saved profiles in the Sheet—only new ones after you've set it up.

How this Google Sheets-Hunter integration works

  1. A new row (containing a domain, a first name and a last name in separate columns) is created in a Google Sheet
  2. Zapier finds the most likely email address for this profile
  3. Zapier updates the row on Google Sheets with the results

Apps involved

  • Google Sheets
  • Hunter
Try It

Connect Google Sheets + Google Sheets in Minutes

It's easy to connect Google Sheets + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.

All Triggers & Actions

New Spreadsheet Row (Team Drive)

Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.

New Spreadsheet

Triggered when you create a new spreadsheet.

InstantNew or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Create Spreadsheet Column

Create a new column in a specific spreadsheet.

Create Spreadsheet Row(s)

Create one or more new rows in a specific spreadsheet (with line item support).

InstantNew Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

New or Updated Spreadsheet Row (Team Drive)

Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.

New Worksheet

Triggered when you create a new worksheet in a spreadsheet.

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

Copy Worksheet

Create a new worksheet by copying an existing worksheet.

Connect the apps you use every day

Get started with a Free account

Or
By signing up, you agree to Zapier’s Terms of Service