Allan Vaccarizi This workflow corresponds to n8n.io template #14453 — we link there as the canonical source.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "2cdf4407-3459-444d-becf-ce972f90a5c1",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
1472,
384
],
"parameters": {
"color": 4,
"width": 1152,
"content": "# Google sheets Template\n\n## https://docs.google.com/spreadsheets/d/180ca70GWcm-BpM8U2ygS6jqhCTE_avx93Kd4d0USe5A"
},
"typeVersion": 1
},
{
"id": "b3d6bb2b-cb0f-42ab-ab18-a501b67540fa",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1472,
624
],
"parameters": {
"color": 7,
"height": 336,
"content": "## Manual workflow trigger\n\nStarts the workflow when the user manually clicks 'Execute workflow' in the n8n editor."
},
"typeVersion": 1
},
{
"id": "ecfc69ba-351f-4dfe-a660-15c30521af95",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1744,
640
],
"parameters": {
"color": 7,
"width": 384,
"height": 320,
"content": "## Fetch rows and enrich with Hunter\n\nReads rows from a source Google Sheet, then sends each row to Hunter.io to look up email addresses or domain contact data."
},
"typeVersion": 1
},
{
"id": "f58ea6f9-0c4c-43cd-a318-04b48908c3ff",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
2160,
592
],
"parameters": {
"color": 7,
"height": 384,
"content": "## Save enriched results to sheet\n\nAppends the Hunter-enriched contact data as new rows into a destination Google Sheet."
},
"typeVersion": 1
},
{
"id": "208640d2-e019-4342-bca3-dd821002e266",
"name": "When Manually Triggered",
"type": "n8n-nodes-base.manualTrigger",
"position": [
1520,
800
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e4b79b8b-6ac4-4e8e-8b33-17af04867eb4",
"name": "Find Emails via Hunter",
"type": "n8n-nodes-base.hunter",
"position": [
1984,
800
],
"parameters": {
"limit": 10,
"domain": "=",
"filters": {}
},
"credentials": {
"hunterApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "5b94ba12-ffcd-4b12-8379-98ac5673b391",
"name": "Read Domains from Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1792,
800
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/180ca70GWcm-BpM8U2ygS6jqhCTE_avx93Kd4d0USe5A/edit#gid=0",
"cachedResultName": "Domain"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/180ca70GWcm-BpM8U2ygS6jqhCTE_avx93Kd4d0USe5A"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "23c57c9a-4a25-4865-b2ac-8d34aa0c2aa9",
"name": "Append Exported Data to Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2208,
800
],
"parameters": {
"columns": {
"value": {
"Twitter": "=",
"Linkedin": "=",
"Position": "=",
"Last name": "=",
"Seniority": "=",
"Confidence": "=",
"First name": "=",
"Departement": "=",
"Mail adress": "=",
"Phone number": "='",
"Position Raw": "="
},
"schema": [
{
"id": "Mail adress",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Mail adress",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Confidence",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Confidence",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "First name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "First name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Last name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Phone number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Linkedin",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Position",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Position Raw",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Position Raw",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Seniority",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Seniority",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Departement",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Departement",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Twitter",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Twitter",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 762290939,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/180ca70GWcm-BpM8U2ygS6jqhCTE_avx93Kd4d0USe5A/edit#gid=762290939",
"cachedResultName": "Exported data"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/180ca70GWcm-BpM8U2ygS6jqhCTE_avx93Kd4d0USe5A"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "dcf2a29e-a5bf-48d1-a1ca-734fbda3e99f",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
944,
624
],
"parameters": {
"width": 480,
"height": 720,
"content": "## Domain url to exported data\n\n### How it works\n\n1. The workflow is triggered manually by clicking 'Execute workflow'.\n2. It reads rows from a Google Sheet to retrieve a list of domains or companies to enrich.\n3. Each row is passed to Hunter.io to find associated email addresses or contact data.\n4. The enriched results are appended as new rows back into a Google Sheet.\n\n### Setup steps\n\n- - [ ] Connect your **Google Sheets** credentials to both the 'Get row(s) in sheet' and 'Append row in sheet' nodes.\n- - [ ] Configure the source Google Sheet URL and sheet name in the 'Get row(s) in sheet' node.\n- - [ ] Connect your **Hunter.io** API credentials to the 'Hunter' node and configure the lookup type (e.g., domain search or email finder).\n- - [ ] Configure the destination Google Sheet URL and column mapping in the 'Append row in sheet' node.\n\n### Customization\n\nYou can swap the manual trigger for a scheduled trigger (e.g., daily) to run enrichment automatically. You can also add a filter node between Hunter and the append step to only save rows where valid emails were found."
},
"typeVersion": 1
},
{
"id": "3c69a910-85af-437a-ba18-71fec2195c13",
"name": "Sticky Note16",
"type": "n8n-nodes-base.stickyNote",
"position": [
2480,
576
],
"parameters": {
"width": 1024,
"height": 400,
"content": ""
},
"typeVersion": 1
},
{
"id": "458fde59-13b1-4b6f-bd94-e3b79f9504b7",
"name": "Sticky Note17",
"type": "n8n-nodes-base.stickyNote",
"position": [
2480,
1024
],
"parameters": {
"color": 7,
"width": 1024,
"height": 240,
"content": "## Need more advanced automation solutions? Contact us for custom enterprise workflows!\n\n# Growth-AI.fr\n\n## https://www.linkedin.com/in/allanvaccarizi/\n## https://www.linkedin.com/in/hugo-marinier-%F0%9F%A7%B2-6537b633/"
},
"typeVersion": 1
}
],
"connections": {
"Find Emails via Hunter": {
"main": [
[
{
"node": "Append Exported Data to Sheets",
"type": "main",
"index": 0
}
]
]
},
"When Manually Triggered": {
"main": [
[
{
"node": "Read Domains from Sheets",
"type": "main",
"index": 0
}
]
]
},
"Read Domains from Sheets": {
"main": [
[
{
"node": "Find Emails via Hunter",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApihunterApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
📺 Full walkthrough video: https://youtu.be/uk-mJRgYnfs
Source: https://n8n.io/workflows/14453/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Streamline your email list hygiene with this automated validation workflow that monitors Google Sheets for new email entries and instantly verifies their deliverability. Perfect for maintaining clean
Google Sheets Trigger, HTTP Request, Google Sheets +1
This template is ideal for B2B founders, solopreneurs, growth marketers, SDRs, or anyone looking to scale their lead generation and enrichment with no-code tools to low-code tools.
Google Sheets, OpenRouter Chat, Chain Llm +4
This guide will walk you through setting up your n8n workflow. By the end, you'll have a fully automated system for managing your recruitment pipeline.
Google Calendar Trigger, Slack, HTTP Request +4
Batch_Call. Uses googleDrive, httpRequest, stopAndError, googleSheets. Event-driven trigger; 28 nodes.
Google Drive, HTTP Request, Stop And Error +1
This n8n workflow automatically generates TikTok/Reels-ready talking head videos from scratch. You provide a topic and intention, and the workflow handles everything: scriptwriting, avatar generation,
HTTP Request, N8N Nodes Veed, Google Drive +1