Davide Boizza This workflow corresponds to n8n.io template #10213 — 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": "8WkZpiRCYlakSpNY",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Find email by company name with Anymail Finder",
"tags": [],
"nodes": [
{
"id": "24f96fe4-0e5f-4127-90d9-754ef254a48e",
"name": "Manual Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-704,
-448
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1eb2df5c-ad7f-43c7-bb51-26cac9111075",
"name": "Get Leads",
"type": "n8n-nodes-base.googleSheets",
"position": [
-496,
-448
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupColumn": "PROCESSING"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=drivesdk",
"cachedResultName": "Find Email by Company"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "1b4cb64a-d43b-4063-8884-e163fcd93c46",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-288,
-448
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "a6da4992-d53b-4e09-9deb-4ce0aeaa79fe",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
-704
],
"parameters": {
"width": 608,
"height": 144,
"content": "- Clone this [sheet](https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=sharing)\n- Get your [Anymail Finder](https://anymailfinder.com) API Key (FREE Trial)\n- In \"Email finder\" node Create a credential named \u201cAnymail Finder\u201d of type HTTP Header Auth. In the \u201cName\u201d field, enter \"Authorization\" and in the \u201cValue\u201d field, enter your Anymail Finder API key (in the format YOUR_API_KEY)"
},
"typeVersion": 1
},
{
"id": "539a8f1c-bdcd-4450-bd63-a4845063d6bf",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
272,
-464
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "valid",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e2d035e7-353e-4c3e-a82a-5ab3ad5de400",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.email_status }}",
"rightValue": "valid"
}
]
},
"renameOutput": true
},
{
"outputKey": "risky",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7440ef17-b184-49f9-bc92-0ec289e11ccf",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.email_status }}",
"rightValue": "risky"
}
]
},
"renameOutput": true
},
{
"outputKey": "not found",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7eec38fb-005c-4ea7-9b7b-2e39e0ac4156",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "6259403f-2327-438d-97e1-7b4a8a369158",
"name": "Email found",
"type": "n8n-nodes-base.googleSheets",
"position": [
576,
-496
],
"parameters": {
"columns": {
"value": {
"EMAIL": "={{JSON.stringify( $json.emails) }}",
"PROCESSING": "x",
"row_number": "={{ $('Loop Over Items').item.json.row_number }}"
},
"schema": [
{
"id": "COMPANY NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "COMPANY NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "WEBSITE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "WEBSITE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PROCESSING",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PROCESSING",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=drivesdk",
"cachedResultName": "Find Email by Company"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "02a1ec6c-4e58-44c5-b7ba-891e4065594d",
"name": "Email not found",
"type": "n8n-nodes-base.googleSheets",
"position": [
784,
-416
],
"parameters": {
"columns": {
"value": {
"EMAIL": "=",
"PROCESSING": "x",
"row_number": "={{ $('Loop Over Items').item.json.row_number }}"
},
"schema": [
{
"id": "COMPANY NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "COMPANY NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "WEBSITE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "WEBSITE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PROCESSING",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PROCESSING",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=drivesdk",
"cachedResultName": "Find Email by Company"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "2f24945d-a082-474b-86bf-d552f6728289",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
-528
],
"parameters": {
"width": 224,
"height": 224,
"content": "Classify if email is valid, risky and not found."
},
"typeVersion": 1
},
{
"id": "8dad63c6-d171-4895-86f0-65e7d73f56ae",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-48,
-528
],
"parameters": {
"width": 224,
"height": 224,
"content": "Find email"
},
"typeVersion": 1
},
{
"id": "4e1ff1f3-c0c8-406b-bd79-d008fabac373",
"name": "Email finder",
"type": "n8n-nodes-base.httpRequest",
"notes": "This node sends the request to Anymailfinder.\nMake sure you've connected your API key in the credentials (HTTP Header Auth).",
"onError": "continueErrorOutput",
"position": [
0,
-432
],
"parameters": {
"url": "https://api.anymailfinder.com/v5.1/find-email/company",
"method": "POST",
"options": {
"timeout": 180000
},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "domain",
"value": "={{ $json[\"WEBSITE\"] }}"
},
{
"name": "company_name",
"value": "={{ $json[\"COMPANY NAME\"] }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 4.2
},
{
"id": "3a741450-561c-49de-bb53-988b7afa2cb6",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
-896
],
"parameters": {
"color": 3,
"width": 608,
"content": "## Find email address by company with Anymail Finder\n\nThis automation **retrieves company information** from a Google Sheet, uses the Anymail Finder API to **discover email addresses associated with each company**, and then writes the results (including the email status) back into the same Google Sheet."
},
"typeVersion": 1
},
{
"id": "2bd1b49d-7f98-4a80-aa07-48413a896ed6",
"name": "Send Alert",
"type": "n8n-nodes-base.telegram",
"position": [
1008,
-416
],
"parameters": {
"text": "Alert! Email not found",
"chatId": "XXXXXX",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.2
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "33bcd6d5-9863-4fcb-bae2-95cbc800c354",
"connections": {
"Switch": {
"main": [
[
{
"node": "Email found",
"type": "main",
"index": 0
}
],
[
{
"node": "Email found",
"type": "main",
"index": 0
}
],
[
{
"node": "Email not found",
"type": "main",
"index": 0
}
]
]
},
"Get Leads": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Send Alert": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Email found": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Email finder": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"Manual Trigger": {
"main": [
[
{
"node": "Get Leads",
"type": "main",
"index": 0
}
]
]
},
"Email not found": {
"main": [
[
{
"node": "Send Alert",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Email finder",
"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.
googleSheetsOAuth2ApihttpHeaderAuthtelegramApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This automation retrieves company information from a Google Sheet, uses the Anymail Finder API to discover email addresses associated with each company, and then writes the results (including the email status) back into the same Google Sheet and send alert on Telegram.
Source: https://n8n.io/workflows/10213/ — 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.
checkProcess(old). Uses googleSheets, httpRequest, telegram, @n-octo-n/n8n-nodes-json-database. Event-driven trigger; 40 nodes.
Google Sheets, HTTP Request, Telegram +3
checkProcess. Uses googleSheets, httpRequest, telegram, @n-octo-n/n8n-nodes-json-database. Event-driven trigger; 40 nodes.
Google Sheets, HTTP Request, Telegram +3
This template monitors Google Drive folder for new files, extracts text from PDFs, images, text files, CSVs, and Google Docs., reads images with meta/llama-3.2-11b-vision-instruct, structures the resu
Google Drive Trigger, Google Drive, Google Docs +3
This workflow provides a complete solution for handling Telegram Stars payments, invoicing and refunds using n8n. It automates the process of sending invoices, managing pre-checkout approvals, recordi
HTTP Request, Execute Workflow Trigger, Google Sheets +2
clients kept booking meetings during my prayer times. i'd either miss a prayer or scramble to reschedule. the problem wasn't the clients — it was that my calendar had no blocked windows for salah. i n
Telegram Trigger, HTTP Request, Google Calendar +3