January 22, 2026

Gmail + Google Sheets: webinar follow-ups handled

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your webinar ends, feedback comes in, and suddenly you’re staring at a messy spreadsheet tab while “I’ll reply later” turns into next week. Some attendees get a thoughtful follow-up. Others get nothing. And you can’t even tell who you missed without re-checking the form, the inbox, and your sheet again.

This Gmail Sheets follow-ups automation hits marketing managers first, because the post-webinar window is short. A founder running lean feels it too. Same for a client services lead who needs clean records for the team. The outcome is simple: every attendee gets a personalized thank-you email, and every reply is logged in one place.

Below you’ll see how the workflow runs in n8n, what it automates, the results you can expect, and what to watch for when you put it into production.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Gmail + Google Sheets: webinar follow-ups handled

Click to explore

flowchart LR

    subgraph sg0["Message a model Flow"]
        direction LR
        n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Feedback Webhook"]
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Normalize Feedback"]
        n2@{ icon: "mdi:database", form: "rounded", label: "Store Feedback", pos: "b", h: 48 }
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Parse AI Response"]
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Build Email HTML"]
        n5@{ icon: "mdi:message-outline", form: "rounded", label: "Send AI Thank You Email", pos: "b", h: 48 }
        n6@{ icon: "mdi:robot", form: "rounded", label: "Message a model", pos: "b", h: 48 }
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge"]
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Common Resources"]
        n9@{ icon: "mdi:database", form: "rounded", label: "Store Partial", pos: "b", h: 48 }
        n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>ID Generation"]
        n7 --> n4
        n10 --> n1
        n9 --> n7
        n9 --> n6
        n9 --> n8
        n6 --> n3
        n4 --> n5
        n8 --> n7
        n0 --> n10
        n3 --> n7
        n1 --> n9
        n5 --> n2
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n6 ai
    class n2,n9 database
    class n0 api
    class n1,n3,n4,n8,n10 code
    classDef customIcon fill:none,stroke:none
    class n0,n1,n3,n4,n7,n8,n10 customIcon

The Problem: Webinar follow-ups fall through the cracks

Webinar feedback is supposed to be a gift. In practice, it lands in your lap as a list of names, ratings, and half-written comments that require judgment calls. Who needs a simple thank-you? Who’s annoyed? Who asked a real question and deserves a real answer? When you do it manually, you end up bouncing between a form export, Gmail drafts, and a tracking sheet that’s never fully up to date. Even when you try to keep up, it’s easy to send a generic note that feels cold, or miss someone entirely because the row got buried.

It adds up fast. Here’s where it breaks down once the volume is more than a handful of responses.

You spend about 5–10 minutes per attendee just cleaning fields like name, email, and rating so your email doesn’t start with “Hi ,”.
Replies get handled in Gmail, but the spreadsheet stays stale, so nobody can tell what happened without opening the thread.
Someone with negative sentiment often needs a careful response, yet those are the easiest to rush when you’re tired.
Without a reliable log, you can’t confidently report engagement, common questions, or follow-up outcomes to your team.

The Solution: Automatically reply with a personal thank-you, then log everything

This workflow starts the moment webinar feedback is submitted through a webhook (usually a form tool sending data in real time). n8n immediately generates a readable feedback ID, then cleans up the incoming fields so names, emails, ratings, and comments are consistent. Next, it stores the raw feedback in Google Sheets, so you always have a “source of truth” even if something later fails. From there, an AI model reads the comment and assesses sentiment and intent, then proposes a tailored response in plain, human language. Finally, the workflow merges the attendee details, AI reply, and shared resources (like a recording link), builds a professional HTML email, sends it from Gmail, and updates the Google Sheet with what was sent and when.

The workflow begins when feedback hits the webhook. It then standardizes the data, generates a response using an OpenAI Chat Model node, and composes the final email HTML. Gmail sends the message, and Google Sheets becomes the timeline of record for every attendee.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Captures webinar feedback instantly via webhook, without exporting CSV files.
Cleans and normalizes attendee fields (name, email, rating, comments) before you touch anything.
Uses AI to infer sentiment and intent, then drafts a personalized reply text.
Sends a polished HTML thank-you email through Gmail and writes the final status back to Google Sheets.

Turn “reply later” into “replied today” for every attendee, typically in under 5 minutes end-to-end per submission.
Reduce awkward mistakes like missing names or broken resource links because the same template logic runs every time.
Spot unhappy attendees faster because sentiment is analyzed and stored alongside the feedback.
Get a clean audit trail for your team: what came in, what was sent, and when it happened.
Make post-webinar follow-up scalable, even when responses jump from 20 to 200.

