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": [
{
"parameters": {
"httpMethod": "POST",
"path": "solicitud-automatizacion",
"responseMode": "lastNode",
"options": {}
},
"id": "a80b39e5-72ae-45a3-83a1-bbfdff621487",
"name": "Webhook Form",
"type": "n8n-nodes-base.webhook",
"typeVersion": 2.1,
"position": [
-560,
304
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "companyName",
"value": "MGA Tech Consulting",
"type": "string"
},
{
"id": "id-2",
"name": "companyLogo",
"value": "https://github.com/Mgobeaalcoba/Mgobeaalcoba.github.io/blob/main/assets/images/logo_oscuro.png?raw=true",
"type": "string"
}
]
},
"includeOtherFields": true,
"options": {}
},
"id": "124344e0-7371-4073-9ee8-5aec0774f9a1",
"name": "Workflow Configuration",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-336,
304
]
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "id-1",
"name": "email",
"value": "={{ $json.body.email }}",
"type": "string"
},
{
"id": "id-name",
"name": "nombre",
"value": "={{ $json.body.name }}",
"type": "string"
},
{
"id": "id-empresa",
"name": "empresa",
"value": "={{ $json.body.company }}",
"type": "string"
},
{
"id": "id-rubro",
"name": "rubro",
"value": "={{ $json.body.industry }}",
"type": "string"
},
{
"id": "id-proceso",
"name": "proceso",
"value": "={{ $json.body.problem }}",
"type": "string"
},
{
"id": "id-4",
"name": "fechaRecepcion",
"value": "={{ $now.setZone('America/Argentina/Buenos_Aires').format('yyyy-MM-dd HH:mm:ss') }}",
"type": "string"
}
]
},
"includeOtherFields": true,
"options": {}
},
"id": "86f10661-8251-4d2a-ad2d-5916d5df82bc",
"name": "Preparar Datos",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-128,
304
]
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "{{ GOOGLE_SHEETS_DOCUMENT_ID }}",
"mode": "list",
"cachedResultName": "Suscriptions Web",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{ GOOGLE_SHEETS_DOCUMENT_ID }}/edit"
},
"sheetName": {
"__rl": true,
"value": "{{ GOOGLE_SHEETS_SHEET_ID }}",
"mode": "list",
"cachedResultName": "free_automation",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{ GOOGLE_SHEETS_DOCUMENT_ID }}/edit#gid={{ GOOGLE_SHEETS_SHEET_ID }}"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"ID": "={{ $execution.id }}",
"Email": "={{ $json.email }}",
"Nombre": "={{ $json.nombre }}",
"Empresa": "={{ $json.empresa }}",
"Rubro": "={{ $json.rubro }}",
"Proceso": "={{ $json.proceso }}",
"Fecha de Registro": "={{ $json.fechaRecepcion }}",
"Origen": "={{ $json.body.referrer }}"
},
"matchingColumns": [],
"schema": [
{
"id": "ID",
"displayName": "ID",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Email",
"displayName": "Email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Nombre",
"displayName": "Nombre",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Empresa",
"displayName": "Empresa",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Rubro",
"displayName": "Rubro",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Proceso",
"displayName": "Proceso",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Fecha de Registro",
"displayName": "Fecha de Registro",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Origen",
"displayName": "Origen",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
112,
304
],
"id": "f8ddf50d-887a-4778-89cf-0ba4c1cb6062",
"name": "Append row in sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"sendTo": "={{ $json.Email }}",
"subject": "\u00a1Confirmado! Estamos revisando tu proceso - MGA Tech",
"message": "=<!DOCTYPE html>\n<html>\n<head>\n <style>\n body { font-family: 'Segoe UI', Arial, sans-serif; line-height: 1.6; color: #2c3e50; margin: 0; padding: 0; }\n .container { max-width: 600px; margin: 0 auto; padding: 20px; border: 1px solid #eee; border-radius: 8px; }\n .header { text-align: center; padding: 30px 0; background: linear-gradient(135deg, #0066cc 0%, #003366 100%); border-radius: 8px 8px 0 0; }\n .logo { max-width: 200px; height: auto; filter: brightness(0) invert(1); }\n .content { padding: 30px; background-color: #ffffff; }\n .footer { text-align: center; padding: 20px; color: #888; font-size: 12px; background-color: #f9f9f9; border-radius: 0 0 8px 8px; }\n .button { display: inline-block; padding: 12px 25px; background: #0066cc; color: #ffffff !important; text-decoration: none; border-radius: 5px; font-weight: bold; margin-top: 20px; }\n </style>\n</head>\n<body>\n <div class=\"container\">\n <div class=\"header\">\n <img src=\"{{ $('Workflow Configuration').first().json.companyLogo }}\" alt=\"MGA Tech Consulting\" class=\"logo\">\n </div>\n <div class=\"content\">\n <h2>\u00a1Hola {{ $json['Nombre'] }}!</h2>\n <p>Hemos recibido tu solicitud para automatizar el proceso de: <strong>{{ $json['Proceso'] }}</strong>.</p>\n <p>Nuestro equipo analizar\u00e1 la viabilidad t\u00e9cnica y te contactaremos en menos de 24 horas.</p>\n <center><a href=\"https://mgobeaalcoba.github.io/recursos.html\" class=\"button\">Ver Recursos Gratuitos</a></center>\n </div>\n <div class=\"footer\">\n <p>© 2026 {{ $('Workflow Configuration').first().json.companyName }}. Todos los derechos reservados.</p>\n </div>\n </div>\n</body>\n</html>",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.2,
"position": [
320,
192
],
"id": "530ba6f5-70d5-4958-99a8-4e7a6bdbc798",
"name": "Mail al Usuario",
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"sendTo": "{{ ADMIN_EMAIL }}",
"subject": "=\ud83d\ude80 Nueva Solicitud de Automatizaci\u00f3n: {{ $json['Nombre'] }} ({{ $json.Empresa }})",
"message": "=<!DOCTYPE html>\n<html>\n<head>\n <style>\n body { font-family: 'Segoe UI', Arial, sans-serif; line-height: 1.6; color: #2c3e50; margin: 0; padding: 0; }\n .container { max-width: 600px; margin: 0 auto; border: 1px solid #eee; border-radius: 8px; overflow: hidden; }\n /* Header unificado con el estilo del cliente para resaltar el logo */\n .header { text-align: center; padding: 30px 0; background: linear-gradient(135deg, #0066cc 0%, #003366 100%); color: white; }\n .logo { max-width: 180px; height: auto; }\n .content { padding: 30px; background-color: #ffffff; }\n .data-table { width: 100%; margin: 20px 0; border-collapse: collapse; }\n .data-table td { padding: 12px; border-bottom: 1px solid #f0f0f0; }\n .label { font-weight: bold; color: #0066cc; width: 35%; text-transform: uppercase; font-size: 12px; }\n .button-sheet { \n display: inline-block; \n padding: 14px 30px; \n background-color: #28a745; \n color: #ffffff !important; \n text-decoration: none; \n border-radius: 6px; \n font-weight: bold; \n margin-top: 10px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n }\n </style>\n</head>\n<body>\n <div class=\"container\">\n <div class=\"header\">\n <img src=\"{{ $('Workflow Configuration').first().json.companyLogo }}\" alt=\"MGA Tech\" class=\"logo\">\n <h3 style=\"margin: 10px 0 0 0; opacity: 0.9;\">Nuevo Lead Detectado</h3>\n </div>\n\n <div class=\"content\">\n <table class=\"data-table\">\n <tr><td class=\"label\">Nombre:</td><td>{{ $json['Nombre'] }}</td></tr>\n <tr><td class=\"label\">Empresa:</td><td>{{ $json.Empresa }}</td></tr>\n <tr><td class=\"label\">Rubro:</td><td>{{ $json.Rubro }}</td></tr>\n <tr><td class=\"label\">Proceso:</td><td>{{ $json['Proceso'] }}</td></tr>\n <tr><td class=\"label\">Email:</td><td><a href=\"mailto:{{ $json.Email }}\" style=\"color: #0066cc;\">{{ $json.Email }}</a></td></tr>\n </table>\n \n <center>\n <a href=\"https://docs.google.com/spreadsheets/d/{{ GOOGLE_SHEETS_DOCUMENT_ID }}/edit\" class=\"button-sheet\">\n Gestionar en Google Sheets\n </a>\n </center>\n </div>\n </div>\n</body>\n</html>",
"options": {}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.2,
"position": [
320,
400
],
"id": "b010324f-452b-443c-acf7-8ce62ce8c092",
"name": "Notificaci\u00f3n a Mariano",
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Webhook Form": {
"main": [
[
{
"node": "Workflow Configuration",
"type": "main",
"index": 0
}
]
]
},
"Workflow Configuration": {
"main": [
[
{
"node": "Preparar Datos",
"type": "main",
"index": 0
}
]
]
},
"Preparar Datos": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet": {
"main": [
[
{
"node": "Mail al Usuario",
"type": "main",
"index": 0
},
{
"node": "Notificaci\u00f3n a Mariano",
"type": "main",
"index": 0
}
]
]
}
},
"meta": {
"templateCredsSetupCompleted": true
},
"_documentation": {
"name": "Free Automation Lead Handler",
"version": "1.0",
"description": "Handles leads from the free automation consultation form on the Consulting page. Collects name, email, company, industry and the process to automate. Saves to Google Sheets and sends two emails: a confirmation to the user and a lead notification to the admin.",
"trigger": "Webhook POST \u2014 path: /webhook/solicitud-automatizacion",
"payload_expected": {
"name": "...",
"email": "...",
"company": "...",
"industry": "...",
"problem": "...",
"page": "...",
"referrer": "...",
"language": "...",
"formType": "automatizacion-gratis",
"source": "consulting-page"
},
"placeholders_to_fill": [
"{{ GOOGLE_SHEETS_DOCUMENT_ID }} \u2014 ID of the Google Sheets spreadsheet",
"{{ GOOGLE_SHEETS_SHEET_ID }} \u2014 Numeric ID of the \"free_automation\" sheet tab",
"{{ ADMIN_EMAIL }} \u2014 Admin email for new lead notifications",
"{{ CREDENTIAL_ID }} \u2014 Auto-assigned by n8n",
"{{ WEBHOOK_ID }} \u2014 Auto-assigned by n8n"
],
"credentials_required": [
"Google Sheets OAuth2 (Sheets mariano@mgatc.com)",
"Gmail OAuth2 (mariano@mgatc.com Gmail)"
]
}
}
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.
gmailOAuth2googleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
04-Free-Automation-Lead. Uses googleSheets, gmail. Webhook trigger; 6 nodes.
Source: https://github.com/Mgobeaalcoba/Mgobeaalcoba.github.io/blob/main/docs/automations/04-free-automation-lead.json — 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.
Who is this for? Solo founders, sales teams, and event organizers who need email outreach without expensive tools but want full control from Telegram.
Telegram, Google Sheets, Google Sheets Trigger +2
This workflow acts as an instant SDR that replies to new inbound leads across multiple channels in real time. It first captures and normalizes all incoming lead data into a unified structure. The work
Google Sheets, HTTP Request, Gmail +1
Turn a simple Google Sheet into a lightweight CRM powered by n8n.
Gmail, Google Sheets
A comprehensive n8n workflow template for streamlining influencer application processing with real-time social media data validation, intelligent scoring algorithms, and automated onboarding workflows
N8N Nodes Verifiemail, Stop And Error, HTTP Request +2
Note: This template is designed for both self-hosted and cloud-based n8n instances. The workflow image above shows the complete automation flow.
Google Drive, Google Sheets, Gmail