Oriol Seguí This workflow corresponds to n8n.io template #9296 — we link there as the canonical source.
This workflow follows the Gmail → Google Sheets 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 →
{
"nodes": [
{
"id": "405c9eb3-4935-4bce-8535-c7145eb923ee",
"name": "Iterar P\u00e1ginas",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-940,
940
],
"parameters": {},
"typeVersion": 3
},
{
"id": "71c3059f-eb20-4534-8b20-7142436821d0",
"name": "Split Out2",
"type": "n8n-nodes-base.splitOut",
"onError": "continueErrorOutput",
"position": [
-920,
560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "abb16e31-affb-4e2f-91c6-827c8058c3fd",
"name": "Edit Fields1",
"type": "n8n-nodes-base.set",
"position": [
-640,
1060
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "cacaf3cb-35de-4f4c-8163-65006045af76",
"name": "OpenAI1",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-260,
1060
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "12882dff-b5a1-4a36-b036-afc2a5c2f0b7",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
80,
1060
],
"parameters": {},
"typeVersion": 2
},
{
"id": "32f6dd34-7f01-46f2-8532-e06dd6d0eddd",
"name": "LANGUAGE",
"type": "n8n-nodes-base.set",
"position": [
-760,
100
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "cf5111ad-fac8-412b-a81b-80d4b7d63001",
"name": "Maping Sitemap",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
160,
100
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "d354a2e4-adfb-4f65-b990-686bbab717e2",
"name": "XML1",
"type": "n8n-nodes-base.xml",
"position": [
340,
160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2e3d7ca5-99c2-473f-ba1b-aa8f92c08414",
"name": "Split Out8",
"type": "n8n-nodes-base.splitOut",
"position": [
-440,
860
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d05b2a0b-7f4c-4a50-9f7b-477b6c31b017",
"name": "To html",
"type": "n8n-nodes-base.code",
"position": [
-160,
860
],
"parameters": {},
"typeVersion": 2
},
{
"id": "fc902b64-326b-46a1-8c3d-4aa19f3df7d1",
"name": "Html to JSON",
"type": "n8n-nodes-base.code",
"position": [
240,
940
],
"parameters": {},
"typeVersion": 2
},
{
"id": "12f847db-9a8c-4f23-8ed9-e5d8b0397c90",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
640,
940
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "6e51c3c6-684d-4a9a-862b-8736474b6a15",
"name": "Split Out10",
"type": "n8n-nodes-base.splitOut",
"position": [
440,
940
],
"parameters": {},
"typeVersion": 1
},
{
"id": "edd2b88d-0cd0-434f-a980-466903dd560d",
"name": "HTML format viewer",
"type": "n8n-nodes-base.html",
"position": [
240,
760
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6a3ed4a5-6fe8-407c-aa6e-ac46ac5baee4",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b74286f1-7f13-4896-8d56-268b3daf7be2",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1420,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fc7afe86-bcd5-4c5f-aadf-4069987e4604",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7f868c33-62e2-48cc-a110-778aca100647",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
940
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "95bc1147-ef3f-4233-9948-0b0e15cb4ad4",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c1d154d1-e0df-42e6-bdb6-e3e795377109",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b251939f-59b6-4157-b8ba-53864044214b",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1760,
560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0b84fe7a-40d6-451a-958b-047751c29b86",
"name": "Eliminar Webs Duplicadas",
"type": "n8n-nodes-base.removeDuplicates",
"notes": "En caso de haber duplicados o sitemap mal hecho",
"position": [
-300,
560
],
"parameters": {},
"typeVersion": 2
},
{
"id": "0e04ec90-f9d9-499e-822b-c7468689f119",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
820,
640
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e266450e-0efa-4736-a0dc-8d1601739144",
"name": "Respond to Webhook",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
460,
760
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "0e26ee0e-537a-48a3-a714-f51c3764fac5",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"notes": "using: pag=example.com\n\nReal example:\nhttps://yourspace.app.n8n.cloud/webhook-test/bbdf9cca-e5f4-4bae-afb1-a893ffb51b18?pag=onlineseoscan.com",
"position": [
-1220,
180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "08724753-a7f0-42b4-98a8-27218351d045",
"name": "MANUAL",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1220,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "761f8aec-0d4b-4f13-8f09-944b3cc2eb1b",
"name": "UA Rotativo1",
"type": "n8n-nodes-base.code",
"position": [
-580,
100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "2276dc45-424d-402c-91f9-ca2407b02c5f",
"name": "URL WEB",
"type": "n8n-nodes-base.set",
"position": [
-1020,
0
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "b4b162cd-89f3-4714-b1d3-b4978dcf294c",
"name": "Method detect",
"type": "n8n-nodes-base.code",
"position": [
-400,
100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f6281ede-c275-41c2-a07e-4f63db8af903",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1220,
-320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8301d1c6-eb47-475f-a52a-20ee9cae1f2a",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1620,
320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9ce090a3-d88f-4dc3-bd14-b1e83176806c",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1780,
100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c9cebdbc-439c-483c-a6b3-48ee40e23017",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1580,
-280
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ef1e4f68-7fec-4a6f-a29f-777746bf3035",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2800,
-300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "394ef001-cee7-4ab7-81cb-1ece312c5215",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2800,
-120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "45a80d37-d6a3-44c5-ad8e-a34eb68c9810",
"name": "Req Error",
"type": "n8n-nodes-base.stopAndError",
"position": [
-20,
-40
],
"parameters": {},
"typeVersion": 1
},
{
"id": "91e46b5c-bb1f-402c-b1cb-bd82cf6ef11d",
"name": "Sitemap Error",
"type": "n8n-nodes-base.stopAndError",
"position": [
340,
0
],
"parameters": {},
"executeOnce": false,
"typeVersion": 1
},
{
"id": "93ebaaa2-a7fb-4e54-9de8-98a745ce08b7",
"name": "Req robots",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
-220,
100
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "dbb51e35-fb38-468f-8a63-8aa35e6d4abc",
"name": "extract sitemap url",
"type": "n8n-nodes-base.code",
"position": [
-20,
100
],
"parameters": {},
"typeVersion": 2
},
{
"id": "638b530d-3e1e-402f-8fab-0da1b649cc0c",
"name": "Req Error1",
"type": "n8n-nodes-base.stopAndError",
"position": [
-620,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6df241e2-ea7e-43ba-bc9a-51e6e6828b84",
"name": "Sticky Note14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
380
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ebfcc63c-ec98-4563-9d66-a9bfb391e151",
"name": "Filter URL",
"type": "n8n-nodes-base.filter",
"position": [
-720,
560
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "45065db2-c50a-4c82-a35b-1bea939cd791",
"name": "Filter URL Intern",
"type": "n8n-nodes-base.filter",
"notes": "Filter sitemap.xml, usa ese filtro para excluir urls del sitemap",
"position": [
-500,
560
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "202e2e8f-a6c7-4f8b-80c2-5dffabc93d4c",
"name": "Send Results",
"type": "n8n-nodes-base.gmail",
"position": [
240,
580
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "0d871973-a01f-48d7-a26e-503a059321be",
"name": "Obtener Contenido Web",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
-440,
1060
],
"parameters": {},
"typeVersion": 4.2
}
],
"connections": {
"Code": {
"main": [
[
{
"node": "Iterar P\u00e1ginas",
"type": "main",
"index": 0
}
]
]
},
"XML1": {
"main": [
[
{
"node": "Split Out2",
"type": "main",
"index": 0
}
]
]
},
"MANUAL": {
"main": [
[
{
"node": "URL WEB",
"type": "main",
"index": 0
}
]
]
},
"OpenAI1": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"To html": {
"main": [
[
{
"node": "Send Results",
"type": "main",
"index": 0
},
{
"node": "Html to JSON",
"type": "main",
"index": 0
},
{
"node": "HTML format viewer",
"type": "main",
"index": 0
}
]
]
},
"URL WEB": {
"main": [
[
{
"node": "LANGUAGE",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "LANGUAGE",
"type": "main",
"index": 0
}
]
]
},
"LANGUAGE": {
"main": [
[
{
"node": "UA Rotativo1",
"type": "main",
"index": 0
}
]
]
},
"Filter URL": {
"main": [
[
{
"node": "Filter URL Intern",
"type": "main",
"index": 0
}
]
]
},
"Req robots": {
"main": [
[
{
"node": "extract sitemap url",
"type": "main",
"index": 0
}
],
[
{
"node": "Req Error",
"type": "main",
"index": 0
}
]
]
},
"Split Out2": {
"main": [
[
{
"node": "Filter URL",
"type": "main",
"index": 0
}
],
[
{
"node": "Req Error1",
"type": "main",
"index": 0
}
]
]
},
"Split Out8": {
"main": [
[
{
"node": "To html",
"type": "main",
"index": 0
}
]
]
},
"Split Out10": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Obtener Contenido Web",
"type": "main",
"index": 0
}
]
]
},
"Html to JSON": {
"main": [
[
{
"node": "Split Out10",
"type": "main",
"index": 0
}
]
]
},
"UA Rotativo1": {
"main": [
[
{
"node": "Method detect",
"type": "main",
"index": 0
}
]
]
},
"Method detect": {
"main": [
[
{
"node": "Req robots",
"type": "main",
"index": 0
}
]
]
},
"Maping Sitemap": {
"main": [
[
{
"node": "XML1",
"type": "main",
"index": 0
}
],
[
{
"node": "Sitemap Error",
"type": "main",
"index": 0
}
]
]
},
"Iterar P\u00e1ginas": {
"main": [
[
{
"node": "Split Out8",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Filter URL Intern": {
"main": [
[
{
"node": "Eliminar Webs Duplicadas",
"type": "main",
"index": 0
}
]
]
},
"HTML format viewer": {
"main": [
[
{
"node": "Respond to Webhook",
"type": "main",
"index": 0
}
]
]
},
"extract sitemap url": {
"main": [
[
{
"node": "Maping Sitemap",
"type": "main",
"index": 0
}
]
]
},
"Obtener Contenido Web": {
"main": [
[
{
"node": "OpenAI1",
"type": "main",
"index": 0
}
]
]
},
"Eliminar Webs Duplicadas": {
"main": [
[
{
"node": "Iterar P\u00e1ginas",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Instantly map all internal URLs, perform AI-powered (ChatGPT) analysis, and deliver results in HTML via webhook, Google Sheets, or email. All from your own n8n instance!
Source: https://n8n.io/workflows/9296/ — 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.
Watch on Youtube▶️
HTTP Request, Email Send, Google Sheets +3
This workflow is designed for SEO professionals, digital agencies, content creators, and WordPress site owners who want to improve their search engine rankings automatically. It’s also perfect for cur
OpenAI, Google Sheets, XML +3
This n8n workflow automates the process of searching, transcribing, and analyzing product reviews extracted from YouTube videos, generating a clear, ready-to-use report in HTML format and/or email. En
OpenAI, HTTP Request, Gmail +1
Transform your webinar registrations from basic form submissions into a verified, personalized, and premium attendee experience.
N8N Nodes Verifiemail, Slack, Stop And Error +4
This workflow automates the initial screening process for new job applications, freeing up your recruitment team to focus on qualified candidates. It receives applications from a webhook, uses OpenAI
HTTP Request, OpenAI, Google Sheets +2