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 →
{
"updatedAt": "2026-05-08T23:16:35.986Z",
"createdAt": "2026-05-08T18:24:41.988Z",
"id": "tXttNyCL4uyzSKJj",
"name": "Spanish Phone Survey \u2014 Retell Post-Call",
"description": null,
"active": true,
"isArchived": false,
"nodes": [
{
"parameters": {
"httpMethod": "POST",
"path": "retell-survey",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
0,
0
],
"id": "a0000000-0000-4000-8000-000000000001",
"name": "Retell Webhook"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "if-call-analyzed",
"leftValue": "={{ $json.body.event }}",
"rightValue": "call_analyzed",
"operator": {
"type": "string",
"operation": "equals"
}
},
{
"id": "if-call-status-ended",
"leftValue": "={{ $json.body.call.call_status }}",
"rightValue": "ended",
"operator": {
"type": "string",
"operation": "equals"
}
},
{
"id": "if-call-duration-positive",
"leftValue": "={{ $json.body.call.duration_ms }}",
"rightValue": 0,
"operator": {
"type": "number",
"operation": "gt"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
224,
0
],
"id": "a0000000-0000-4000-8000-000000000002",
"name": "Is call_analyzed?"
},
{
"parameters": {
"jsCode": "const body = $input.first().json.body || {};\nconst call = body.call || {};\nconst analysis = call.call_analysis || {};\nconst custom = analysis.custom_analysis_data || {};\n\nconst q1 = Number(custom.q1_escalabilidad_score || 0);\nconst q2 = Number(custom.q2_diferenciacion_score || 0);\nconst q3 = Number(custom.q3_enfoque_score || 0);\nconst q4 = Number(custom.q4_compromiso_score || 0);\nconst total = q1 + q2 + q3 + q4;\n\nlet verdict;\nif (total >= 17) verdict = 'Candidato A (Top)';\nelse if (total >= 13) verdict = 'Candidato B (Apto)';\nelse verdict = 'No Apto';\n\nconst questionsAnswered = Number(custom.questions_answered || 0);\nconst wantsFollowup = Boolean(custom.caller_wants_followup);\n\nconst startTs = call.start_timestamp || Date.now();\nconst tsUtc = new Date(startTs).toISOString();\nconst tsBogota = new Date(startTs).toLocaleString('es-CO', { timeZone: 'America/Bogota', hour12: false });\n\nconst candidateName = (custom.candidate_name || '').trim() || '(no proporcionado)';\nconst candidateCompany = (custom.candidate_company || '').trim() || '(no proporcionada)';\nconst summary = analysis.call_summary || '';\nconst sentiment = analysis.user_sentiment || '';\nconst recordingUrl = call.recording_url || '';\nconst transcriptHint = call.public_log_url || '';\n\nconst row = (label, score, obs) => `\n <tr>\n <td style=\"padding:6px 10px;border:1px solid #ddd;\"><strong>${label}</strong></td>\n <td style=\"padding:6px 10px;border:1px solid #ddd;text-align:center;\">${score}/5</td>\n <td style=\"padding:6px 10px;border:1px solid #ddd;\">${obs || '<em>(sin observaci\u00f3n)</em>'}</td>\n </tr>`;\n\nconst emailHtml = `<!DOCTYPE html>\n<html lang=\"es\"><body style=\"font-family:-apple-system,Segoe UI,Helvetica,Arial,sans-serif;max-width:680px;margin:0 auto;padding:20px;color:#222;\">\n <h2 style=\"margin:0 0 4px 0;\">Encuesta \u2014 Programa de Exportaci\u00f3n de Servicios Modernos</h2>\n <p style=\"margin:0 0 16px 0;color:#666;\">${tsBogota} (Bogot\u00e1) \u00b7 ${call.call_id || ''}</p>\n\n <table style=\"width:100%;border-collapse:collapse;margin-bottom:16px;\">\n <tr><td style=\"padding:6px 10px;border:1px solid #ddd;background:#f7f7f7;width:200px;\"><strong>Candidato</strong></td><td style=\"padding:6px 10px;border:1px solid #ddd;\">${candidateName}</td></tr>\n <tr><td style=\"padding:6px 10px;border:1px solid #ddd;background:#f7f7f7;\"><strong>Empresa</strong></td><td style=\"padding:6px 10px;border:1px solid #ddd;\">${candidateCompany}</td></tr>\n <tr><td style=\"padding:6px 10px;border:1px solid #ddd;background:#f7f7f7;\"><strong>Preguntas respondidas</strong></td><td style=\"padding:6px 10px;border:1px solid #ddd;\">${questionsAnswered} / 4</td></tr>\n <tr><td style=\"padding:6px 10px;border:1px solid #ddd;background:#f7f7f7;\"><strong>Pidi\u00f3 seguimiento</strong></td><td style=\"padding:6px 10px;border:1px solid #ddd;\">${wantsFollowup ? 'S\u00ed' : 'No'}</td></tr>\n </table>\n\n <h3 style=\"margin:24px 0 8px 0;\">Matriz de Evaluaci\u00f3n</h3>\n <table style=\"width:100%;border-collapse:collapse;\">\n <thead><tr><th style=\"padding:6px 10px;border:1px solid #ddd;background:#f0f0f0;text-align:left;\">Pregunta</th><th style=\"padding:6px 10px;border:1px solid #ddd;background:#f0f0f0;width:80px;\">Puntaje</th><th style=\"padding:6px 10px;border:1px solid #ddd;background:#f0f0f0;text-align:left;\">Observaci\u00f3n</th></tr></thead>\n <tbody>\n ${row('1. Escalabilidad', q1, custom.q1_escalabilidad_obs)}\n ${row('2. Diferenciaci\u00f3n', q2, custom.q2_diferenciacion_obs)}\n ${row('3. Enfoque comercial', q3, custom.q3_enfoque_obs)}\n ${row('4. Compromiso', q4, custom.q4_compromiso_obs)}\n <tr><td style=\"padding:8px 10px;border:1px solid #ddd;background:#f7f7f7;\"><strong>TOTAL</strong></td><td style=\"padding:8px 10px;border:1px solid #ddd;text-align:center;background:#f7f7f7;\"><strong>${total}/20</strong></td><td style=\"padding:8px 10px;border:1px solid #ddd;background:#f7f7f7;\"><strong>${verdict}</strong></td></tr>\n </tbody>\n </table>\n\n <h3 style=\"margin:24px 0 8px 0;\">Resumen de la llamada</h3>\n <p style=\"line-height:1.5;margin:0 0 8px 0;\">${summary || '<em>(sin resumen)</em>'}</p>\n <p style=\"margin:0 0 16px 0;\"><strong>Sentimiento:</strong> ${sentiment || '(no clasificado)'}</p>\n\n ${recordingUrl ? `<p><a href=\"${recordingUrl}\">\u25b6 Escuchar la grabaci\u00f3n</a></p>` : ''}\n ${transcriptHint ? `<p><a href=\"${transcriptHint}\">\ud83d\udcdd Ver transcripci\u00f3n y log</a></p>` : ''}\n</body></html>`;\n\nconst emailSubject = `[Encuesta] ${verdict} \u2014 ${candidateName} / ${candidateCompany}`;\n\nreturn [{\n json: {\n timestamp_utc: tsUtc,\n timestamp_bogota: tsBogota,\n call_id: call.call_id || '',\n candidate_name: candidateName,\n candidate_company: candidateCompany,\n q1_escalabilidad: q1,\n q2_diferenciacion: q2,\n q3_enfoque: q3,\n q4_compromiso: q4,\n total,\n verdict,\n questions_answered: questionsAnswered,\n wants_followup: wantsFollowup ? 'S\u00ed' : 'No',\n summary,\n sentiment,\n recording_url: recordingUrl,\n email_subject: emailSubject,\n email_html: emailHtml,\n }\n}];"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
448,
-128
],
"id": "a0000000-0000-4000-8000-000000000003",
"name": "Compute Verdict"
},
{
"parameters": {
"sendTo": "jesus@datasmarts.net, raiz@thefamilyfirst.co",
"subject": "={{ $json.email_subject }}",
"message": "={{ $json.email_html }}",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.2,
"position": [
672,
-240
],
"id": "a0000000-0000-4000-8000-000000000004",
"name": "Send Email",
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1dZFeYwBPxReBuN0nS_yXqSrtx_9lAvwVZlthvdH19fo",
"mode": "list",
"cachedResultName": "Spanish Phone Survey \u2014 Demo Log",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dZFeYwBPxReBuN0nS_yXqSrtx_9lAvwVZlthvdH19fo/edit"
},
"sheetName": {
"__rl": true,
"value": "Calls",
"mode": "name"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"timestamp_utc": "={{ $('Compute Verdict').item.json.timestamp_utc }}",
"timestamp_bogota": "={{ $('Compute Verdict').item.json.timestamp_bogota }}",
"call_id": "={{ $('Compute Verdict').item.json.call_id }}",
"candidate_name": "={{ $('Compute Verdict').item.json.candidate_name }}",
"candidate_company": "={{ $('Compute Verdict').item.json.candidate_company }}",
"q1_escalabilidad": "={{ $('Compute Verdict').item.json.q1_escalabilidad }}",
"q2_diferenciacion": "={{ $('Compute Verdict').item.json.q2_diferenciacion }}",
"q3_enfoque": "={{ $('Compute Verdict').item.json.q3_enfoque }}",
"q4_compromiso": "={{ $('Compute Verdict').item.json.q4_compromiso }}",
"total": "={{ $('Compute Verdict').item.json.total }}",
"verdict": "={{ $('Compute Verdict').item.json.verdict }}",
"questions_answered": "={{ $('Compute Verdict').item.json.questions_answered }}",
"wants_followup": "={{ $('Compute Verdict').item.json.wants_followup }}",
"summary": "={{ $('Compute Verdict').item.json.summary }}",
"sentiment": "={{ $('Compute Verdict').item.json.sentiment }}",
"recording_url": "={{ $('Compute Verdict').item.json.recording_url }}"
},
"matchingColumns": [],
"schema": [
{
"id": "timestamp_utc",
"displayName": "timestamp_utc",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "timestamp_bogota",
"displayName": "timestamp_bogota",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "call_id",
"displayName": "call_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "candidate_name",
"displayName": "candidate_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "candidate_company",
"displayName": "candidate_company",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "q1_escalabilidad",
"displayName": "q1_escalabilidad",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "q2_diferenciacion",
"displayName": "q2_diferenciacion",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "q3_enfoque",
"displayName": "q3_enfoque",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "q4_compromiso",
"displayName": "q4_compromiso",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "total",
"displayName": "total",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "verdict",
"displayName": "verdict",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "questions_answered",
"displayName": "questions_answered",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "wants_followup",
"displayName": "wants_followup",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "summary",
"displayName": "summary",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "sentiment",
"displayName": "sentiment",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "recording_url",
"displayName": "recording_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
880,
-240
],
"id": "a0000000-0000-4000-8000-000000000005",
"name": "Append to Sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
}
],
"connections": {
"Retell Webhook": {
"main": [
[
{
"node": "Is call_analyzed?",
"type": "main",
"index": 0
}
]
]
},
"Is call_analyzed?": {
"main": [
[
{
"node": "Compute Verdict",
"type": "main",
"index": 0
}
],
[]
]
},
"Compute Verdict": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
]
]
},
"Send Email": {
"main": [
[
{
"node": "Append to Sheet",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1",
"callerPolicy": "workflowsFromSameOwner",
"availableInMCP": false,
"binaryMode": "separate"
},
"staticData": null,
"meta": null,
"versionId": "34a1b08a-954a-46c3-ae40-2f2f61928c80",
"activeVersionId": "34a1b08a-954a-46c3-ae40-2f2f61928c80",
"versionCounter": 47,
"triggerCount": 1,
"shared": [
{
"updatedAt": "2026-05-08T18:24:41.988Z",
"createdAt": "2026-05-08T18:24:41.988Z",
"role": "workflow:owner",
"workflowId": "tXttNyCL4uyzSKJj",
"projectId": "SC76oS9iriD33KBd",
"project": {
"updatedAt": "2025-05-25T21:58:17.028Z",
"createdAt": "2025-05-25T21:38:29.751Z",
"id": "SC76oS9iriD33KBd",
"name": "Jes\u00fas Mart\u00ednez <jesus@datasmarts.net>",
"type": "personal",
"icon": null,
"description": null,
"creatorId": "72ea988c-e624-497c-ae70-93469eaa3fa7"
}
}
],
"tags": [],
"activeVersion": {
"updatedAt": "2026-05-08T23:16:35.988Z",
"createdAt": "2026-05-08T23:16:35.988Z",
"versionId": "34a1b08a-954a-46c3-ae40-2f2f61928c80",
"workflowId": "tXttNyCL4uyzSKJj",
"nodes": [
{
"parameters": {
"httpMethod": "POST",
"path": "retell-survey",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
0,
0
],
"id": "a0000000-0000-4000-8000-000000000001",
"name": "Retell Webhook",
"webhookId": "e255541c-163e-49ef-beb4-ae2372349173"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "if-call-analyzed",
"leftValue": "={{ $json.body.event }}",
"rightValue": "call_analyzed",
"operator": {
"type": "string",
"operation": "equals"
}
},
{
"id": "if-call-status-ended",
"leftValue": "={{ $json.body.call.call_status }}",
"rightValue": "ended",
"operator": {
"type": "string",
"operation": "equals"
}
},
{
"id": "if-call-duration-positive",
"leftValue": "={{ $json.body.call.duration_ms }}",
"rightValue": 0,
"operator": {
"type": "number",
"operation": "gt"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
224,
0
],
"id": "a0000000-0000-4000-8000-000000000002",
"name": "Is call_analyzed?"
},
{
"parameters": {
"jsCode": "const body = $input.first().json.body || {};\nconst call = body.call || {};\nconst analysis = call.call_analysis || {};\nconst custom = analysis.custom_analysis_data || {};\n\nconst q1 = Number(custom.q1_escalabilidad_score || 0);\nconst q2 = Number(custom.q2_diferenciacion_score || 0);\nconst q3 = Number(custom.q3_enfoque_score || 0);\nconst q4 = Number(custom.q4_compromiso_score || 0);\nconst total = q1 + q2 + q3 + q4;\n\nlet verdict;\nif (total >= 17) verdict = 'Candidato A (Top)';\nelse if (total >= 13) verdict = 'Candidato B (Apto)';\nelse verdict = 'No Apto';\n\nconst questionsAnswered = Number(custom.questions_answered || 0);\nconst wantsFollowup = Boolean(custom.caller_wants_followup);\n\nconst startTs = call.start_timestamp || Date.now();\nconst tsUtc = new Date(startTs).toISOString();\nconst tsBogota = new Date(startTs).toLocaleString('es-CO', { timeZone: 'America/Bogota', hour12: false });\n\nconst candidateName = (custom.candidate_name || '').trim() || '(no proporcionado)';\nconst candidateCompany = (custom.candidate_company || '').trim() || '(no proporcionada)';\nconst summary = analysis.call_summary || '';\nconst sentiment = analysis.user_sentiment || '';\nconst recordingUrl = call.recording_url || '';\nconst transcriptHint = call.public_log_url || '';\n\nconst row = (label, score, obs) => `\n <tr>\n <td style=\"padding:6px 10px;border:1px solid #ddd;\"><strong>${label}</strong></td>\n <td style=\"padding:6px 10px;border:1px solid #ddd;text-align:center;\">${score}/5</td>\n <td style=\"padding:6px 10px;border:1px solid #ddd;\">${obs || '<em>(sin observaci\u00f3n)</em>'}</td>\n </tr>`;\n\nconst emailHtml = `<!DOCTYPE html>\n<html lang=\"es\"><body style=\"font-family:-apple-system,Segoe UI,Helvetica,Arial,sans-serif;max-width:680px;margin:0 auto;padding:20px;color:#222;\">\n <h2 style=\"margin:0 0 4px 0;\">Encuesta \u2014 Programa de Exportaci\u00f3n de Servicios Modernos</h2>\n <p style=\"margin:0 0 16px 0;color:#666;\">${tsBogota} (Bogot\u00e1) \u00b7 ${call.call_id || ''}</p>\n\n <table style=\"width:100%;border-collapse:collapse;margin-bottom:16px;\">\n <tr><td style=\"padding:6px 10px;border:1px solid #ddd;background:#f7f7f7;width:200px;\"><strong>Candidato</strong></td><td style=\"padding:6px 10px;border:1px solid #ddd;\">${candidateName}</td></tr>\n <tr><td style=\"padding:6px 10px;border:1px solid #ddd;background:#f7f7f7;\"><strong>Empresa</strong></td><td style=\"padding:6px 10px;border:1px solid #ddd;\">${candidateCompany}</td></tr>\n <tr><td style=\"padding:6px 10px;border:1px solid #ddd;background:#f7f7f7;\"><strong>Preguntas respondidas</strong></td><td style=\"padding:6px 10px;border:1px solid #ddd;\">${questionsAnswered} / 4</td></tr>\n <tr><td style=\"padding:6px 10px;border:1px solid #ddd;background:#f7f7f7;\"><strong>Pidi\u00f3 seguimiento</strong></td><td style=\"padding:6px 10px;border:1px solid #ddd;\">${wantsFollowup ? 'S\u00ed' : 'No'}</td></tr>\n </table>\n\n <h3 style=\"margin:24px 0 8px 0;\">Matriz de Evaluaci\u00f3n</h3>\n <table style=\"width:100%;border-collapse:collapse;\">\n <thead><tr><th style=\"padding:6px 10px;border:1px solid #ddd;background:#f0f0f0;text-align:left;\">Pregunta</th><th style=\"padding:6px 10px;border:1px solid #ddd;background:#f0f0f0;width:80px;\">Puntaje</th><th style=\"padding:6px 10px;border:1px solid #ddd;background:#f0f0f0;text-align:left;\">Observaci\u00f3n</th></tr></thead>\n <tbody>\n ${row('1. Escalabilidad', q1, custom.q1_escalabilidad_obs)}\n ${row('2. Diferenciaci\u00f3n', q2, custom.q2_diferenciacion_obs)}\n ${row('3. Enfoque comercial', q3, custom.q3_enfoque_obs)}\n ${row('4. Compromiso', q4, custom.q4_compromiso_obs)}\n <tr><td style=\"padding:8px 10px;border:1px solid #ddd;background:#f7f7f7;\"><strong>TOTAL</strong></td><td style=\"padding:8px 10px;border:1px solid #ddd;text-align:center;background:#f7f7f7;\"><strong>${total}/20</strong></td><td style=\"padding:8px 10px;border:1px solid #ddd;background:#f7f7f7;\"><strong>${verdict}</strong></td></tr>\n </tbody>\n </table>\n\n <h3 style=\"margin:24px 0 8px 0;\">Resumen de la llamada</h3>\n <p style=\"line-height:1.5;margin:0 0 8px 0;\">${summary || '<em>(sin resumen)</em>'}</p>\n <p style=\"margin:0 0 16px 0;\"><strong>Sentimiento:</strong> ${sentiment || '(no clasificado)'}</p>\n\n ${recordingUrl ? `<p><a href=\"${recordingUrl}\">\u25b6 Escuchar la grabaci\u00f3n</a></p>` : ''}\n ${transcriptHint ? `<p><a href=\"${transcriptHint}\">\ud83d\udcdd Ver transcripci\u00f3n y log</a></p>` : ''}\n</body></html>`;\n\nconst emailSubject = `[Encuesta] ${verdict} \u2014 ${candidateName} / ${candidateCompany}`;\n\nreturn [{\n json: {\n timestamp_utc: tsUtc,\n timestamp_bogota: tsBogota,\n call_id: call.call_id || '',\n candidate_name: candidateName,\n candidate_company: candidateCompany,\n q1_escalabilidad: q1,\n q2_diferenciacion: q2,\n q3_enfoque: q3,\n q4_compromiso: q4,\n total,\n verdict,\n questions_answered: questionsAnswered,\n wants_followup: wantsFollowup ? 'S\u00ed' : 'No',\n summary,\n sentiment,\n recording_url: recordingUrl,\n email_subject: emailSubject,\n email_html: emailHtml,\n }\n}];"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
448,
-128
],
"id": "a0000000-0000-4000-8000-000000000003",
"name": "Compute Verdict"
},
{
"parameters": {
"sendTo": "jesus@datasmarts.net, raiz@thefamilyfirst.co",
"subject": "={{ $json.email_subject }}",
"message": "={{ $json.email_html }}",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.2,
"position": [
672,
-240
],
"id": "a0000000-0000-4000-8000-000000000004",
"name": "Send Email",
"webhookId": "80ca9267-b2ea-4199-a905-75038e551cda",
"credentials": {
"gmailOAuth2": {
"id": "PxY342gB7M9eQF5h",
"name": "[DataSmarts] Gmail"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1dZFeYwBPxReBuN0nS_yXqSrtx_9lAvwVZlthvdH19fo",
"mode": "list",
"cachedResultName": "Spanish Phone Survey \u2014 Demo Log",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dZFeYwBPxReBuN0nS_yXqSrtx_9lAvwVZlthvdH19fo/edit"
},
"sheetName": {
"__rl": true,
"value": "Calls",
"mode": "name"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"timestamp_utc": "={{ $('Compute Verdict').item.json.timestamp_utc }}",
"timestamp_bogota": "={{ $('Compute Verdict').item.json.timestamp_bogota }}",
"call_id": "={{ $('Compute Verdict').item.json.call_id }}",
"candidate_name": "={{ $('Compute Verdict').item.json.candidate_name }}",
"candidate_company": "={{ $('Compute Verdict').item.json.candidate_company }}",
"q1_escalabilidad": "={{ $('Compute Verdict').item.json.q1_escalabilidad }}",
"q2_diferenciacion": "={{ $('Compute Verdict').item.json.q2_diferenciacion }}",
"q3_enfoque": "={{ $('Compute Verdict').item.json.q3_enfoque }}",
"q4_compromiso": "={{ $('Compute Verdict').item.json.q4_compromiso }}",
"total": "={{ $('Compute Verdict').item.json.total }}",
"verdict": "={{ $('Compute Verdict').item.json.verdict }}",
"questions_answered": "={{ $('Compute Verdict').item.json.questions_answered }}",
"wants_followup": "={{ $('Compute Verdict').item.json.wants_followup }}",
"summary": "={{ $('Compute Verdict').item.json.summary }}",
"sentiment": "={{ $('Compute Verdict').item.json.sentiment }}",
"recording_url": "={{ $('Compute Verdict').item.json.recording_url }}"
},
"matchingColumns": [],
"schema": [
{
"id": "timestamp_utc",
"displayName": "timestamp_utc",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "timestamp_bogota",
"displayName": "timestamp_bogota",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "call_id",
"displayName": "call_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "candidate_name",
"displayName": "candidate_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "candidate_company",
"displayName": "candidate_company",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "q1_escalabilidad",
"displayName": "q1_escalabilidad",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "q2_diferenciacion",
"displayName": "q2_diferenciacion",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "q3_enfoque",
"displayName": "q3_enfoque",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "q4_compromiso",
"displayName": "q4_compromiso",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "total",
"displayName": "total",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "verdict",
"displayName": "verdict",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "questions_answered",
"displayName": "questions_answered",
"required": false,
"defaultMatch": false,
"display": true,
"type": "number",
"canBeUsedToMatch": true
},
{
"id": "wants_followup",
"displayName": "wants_followup",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "summary",
"displayName": "summary",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "sentiment",
"displayName": "sentiment",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "recording_url",
"displayName": "recording_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.5,
"position": [
880,
-240
],
"id": "a0000000-0000-4000-8000-000000000005",
"name": "Append to Sheet",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "qDGPNqnKLwO1pYbS",
"name": "[DataSmarts] Google Sheets"
}
}
}
],
"connections": {
"Retell Webhook": {
"main": [
[
{
"node": "Is call_analyzed?",
"type": "main",
"index": 0
}
]
]
},
"Is call_analyzed?": {
"main": [
[
{
"node": "Compute Verdict",
"type": "main",
"index": 0
}
],
[]
]
},
"Compute Verdict": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
]
]
},
"Send Email": {
"main": [
[
{
"node": "Append to Sheet",
"type": "main",
"index": 0
}
]
]
}
},
"authors": "Jes\u00fas Mart\u00ednez",
"name": null,
"description": null,
"autosaved": false,
"workflowPublishHistory": [
{
"createdAt": "2026-05-08T23:16:36.078Z",
"id": 420,
"workflowId": "tXttNyCL4uyzSKJj",
"versionId": "34a1b08a-954a-46c3-ae40-2f2f61928c80",
"event": "deactivated",
"userId": "72ea988c-e624-497c-ae70-93469eaa3fa7"
},
{
"createdAt": "2026-05-08T23:16:36.110Z",
"id": 421,
"workflowId": "tXttNyCL4uyzSKJj",
"versionId": "34a1b08a-954a-46c3-ae40-2f2f61928c80",
"event": "activated",
"userId": "72ea988c-e624-497c-ae70-93469eaa3fa7"
}
]
}
}
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
Spanish Phone Survey — Retell Post-Call. Uses gmail, googleSheets. Webhook trigger; 5 nodes.
Source: https://github.com/jesus-a-martinez-v/spanish-phone-survey/blob/4a96d756d669f613debcffb842bfbcb1bdd04f54/n8n/workflow.live.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.
Automate WhatsApp communication for recruitment agencies with an interactive, structured customer experience. This workflow handles pricing inquiries, request submissions, tracking, complaints, and hu
HTTP Request, Google Sheets, Gmail +1
Code. Uses googleSheets, gmail, supabase, stickyNote. Webhook trigger; 51 nodes.
Google Sheets, Gmail, Supabase +1
This template turns Podium's conversation inbox into a full sales CRM with a custom funnel, AI message classification, automated drip follow-ups, daily admin reports, and a live Kanban dashboard. Six
HTTP Request, Google Sheets, Gmail
Ticketing Backend automates registration, QR-ticket generation, email delivery, and check-in validation using Google Sheets, Gmail, and a webhook scanner — reducing manual ticket prep from ~3 hours to
Google Sheets, HTTP Request, Gmail
> n8n + Gmail + Google Sheets + Typeform
Gmail, Google Sheets