{ "edges": [ { "to": "b7d5b399-12fc-4941-8c4a-d23527cc969d", "from": "f19b7631-d608-44e8-8836-6dc8935a48d6", "toPort": "0", "fromPort": "0" }, { "to": "eaf2baae-5dce-4343-a1f7-1f176232b406", "from": "a9827ad6-7a2d-453e-8469-9c386c800f1e", "toPort": "0", "fromPort": "0" }, { "to": "f19b7631-d608-44e8-8836-6dc8935a48d6", "from": "b2b57686-ac2f-4883-9e6c-130cced071a5", "toPort": "1", "fromPort": "0" }, { "to": "8260de8d-d657-4856-bd3e-aadce922b260", "from": "b2b57686-ac2f-4883-9e6c-130cced071a5", "toPort": "0", "fromPort": "0" }, { "to": "2a86cbb2-f173-4740-b715-5f05c87eede8", "from": "b2b57686-ac2f-4883-9e6c-130cced071a5", "toPort": "0", "fromPort": "0" }, { "to": "ffcc9e52-e985-4e7e-bc01-3a5a0a0a211c", "from": "8260de8d-d657-4856-bd3e-aadce922b260", "toPort": "0", "fromPort": "0" }, { "to": "35d022c8-fbb9-4ad6-a156-2776274cd140", "from": "b7d5b399-12fc-4941-8c4a-d23527cc969d", "toPort": "0", "fromPort": "0" }, { "to": "f19b7631-d608-44e8-8836-6dc8935a48d6", "from": "2a86cbb2-f173-4740-b715-5f05c87eede8", "toPort": "2", "fromPort": "0" }, { "to": "a9827ad6-7a2d-453e-8469-9c386c800f1e", "from": "eb02fbc6-420a-4c0d-8f40-0d1fe5942ee8", "toPort": "0", "fromPort": "0" }, { "to": "f19b7631-d608-44e8-8836-6dc8935a48d6", "from": "ffcc9e52-e985-4e7e-bc01-3a5a0a0a211c", "toPort": "0", "fromPort": "0" }, { "to": "b2b57686-ac2f-4883-9e6c-130cced071a5", "from": "eaf2baae-5dce-4343-a1f7-1f176232b406", "toPort": "0", "fromPort": "0" }, { "to": "db8c422a-4b4a-4eba-a308-2a369fe4d7f2", "from": "35d022c8-fbb9-4ad6-a156-2776274cd140", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "eb02fbc6-420a-4c0d-8f40-0d1fe5942ee8", "name": "Feedback Webhook", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "webinar-feedback", "options": {}, "httpMethod": "POST", "responseMode": "streaming" }, "position": [ -208, 192 ] }, { "id": "eaf2baae-5dce-4343-a1f7-1f176232b406", "name": "Normalize Feedback", "type": "code", "params": { "mode": "runOnceForEachItem", "jsCode": "const body = $json.body ?? $json ?? {};\n\nreturn {\n email: body.Email || \"\",\n name: body.Name || \"Attendee\",\n rating: Number(body.Rating) || 0,\n feedback: body.Feedback || body.comment || \"\",\n attended: body.Attended !== false,\n webinarTitle: body['Webinar Title'] || \"AI Automation Mastery Webinar\",\n submittedAt: new Date().toISOString()\n};\n" }, "position": [ 240, 192 ] }, { "id": "db8c422a-4b4a-4eba-a308-2a369fe4d7f2", "name": "Store Feedback", "type": "integration", "params": { "columns": { "value": { "Sent At": "={{ $now.toISO().slice(0, 10) }}\n", "Our Reply": "={{ $('Merge').item.json.aiThankYouMessage }}", "Email Sent": "={{ $json.labelIds[0] }}", "row_number": 0, "feedback_id": "={{ $('Store Partial').item.json.feedback_id }}" }, "schema": [ { "id": "feedback_id", "type": "string", "display": true, "removed": false, "required": false, "displayName": "feedback_id", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Webinar Title", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Webinar Title", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Rating", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Rating", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Original Feedback", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Original Feedback", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Our Reply", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Our Reply", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email Sent", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Email Sent", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Sent At", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Sent At", "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": [ "feedback_id" ], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "update", "sheetName": { "value": "YOUR_SHEET_NAME" }, "documentId": { "value": "YOUR_GOOGLE_SHEET_ID" } }, "position": [ 2192, 192 ] }, { "id": "ffcc9e52-e985-4e7e-bc01-3a5a0a0a211c", "name": "Parse AI Response", "type": "code", "params": { "mode": "runOnceForEachItem", "jsCode": "// ===============================\n// Parse AI Agent Response (FINAL)\n// ===============================\n\n// 1️⃣ Extract AI text safely\nconst rawText =\n $json.output?.[0]?.content?.[0]?.text ||\n '{}';\n\n// 2️⃣ Clean + parse JSON\nlet aiData = {};\ntry {\n const cleaned = rawText.replace(/```json|```/g, '').trim();\n aiData = JSON.parse(cleaned);\n} catch (e) {\n aiData = {\n segment: \"warm\",\n thankYouMessage: \"Thank you for attending the webinar.\",\n nextSteps: []\n };\n}\n\n// 3️⃣ Promote parsed fields (DO NOT add resources here)\nreturn {\n ...$json,\n aiSegment: aiData.segment || \"warm\",\n aiThankYouMessage: aiData.thankYouMessage || \"Thank you for your feedback.\",\n aiNextSteps: Array.isArray(aiData.nextSteps) ? aiData.nextSteps : []\n};\n" }, "position": [ 1200, 48 ] }, { "id": "b7d5b399-12fc-4941-8c4a-d23527cc969d", "name": "Build Email HTML", "type": "code", "params": { "mode": "runOnceForEachItem", "jsCode": "// ===============================\n// Build Professional Feedback Reply Email\n// Mode: Run Once for Each Item\n// ===============================\n\n// Core data (DO NOT rename)\nconst name = $json.Name || 'there';\nconst email = $json.Email || '';\nconst webinarTitle = $json['Webinar Title'] || 'our webinar';\n\n// -------------------------------\n// Parse AI JSON SAFELY\n// -------------------------------\nlet aiData = {};\ntry {\n aiData = JSON.parse($json.output[0].content[0].text);\n} catch (e) {\n aiData = {};\n}\n\nconst thankYouMessage =\n aiData.thankYouMessage || 'Thank you for sharing your feedback.';\n\nconst nextSteps = Array.isArray(aiData.nextSteps) ? aiData.nextSteps : [];\n\n// -------------------------------\n// Common Resources (already merged)\n// -------------------------------\nconst resources = Array.isArray($json.resources) ? $json.resources : [];\n\n// -------------------------------\n// Optional sections\n// -------------------------------\nconst nextStepsBlock = nextSteps.length\n ? `\n

Suggested next steps

${step}

`\n : '';\n\nconst resourcesBlock = resources.length\n ? `\n

Helpful resources

${r.label}

`\n : '';\n\n// -------------------------------\n// Final HTML\n// -------------------------------\nconst htmlContent = `\n\n\n\n \n\n\n

\n \n\n

${thankYouMessage}

\n\n ${resourcesBlock}\n ${nextStepsBlock}\n\n

\n If you have any questions or would like to discuss this further, feel free to reply to this email.\n

\n\n

\n Best regards,
\n The Webinar Team\n

\n\n \n

\n\n\n`;\n\nreturn {\n email,\n subject: `Thank you for your feedback – ${webinarTitle}`,\n htmlContent\n};\n" }, "position": [ 1744, 192 ] }, { "id": "35d022c8-fbb9-4ad6-a156-2776274cd140", "name": "Send AI Thank You Email", "type": "integration", "params": { "sendTo": "={{ $json.email }}", "message": "={{ $json.htmlContent }}", "options": { "appendAttribution": false }, "service": "gmail", "subject": "={{ $json.subject }}", "operation": "read" }, "position": [ 1968, 192 ] }, { "id": "8260de8d-d657-4856-bd3e-aadce922b260", "name": "Message a model", "type": "llm", "params": { "modelId": { "__rl": true, "mode": "list", "value": "gpt-4.1-mini", "cachedResultName": "GPT-4.1-MINI" }, "options": {}, "provider": "openai", "responses": { "values": [ { "content": "You are a professional webinar organizer responding personally to attendee feedback.\n\nYour task is to:\n1. Read the attendee’s feedback carefully\n2. Write a thoughtful, human reply that acknowledges what they said\n3. Decide an engagement segment internally (HOT / WARM / COLD)\n4. Suggest appropriate next steps and resources subtly and professionally\n\n────────────────\nSEGMENTATION LOGIC (INTERNAL USE ONLY)\n────────────────\nDetermine the segment using these rules:\n\nHOT\n- Rating is 4 or 5\n- Attended = true\n- Feedback is clearly positive, detailed, or shows intent to apply learnings\n\nWARM\n- Rating is exactly 3\n- Attended = true\n- Feedback is neutral or brief\n\nCOLD\n- Rating is 1 or 2\n- OR Attended = false\n- OR feedback is missing or very weak\n\nIf unsure, choose the LOWER segment.\n\n────────────────\nWRITING GUIDELINES (VERY IMPORTANT)\n────────────────\n- Write like a real person replying to feedback\n- Acknowledge specific points mentioned in the feedback\n- Be professional, calm, and appreciative\n- Do NOT mention ratings or scores\n- Do NOT use emojis\n- Do NOT sound promotional or salesy\n- 2–4 short paragraphs maximum\n\n────────────────\nOUTPUT REQUIREMENTS\n────────────────\nRespond in VALID JSON ONLY.\nNo markdown, no explanations, no extra text.\n\nJSON format:\n{\n \"segment\": \"hot | warm | cold\",\n \"thankYouMessage\": \"A natural, professional reply that directly responds to the attendee’s feedback\",\n \"nextSteps\": [\n \"1–2 optional, low-pressure next steps\"\n ],\n\"resources\": [\nThe following resources are available. Do NOT invent new ones.\n{{ $('Store Partial').item.json['Webinar Title'] }} \n]\n}\n\n────────────────\nATTENDEE FEEDBACK\n────────────────\nFeedback: {{ $('Store Partial').item.json['Original Feedback'] }}\nRating: {{ $('Store Partial').item.json.Rating }}\nWebinar: {{ $('Store Partial').item.json['Webinar Title'] }}\n" } ] }, "builtInTools": {} }, "position": [ 896, 48 ] }, { "id": "f19b7631-d608-44e8-8836-6dc8935a48d6", "name": "Merge", "type": "merge", "params": { "mode": "combine", "options": {}, "combineBy": "combineByPosition", "numberInputs": 3 }, "position": [ 1504, 176 ] }, { "id": "2a86cbb2-f173-4740-b715-5f05c87eede8", "name": "Common Resources", "type": "code", "params": { "jsCode": "return [\n {\n json: {\n resources: [\n {\n label: \"Webinar Recording\",\n url: \"https://yourdomain.com/webinar-recording\"\n },\n {\n label: \"Presentation Slides\",\n url: \"https://yourdomain.com/slides\"\n },\n {\n label: \"Automation Use-Case Library\",\n url: \"https://yourdomain.com/use-cases\"\n }\n ]\n }\n }\n];\n" }, "position": [ 688, 224 ] }, { "id": "b2b57686-ac2f-4883-9e6c-130cced071a5", "name": "Store Partial", "type": "integration", "params": { "columns": { "value": { "Name": "={{ $json.name }}", "Email": "={{ $json.email }}", "Rating": "={{ $json.rating }}", "feedback_id": "={{ $('ID Generation').item.json.feedback_id }}", "Webinar Title": "={{ $json.webinarTitle }}", "Original Feedback": "={{ $json.feedback }}" }, "schema": [ { "id": "feedback_id", "type": "string", "display": true, "removed": false, "required": false, "displayName": "feedback_id", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email", "type": "string", "display": true, "required": false, "displayName": "Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Name", "type": "string", "display": true, "required": false, "displayName": "Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Webinar Title", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Webinar Title", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Rating", "type": "string", "display": true, "required": false, "displayName": "Rating", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Original Feedback", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Original Feedback", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Our Reply", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Our Reply", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email Sent", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Email Sent", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Sent At", "type": "string", "display": true, "removed": false, "required": false, "displayName": "Sent At", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "value": "YOUR_SHEET_NAME" }, "documentId": { "__rl": true, "value": "YOUR_GOOGLE_SHEET_ID" } }, "position": [ 464, 192 ] }, { "id": "a9827ad6-7a2d-453e-8469-9c386c800f1e", "name": "ID Generation", "type": "code", "params": { "mode": "runOnceForEachItem", "jsCode": "// ===============================\n// Generate Human-Readable feedback_id\n// ===============================\n\nconst name = ( $json.body.Name|| 'Guest')\n .replace(/\\s+/g, '')\n .trim();\n\nconst submittedAt = new Date(\n $json.submittedAt || Date.now()\n);\n\n// Format date parts\nconst date = submittedAt.toISOString().slice(0, 10); // YYYY-MM-DD\nconst time = submittedAt.toISOString().slice(11, 16); // HH:MM\n\nconst feedback_id = `${name}_${date}_${time}`;\n\nreturn {\n ...$json,\n feedback_id\n};\n" }, "position": [ 16, 192 ] } ] }

Suggested next steps

Helpful resources

Thank you, ${name}

AI-powered webinar feedback replies with GPT-4, Google Sheets, and Gmail