Example: What This Looks Like

Say your webinar gets 60 feedback submissions. Manually, if you spend about 8 minutes per person to read the comment, write a reply, paste in links, send from Gmail, and then update Google Sheets, that’s roughly 8 hours of work. With this workflow, the attendee submits feedback once and the webhook triggers everything. You’ll still review edge cases, but most emails go out automatically, and logging happens in the background, which means you get most of that day back.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for the feedback log and status tracking
Gmail to send the personalized thank-you emails
OpenAI API key (get it from your OpenAI dashboard)

Skill level: Intermediate. You’ll connect accounts, paste an API key, and confirm your sheet columns match the workflow fields.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A feedback form submission triggers the workflow. The “Incoming Feedback Hook” webhook receives the attendee’s name, email, rating, and comments as soon as they hit submit.

The data is cleaned and prepared for reliable sending. n8n generates a readable feedback ID, then standardizes the fields so your Google Sheet rows and email greeting stay consistent.

AI drafts a human reply that matches the feedback. The workflow logs the raw feedback to Google Sheets, then the OpenAI Chat Model node analyzes sentiment and intent and returns structured output (reply text plus any suggested next steps).

Gmail sends the final email and Google Sheets becomes the record. A merge step combines the attendee info, shared resources (recording/slides), and AI output, then an HTML email is composed and dispatched via Gmail. The same row in Google Sheets is updated with the email content, timestamp, and send status.

You can easily modify the email tone and resource links to match each webinar. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Webhook Trigger

Set up the webhook that receives webinar feedback submissions.

Add and open Incoming Feedback Hook.
Set Path to webinar-feedback.
Set HTTP Method to POST.
Set Response Mode to streaming.

Step 2: Connect Google Sheets

Configure the feedback log storage and update steps.

