Enrich domain URLs with Hunter.io and export contacts to Google Sheets

📺 Full walkthrough video: https://youtu.be/uk-mJRgYnfs

Who it's for

This workflow is for sales teams, marketers, and PR professionals who need to bulk-enrich a list of company domains with contact data (emails, names, job titles, LinkedIn profiles) and export the results to a spreadsheet for outreach or prospecting.

How it works

1. The workflow is triggered manually by clicking Execute workflow in the n8n editor. 2. It reads a list of domain URLs from a source tab in a Google Sheet. 3. Each domain is passed one by one to the Hunter.io Domain Search API, which returns up to 10 associated contacts per domain, including email address, confidence score, full name, job title, seniority, department, LinkedIn, Twitter, and phone number. 4. Each contact record returned by Hunter is appended as a new row in a separate Exported data tab of the same Google Sheet.

How to set up

- [ ] Connect your Google account credentials to both the Read Domain Sheet and Append to Exported Data Sheet nodes - [ ] Set the correct Google Sheet ID and source tab name containing your domain URLs in Read Domain Sheet - [ ] Set the correct Google Sheet ID and destination tab name in Append to Exported Data Sheet - [ ] Add your Hunter.io API key to the Lookup Domain via Hunter node - [ ] Ensure the source sheet has a column named Domain URL

Requirements