This workflow corresponds to n8n.io template #8923 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
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 →
{
"id": "deeMAaUKlXBrqaiS",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "ELV find generic email (to share)",
"tags": [],
"nodes": [
{
"id": "95bbc44c-e484-4185-96fa-7e6e65a34d25",
"name": "Save results",
"type": "n8n-nodes-base.googleSheets",
"position": [
1152,
-240
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $json.root }}@{{ $json.domain }}",
"Status": "={{ $json.data }}"
},
"schema": [
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1262572795,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1t-sBs3hr3snmNT1i5hykFkmxvuaQjC_r_Nmfly4oN-M/edit#gid=1262572795",
"cachedResultName": "[OutPut] emails"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit?usp=drivesdk",
"cachedResultName": "[N8N template] EmailListVerify: generic email finder"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "210824fa-4c47-4e8a-8a14-cac9c3b27142",
"name": "Get list of domain",
"type": "n8n-nodes-base.googleSheets",
"position": [
192,
-176
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2121105756,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit#gid=2121105756",
"cachedResultName": "[Input] domain"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit?usp=drivesdk",
"cachedResultName": "[N8N template] EmailListVerify: generic email finder"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "8b5905c5-a09c-4732-b26e-4ca7510d2a23",
"name": "Get list of email root",
"type": "n8n-nodes-base.googleSheets",
"position": [
192,
16
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit#gid=0",
"cachedResultName": "[Input] partern"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit?usp=drivesdk",
"cachedResultName": "[N8N template] EmailListVerify: generic email finder"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "11e24bac-08a2-4797-825a-954b0a20df25",
"name": "Create email candidates",
"type": "n8n-nodes-base.merge",
"position": [
464,
-80
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineAll"
},
"typeVersion": 3.2
},
{
"id": "5c80b5ee-6d35-41b0-865b-3b73d99f0b90",
"name": "Use EmailListVerify API to check if email is valid",
"type": "n8n-nodes-base.httpRequest",
"position": [
720,
-80
],
"parameters": {
"url": "https://api.emaillistverify.com/api/verifyEmail",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "email",
"value": "={{ $json.root }}@{{ $json.domain }}"
}
]
}
},
"credentials": {
"httpQueryAuth": {
"name": "<your credential>"
},
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "d86dba88-75b0-4911-a790-eb07accc9b7f",
"name": "Combine results",
"type": "n8n-nodes-base.merge",
"position": [
992,
-240
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineByPosition"
},
"typeVersion": 3.2
},
{
"id": "8f71141f-9bc9-4c88-af0c-e5886d426c2a",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-112,
48
],
"parameters": {},
"typeVersion": 1
},
{
"id": "49de2a94-1444-447f-abca-a96d86c20d8c",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
128,
-384
],
"parameters": {
"height": 624,
"content": "## Get inputs\nMake a copy of [the template](https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit?usp=sharing)\n\nReplace the target spreadsheet with your copy of the template"
},
"typeVersion": 1
},
{
"id": "4edb37d7-3f5e-4f38-839f-d3517acfd10e",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-384
],
"parameters": {
"height": 624,
"content": "## Generate email candidates\nCombine each domain and email root to generate email candidates"
},
"typeVersion": 1
},
{
"id": "35bd07e5-ad0c-4a26-8b95-9ae3dabc716d",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
656,
-384
],
"parameters": {
"height": 624,
"content": "## Check if email is valid\nUse EmailListVerify API to check if each email is valid.\nAdd you [EmailListVerify API key](https://app.emaillistverify.com/api?utm_source=n8n&utm_medium=referral&utm_campaign=genericEmailFinder).\n"
},
"typeVersion": 1
},
{
"id": "a2ed1db7-d036-4d00-b576-4e4dbf8a0908",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
928,
-384
],
"parameters": {
"width": 352,
"height": 624,
"content": "## Save results \nReplace the target spreadsheet with your copy of the template"
},
"typeVersion": 1
},
{
"id": "d9f2ae53-e467-470c-9991-58985d7780c3",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-176,
-624
],
"parameters": {
"color": 3,
"height": 592,
"content": "## Read me \nThis workflow will look for generic email like contact@ or accounting@\n\n**1:** Make a copy of the [GoogleSheet template](https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit?gid=1262572795#gid=1262572795)\n**2:** In \"[Input] pattern\" sheet write the root email you want to check like contact or accounting\n**3:** In \"[Input] domain\" put the domain for which you want to find email addresses. Write domain without http or www in front.\n**4:** Add your [EmailListVerify API key](https://app.emaillistverify.com/api?utm_source=n8n&utm_medium=referral&utm_campaign=genericEmailFinder) to setting to the 3rd step\n**5:** Update google sheet node to point to your copy of the template\n**6:** Trigger the workflow"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "180b9911-ff6f-4a42-8a50-5c7bc37210a7",
"connections": {
"Combine results": {
"main": [
[
{
"node": "Save results",
"type": "main",
"index": 0
}
]
]
},
"Get list of domain": {
"main": [
[
{
"node": "Create email candidates",
"type": "main",
"index": 0
}
]
]
},
"Get list of email root": {
"main": [
[
{
"node": "Create email candidates",
"type": "main",
"index": 1
}
]
]
},
"Create email candidates": {
"main": [
[
{
"node": "Use EmailListVerify API to check if email is valid",
"type": "main",
"index": 0
},
{
"node": "Combine results",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Get list of domain",
"type": "main",
"index": 0
},
{
"node": "Get list of email root",
"type": "main",
"index": 0
}
]
]
},
"Use EmailListVerify API to check if email is valid": {
"main": [
[
{
"node": "Combine results",
"type": "main",
"index": 1
}
]
]
}
}
}
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.
googleSheetsOAuth2ApihttpHeaderAuthhttpQueryAuth
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Growth teams and SDR targeting small companies.
Source: https://n8n.io/workflows/8923/ — 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.
This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet
🔥 March Sale – n8n Community Members Get ideoGener8r for Just $27! (Reg. $47) Use Coupon Code: (Valid until 3/31/2025 for n8n community members)
📄 Documentation: Notion Guide