Open Log Initial Feedback and select the spreadsheet for initial logging.
Set Document ID to YOUR_GOOGLE_SHEET_ID and Sheet Name to YOUR_SHEET_NAME.
Confirm the column mappings use expressions like {{ $json.name }}, {{ $json.email }}, and {{ $('Generate Feedback ID').item.json.feedback_id }}.
Open Update Feedback Log and set Operation to update with matching column feedback_id.
Verify update fields include {{ $now.toISO().slice(0, 10) }}, {{ $('Combine Inputs').item.json.aiThankYouMessage }}, {{ $json.labelIds[0] }}, and {{ $('Log Initial Feedback').item.json.feedback_id }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in both Log Initial Feedback and Update Feedback Log.

Step 3: Set Up Feedback Processing (Code Nodes)

Standardize the incoming data and generate IDs and resource lists used later.

In Generate Feedback ID, keep Mode as runOnceForEachItem to create the feedback_id from the attendee name and timestamp.
In Standardize Feedback Data, keep Mode as runOnceForEachItem and ensure it maps fields like email, name, rating, feedback, and webinarTitle.
In Shared Resource List, replace placeholder URLs (e.g., https://[YOUR_ID]) with your actual resources.
In Interpret AI Output, keep the JSON parsing fallback logic to ensure safe defaults for aiSegment, aiThankYouMessage, and aiNextSteps.
In Compose Email HTML, retain the HTML template and ensure it uses values like $json.resources, $json.output[0].content[0].text, and $json['Webinar Title'].

⚠️ Common Pitfall: If the incoming webhook payload uses different field names, update Standardize Feedback Data accordingly or emails may be sent with blank values.

Step 4: Set Up the AI Reply Generation

Configure the AI node that crafts the personalized thank-you message.

Open AI Reply Generator and confirm the model is set to gpt-4.1-mini.
Review the prompt to ensure it references expressions like {{ $('Log Initial Feedback').item.json['Original Feedback'] }} and {{ $('Log Initial Feedback').item.json.Rating }}.
Credential Required: Connect your openAiApi credentials in AI Reply Generator.

Execution flow note: Log Initial Feedback outputs to both Combine Inputs and AI Reply Generator and Shared Resource List in parallel.

Step 5: Configure Email Assembly and Delivery

Merge AI output with resources, compose the HTML email, and send it.

Open Combine Inputs and confirm Mode is combine with Combine By set to combineByPosition and Number Inputs set to 3.
In Dispatch Thank You Email, set Send To to {{ $json.email }}, Subject to {{ $json.subject }}, and Message to {{ $json.htmlContent }}.
Credential Required: Connect your gmailOAuth2 credentials in Dispatch Thank You Email.

⚠️ Common Pitfall: If Combine Inputs does not receive all three inputs, Compose Email HTML may render without resources or AI text.

Step 6: Test and Activate Your Workflow

Validate the end-to-end flow before turning it on for production.

Click Execute Workflow and send a sample POST request to Incoming Feedback Hook.
Confirm a new row appears in your sheet from Log Initial Feedback with a generated feedback_id.
Verify that Dispatch Thank You Email sends an email containing the AI response and resources.
Check that Update Feedback Log fills Our Reply and Sent At using the expressions provided.
Toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets access can fail if the connected Google account loses permission to the file. If sends stop logging, check the n8n Google Sheets credential and confirm the spreadsheet is shared correctly.
If your webhook source sometimes sends empty fields (like missing ratings), the normalization step may produce blank values that later break the email template. Make sure your form enforces required fields or add a simple fallback in the “Standardize Feedback Data” code step.
OpenAI output can drift if your prompt is too generic. Honestly, a tiny brand voice instruction goes a long way, otherwise you’ll be editing “Hope you’re doing well” forever.

Frequently Asked Questions

How long does it take to set up this Gmail Sheets follow-ups automation?

About 30–60 minutes if your Google accounts and sheet are ready.

Do I need coding skills to automate webinar follow-ups?

No. You’ll mostly connect Gmail/Google Sheets and paste in your OpenAI key. The code steps are already built; you’re just adjusting fields and copy.

Is n8n free to use for this Gmail Sheets follow-ups workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs, which are usually a few cents per batch of responses.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Gmail Sheets follow-ups workflow for different webinar topics or brands?

Yes, and you should. Update the prompt used by the AI Reply Generator so it matches your tone, then tweak the Compose Email HTML step to swap logos, colors, and the resource section. Common customizations include adding a “book a call” link for high-intent attendees, sending different resources based on rating, and writing a separate follow-up path when sentiment is negative.

Why is my Gmail connection failing in this workflow?

Usually it’s an expired Google auth token or the wrong Gmail account connected in n8n. Reconnect the Gmail credential, then send a test submission through the webhook and watch the Dispatch Thank You Email node for the exact error message. If you’re sending a lot at once, Google can temporarily throttle you, so spacing sends out helps. Also check that your “From” address matches what the connected account is allowed to send from.

How many feedback submissions can this Gmail Sheets follow-ups automation handle?

Plenty for most webinars.

Is this Gmail Sheets follow-ups automation better than using Zapier or Make?

Often, yes, if you want reliable logging and more control over the AI step. n8n makes it easier to keep everything in one workflow: normalize fields, run AI, merge data, and generate HTML without fighting “one-path-only” limits. Self-hosting is the other big deal, because executions aren’t metered the same way. Zapier or Make can still be fine for a simple “form → email” path, but this use case benefits from branching and structured AI output. If you want help choosing, Talk to an automation expert.

Once this is running, follow-ups stop being a stressful post-webinar chore and become a dependable system. Set it up once, then let the workflow keep your replies and records tidy.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"meta": {
"instanceId": "470f367353c6dc16cff3dba44eee4a5d269d765ebd01677067149f07b51be692",
"templateCredsSetupCompleted": null,
"templateId": null
},
"name": "Automated Webinar Feedback Handling",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-11889",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
30
],
"parameters": {
"color": 7,
"width": 1186,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "eb02fbc6-420a-4c0d-8f40-0d1fe5942ee8",
"name": "Incoming Feedback Hook",
"type": "n8n-nodes-base.webhook",
"position": [
1086,
168
],
"webhookId": "webinar-feedback-hook",
"parameters": {
"path": "webinar-feedback",
"options": [],
"httpMethod": "POST",
"responseMode": "streaming"
},
"typeVersion": 2.1
},
{
"id": "a9827ad6-7a2d-453e-8469-9c386c800f1e",
"name": "Generate Feedback ID",
"type": "n8n-nodes-base.code",
"position": [
686,
130
],
"parameters": {
"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"
},
"typeVersion": 2
},
{
"id": "eaf2baae-5dce-4343-a1f7-1f176232b406",
"name": "Standardize Feedback Data",
"type": "n8n-nodes-base.code",
"position": [
382,
154
],
"parameters": {
"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"
},
"typeVersion": 2
},
{
"id": "b2b57686-ac2f-4883-9e6c-130cced071a5",
"name": "Log Initial Feedback",
"type": "n8n-nodes-base.googleSheets",
"position": [
40,
144
],
"parameters": {
"columns": {
"value": {
"Name": "={{ $json.name }}",
"Email": "={{ $json.email }}",
"Rating": "={{ $json.rating }}",
"feedback_id": "={{ $('Generate Feedback ID').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": [],
"operation": "append",
"sheetName": {
"__rl": true,
"value": "YOUR_SHEET_NAME"
},
"documentId": {
"__rl": true,
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4
},
{
"id": "2a86cbb2-f173-4740-b715-5f05c87eede8",
"name": "Shared Resource List",
"type": "n8n-nodes-base.code",
"position": [
0,
358
],
"parameters": {
"jsCode": "return [\n  {\n    json: {\n      resources: [\n        {\n          label: \"Webinar Recording\",\n          url: \"https://[YOUR_ID]\"\n        },\n        {\n          label: \"Presentation Slides\",\n          url: \"https://[YOUR_ID]\"\n        },\n        {\n          label: \"Automation Use-Case Library\",\n          url: \"https://[YOUR_ID]\"\n        }\n      ]\n    }\n  }\n];\n"
},
"typeVersion": 2
},
{
"id": "8260de8d-d657-4856-bd3e-aadce922b260",
"name": "AI Reply Generator",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
308,
344
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": [],
"responses": {
"values": [
{
"content": "You are a professional webinar organizer responding personally to attendee feedback.\n\nYour task is to:\n1. Read the attendee\u2019s 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\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\nSEGMENTATION LOGIC (INTERNAL USE ONLY)\n\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\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\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\nWRITING GUIDELINES (VERY IMPORTANT)\n\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\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\u20134 short paragraphs maximum\n\n\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\nOUTPUT REQUIREMENTS\n\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\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\u2019s feedback\",\n  \"nextSteps\": [\n    \"1\u20132 optional, low-pressure next steps\"\n  ],\n\"resources\": [\nThe following resources are available. Do NOT invent new ones.\n{{ $('Log Initial Feedback').item.json['Webinar Title'] }} \n]\n}\n\n\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\nATTENDEE FEEDBACK\n\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\nFeedback: {{ $('Log Initial Feedback').item.json['Original Feedback'] }}\nRating: {{ $('Log Initial Feedback').item.json.Rating }}\nWebinar: {{ $('Log Initial Feedback').item.json['Webinar Title'] }}\n"
}
]
},
"builtInTools": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "ffcc9e52-e985-4e7e-bc01-3a5a0a0a211c",
"name": "Interpret AI Output",
"type": "n8n-nodes-base.code",
"position": [
698,
356
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// ===============================\n// Parse AI Agent Response (FINAL)\n// ===============================\n\n// 1\ufe0f\u20e3 Extract AI text safely\nconst rawText =\n  $json.output?.[0]?.content?.[0]?.text ||\n  '{}';\n\n// 2\ufe0f\u20e3 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\ufe0f\u20e3 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"
},
"typeVersion": 2
},
{
"id": "f19b7631-d608-44e8-8836-6dc8935a48d6",
"name": "Combine Inputs",
"type": "n8n-nodes-base.merge",
"position": [
1018,
330
],
"parameters": {
"mode": "combine",
"options": [],
"combineBy": "combineByPosition",
"numberInputs": 3
},
"typeVersion": 3.2
},
{
"id": "b7d5b399-12fc-4941-8c4a-d23527cc969d",
"name": "Compose Email HTML",
"type": "n8n-nodes-base.code",
"position": [
1014,
606
],
"parameters": {
"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    <div class=\"section\">\n      <h3>Suggested next steps</h3>\n      <ul>\n        ${nextSteps.map(step => `<li>${step}</li>`).join('')}\n      </ul>\n    </div>`\n  : '';\n\nconst resourcesBlock = resources.length\n  ? `\n    <div class=\"section\">\n      <h3>Helpful resources</h3>\n      <ul>\n        ${resources\n          .map(r => `<li><a href=\"${r.url}\" target=\"_blank\">${r.label}</a></li>`)\n          .join('')}\n      </ul>\n    </div>`\n  : '';\n\n// -------------------------------\n// Final HTML\n// -------------------------------\nconst htmlContent = `\n<!DOCTYPE html>\n<html>\n<head>\n  <style>\n    body {\n      font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Arial, sans-serif;\n      background-color: #f4f6f8;\n      padding: 24px;\n      color: #111827;\n    }\n    .container {\n      max-width: 640px;\n      margin: auto;\n      background: #ffffff;\n      border-radius: 8px;\n      box-shadow: 0 6px 20px rgba(0,0,0,0.08);\n    }\n    .header {\n      padding: 28px;\n      border-bottom: 1px solid #e5e7eb;\n    }\n    .content {\n      padding: 28px;\n      font-size: 15px;\n      line-height: 1.6;\n    }\n    h1 {\n      font-size: 20px;\n      margin: 0 0 12px 0;\n    }\n    h3 {\n      font-size: 16px;\n      margin-bottom: 8px;\n    }\n    .section {\n      margin-top: 24px;\n      padding-top: 16px;\n      border-top: 1px solid #e5e7eb;\n    }\n    ul {\n      padding-left: 18px;\n      margin: 8px 0;\n    }\n    li {\n      margin: 6px 0;\n    }\n    .footer {\n      padding: 20px;\n      font-size: 13px;\n      color: #6b7280;\n      border-top: 1px solid #e5e7eb;\n    }\n    a {\n      color: #2563eb;\n      text-decoration: none;\n    }\n  </style>\n<link rel="preload" as="image" href="https://flowpast.s3.eu-north-1.amazonaws.com/featured_blog_images/107482.webp"><link rel="preload" as="image" href="https://flowpast.s3.eu-north-1.amazonaws.com/featured_blog_images/107482.webp"></head>
\n<body>\n  <div class=\"container\">\n    <div class=\"header\">\n      <h1>Thank you, ${name}</h1>\n      <p>Regarding ${webinarTitle}</p>\n    </div>\n\n    <div class=\"content\">\n      <p>${thankYouMessage}</p>\n\n      ${resourcesBlock}\n      ${nextStepsBlock}\n\n      <p style=\"margin-top:24px;\">\n        If you have any questions or would like to discuss this further, feel free to reply to this email.\n      </p>\n\n      <p>\n        Best regards,<br/>\n        <strong>The Webinar Team</strong>\n      </p>\n    </div>\n\n    <div class=\"footer\">\n      This email was sent in response to feedback you shared after attending our webinar.\n    </div>\n  </div>\n</body>\n</html>\n`;\n\nreturn {\n  email,\n  subject: `Thank you for your feedback \u2013 ${webinarTitle}`,\n  htmlContent\n};\n"
},
"typeVersion": 2
},
{
"id": "35d022c8-fbb9-4ad6-a156-2776274cd140",
"name": "Dispatch Thank You Email",
"type": "n8n-nodes-base.gmail",
"position": [
704,
538
],
"webhookId": "e34f1702-f650-4862-85de-56d899aafe82",
"parameters": {
"sendTo": "={{ $json.email }}",
"message": "={{ $json.htmlContent }}",
"options": {
"appendAttribution": false
},
"subject": "={{ $json.subject }}"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "db8c422a-4b4a-4eba-a308-2a369fe4d7f2",
"name": "Update Feedback Log",
"type": "n8n-nodes-base.googleSheets",
"position": [
340,
612
],
"parameters": {
"columns": {
"value": {
"Sent At": "={{ $now.toISO().slice(0, 10) }}\n",
"Our Reply": "={{ $('Combine Inputs').item.json.aiThankYouMessage }}",
"Email Sent": "={{ $json.labelIds[0] }}",
"row_number": 0,
"feedback_id": "={{ $('Log Initial Feedback').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": [],
"operation": "update",
"sheetName": {
"value": "YOUR_SHEET_NAME"
},
"documentId": {
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4
}
],
"active": true,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Combine Inputs": {
"main": [
[
{
"node": "Compose Email HTML",
"type": "main",
"index": 0
}
]
]
},
"Generate Feedback ID": {
"main": [
[
{
"node": "Standardize Feedback Data",
"type": "main",
"index": 0
}
]
]
},
"Log Initial Feedback": {
"main": [
[
{
"node": "Combine Inputs",
"type": "main",
"index": 1
},
{
"node": "AI Reply Generator",
"type": "main",
"index": 0
},
{
"node": "Shared Resource List",
"type": "main",
"index": 0
}
]
]
},
"Update Feedback Log": {
"main": [
[]
]
},
"AI Reply Generator": {
"main": [
[
{
"node": "Interpret AI Output",
"type": "main",
"index": 0
}
]
]
},
"Compose Email HTML": {
"main": [
[
{
"node": "Dispatch Thank You Email",
"type": "main",
"index": 0
}
]
]
},
"Shared Resource List": {
"main": [
[
{
"node": "Combine Inputs",
"type": "main",
"index": 2
}
]
]
},
"Incoming Feedback Hook": {
"main": [
[
{
"node": "Generate Feedback ID",
"type": "main",
"index": 0
}
]
]
},
"Interpret AI Output": {
"main": [
[
{
"node": "Combine Inputs",
"type": "main",
"index": 0
}
]
]
},
"Standardize Feedback Data": {
"main": [
[
{
"node": "Log Initial Feedback",
"type": "main",
"index": 0
}
]
]
},
"Dispatch Thank You Email": {
"main": [
[
{
"node": "Update Feedback Log",
"type": "main",
"index": 0
}
]
]
}
}
}