January 21, 2026

Jotform to Google Sheets, feedback sorted and logged

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your feedback form is working. The problem is what happens after: someone has to read every submission, decide what it is, copy it into a sheet, ping the right channel, and maybe reply. Miss one angry message and you will hear about it.

This Jotform Sheets automation hits support leads first, but product managers and busy ops owners feel it too. You get triage, alerts for urgent issues, and consistent replies without living in your inbox.

Below you’ll see exactly how the workflow routes comments, questions, and suggestions, then logs everything neatly in Google Sheets (with Telegram alerts and Gmail replies when it matters).

How This Automation Works

Here’s the complete workflow you’ll be setting up:

n8n Workflow Template: Jotform to Google Sheets, feedback sorted and logged

Click to explore

flowchart LR

    subgraph sg0["Jotform Intake 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/jotform.dark.svg' width='40' height='40' /></div><br/>Jotform Intake Trigger"]
        n1@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Route Feedback Type", pos: "b", h: 48 }
        n2@{ icon: "mdi:brain", form: "rounded", label: "Gemini Chat Engine A", pos: "b", h: 48 }
        n3@{ icon: "mdi:brain", form: "rounded", label: "Gemini Chat Engine B", pos: "b", h: 48 }
        n4@{ icon: "mdi:robot", form: "rounded", label: "Assess Sentiment", pos: "b", h: 48 }
        n5["<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/telegram.svg' width='40' height='40' /></div><br/>Alert Support Channel"]
        n6@{ icon: "mdi:message-outline", form: "rounded", label: "Send Customer Reply", pos: "b", h: 48 }
        n7@{ icon: "mdi:database", form: "rounded", label: "Load FAQ Sheet", pos: "b", h: 48 }
        n8@{ icon: "mdi:robot", form: "rounded", label: "Answer Assistant", pos: "b", h: 48 }
        n9@{ icon: "mdi:robot", form: "rounded", label: "Summarize Ideas", 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/telegram.svg' width='40' height='40' /></div><br/>Notify Product Chat"]
        n11@{ icon: "mdi:database", form: "rounded", label: "Log Suggestions Sheet", pos: "b", h: 48 }
        n12@{ icon: "mdi:database", form: "rounded", label: "Record Comments Sheet", pos: "b", h: 48 }
        n1 --> n4
        n1 --> n8
        n1 --> n9
        n8 --> n6
        n7 -.-> n8
        n0 --> n1
        n4 --> n12
        n4 --> n5
        n10 --> n11
        n5 --> n12
        n9 --> n10
        n2 -.-> n4
        n3 -.-> n8
        n3 -.-> n9
    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 n0 trigger
    class n4,n8,n9 ai
    class n2,n3 aiModel
    class n1 decision
    class n7,n11,n12 database
    classDef customIcon fill:none,stroke:none
    class n0,n5,n10 customIcon

Why This Matters: Feedback Triage Gets Messy Fast

Jotform makes it easy to collect feedback. It does not make it easy to deal with it. Every submission arrives as a blob of text, and a human has to decide: is this a complaint, a question, or a feature request? Then comes the follow-up. Someone pings the team, writes a reply, and tries to keep a “backlog” sheet updated. Honestly, that process breaks the moment you get busy. Small delays turn into missed issues, duplicated work, and inconsistent customer communication.

The friction compounds. Here’s where it breaks down in real life.

Important messages get buried because everything lands in the same place and looks the same at a glance.
Manually copying feedback into Google Sheets takes about 5 minutes per entry, and it’s easy to paste into the wrong column.
Angry customers wait the longest because “urgent” is often decided too late.
Replies drift over time, which means your team sounds inconsistent (and you end up rewriting the same answers again).

What You’ll Build: Auto-Triage + Alerts + Clean Logging

This workflow turns every new Jotform submission into an organized, trackable next step. When a customer submits feedback, n8n immediately routes it by type (comments, questions, or suggestions). It then analyzes sentiment so negative or angry messages can be treated differently, not “sometime later when someone reads the inbox.” Questions get an automatic reply through Gmail, generated by an AI agent that checks your internal FAQ sheet first. Suggestions are summarized, posted to a team Telegram chat, and appended to a backlog in Google Sheets with the key details. Meanwhile, comments still get recorded in a structured sheet for reporting and trends.

The workflow starts with Jotform intake, then splits into three paths using a Switch. AI handles sentiment and drafting, while Google Sheets becomes your system of record. Telegram and Gmail handle the two moments that actually need speed: urgent alerts and customer replies.

What You’re Building

What Gets Automated

What You’ll Achieve

New Jotform submissions are automatically routed into comments, questions, or suggestions.
Sentiment is analyzed so negative messages can be flagged immediately.
Questions trigger an AI agent that consults your Google Sheets “Q&A” tab before writing a reply.
Suggestions are summarized and logged into a Google Sheets backlog with name, email, summary, and date.

Most teams get about 2 hours back each week once volume picks up.
Urgent feedback reaches the right people in Telegram within a minute, not after an inbox review.
Your backlog stays clean because the same columns are filled the same way every time.
Customers get faster, more consistent replies to common questions.
You end up with structured data for reporting instead of a messy export file.

Expected Results

Say you get 20 submissions a week. Manually, it’s usually about 5 minutes to read and label each one, another 5 minutes to log it, plus extra time to alert the team or reply, so you’re at roughly 3 hours weekly. With this workflow, the “human time” becomes a quick scan of the sheet and only stepping in for edge cases, maybe 20 minutes total. The rest runs in the background while your team keeps working.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Jotform for collecting feedback submissions
Google Sheets to store the FAQ and backlog
Gmail to send customer replies automatically
Telegram for urgent alerts and team notifications
LLM API key (get it from your Gemini/OpenAI provider)

Skill level: Beginner. You’ll map a few fields, connect accounts, and paste in sheet IDs.

Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).

Step by Step

A new Jotform submission comes in. The workflow triggers the moment someone submits your feedback form, using the fields you mapped (name, email, and the feedback text).

The message is categorized and scored. A routing step sorts it into comments, questions, or suggestions, then sentiment analysis checks the tone so the workflow can treat “angry” differently from “neutral.”

Questions get answered using your own FAQ sheet. The AI agent loads your Google Sheets Q&A database, drafts a helpful response, and Gmail sends it as a styled HTML email so it still feels like a real support reply.

Suggestions and comments are logged for visibility. Suggestions are summarized, pushed to Telegram for the team, and appended to a backlog sheet. Comments are recorded in a structured comments sheet for reporting and trend spotting.

You can easily modify the categories and the sentiment threshold to match how your team defines “urgent.” See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Jotform Trigger

This workflow starts when a Jotform submission is received by Jotform Intake Trigger.

Add Jotform Intake Trigger and set Form to [YOUR_ID].
Credential Required: Connect your jotFormApi credentials.
Optionally keep Flowpast Branding as a workspace note; no configuration is required.

Use a real Jotform submission during testing to verify field names like Feedback Type, E-mail, and Describe Your Feedback:.

Step 2: Configure Feedback Routing Logic

Route Feedback Type splits submissions into comments, questions, and suggestions.

In Route Feedback Type, set the first rule’s Left Value to {{ $json['Feedback Type'].toLowerCase() }} and Right Value to comments.
Set the second rule’s Left Value to {{ $json['Feedback Type'].toLowerCase() }} and Right Value to questions.
Set the third rule’s Left Value to {{ $json['Feedback Type'].toLowerCase() }} and Right Value to suggestions.
Connect Jotform Intake Trigger → Route Feedback Type.

⚠️ Common Pitfall: If your Jotform field is not named exactly Feedback Type, the switch rules will never match and downstream nodes won’t run.

Step 3: Connect Google Sheets Data Sources

The workflow reads FAQ data and logs feedback into Google Sheets.

In Load FAQ Sheet, set Document to [YOUR_ID] and Sheet Name to [YOUR_ID].
Load FAQ Sheet is an AI tool connected to Answer Assistant — add Google Sheets credentials in Answer Assistant, not the tool itself.
In Record Comments Sheet, set Operation to append, Document to [YOUR_ID], and Sheet Name to [YOUR_ID].
Map columns in Record Comments Sheet using expressions like {{ $json.Name.first }} {{ $json.Name.last }}, {{ $json['E-mail'] }}, {{ $json['Describe Your Feedback:'] }}, {{ $json.sentimentAnalysis.category }}, and {{ DateTime.now().format('yyyy-MM-dd') }}.
In Log Suggestions Sheet, set Operation to append, Document to [YOUR_ID], and Sheet Name to [YOUR_ID].
Map Log Suggestions Sheet columns with {{ $('Route Feedback Type').item.json.Name.first }} {{ $('Route Feedback Type').item.json.Name.last }}, {{ $('Route Feedback Type').item.json['E-mail'] }}, {{ $('Summarize Ideas').item.json.output.text }}, {{ $('Route Feedback Type').item.json['Describe Your Feedback:'] }}, and {{ DateTime.now().format('yyyy-MM-dd') }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials for Record Comments Sheet and Log Suggestions Sheet.

Keep your Google Sheet headers aligned with the column names in the mapping (e.g., Name, Email, Summary) to avoid write errors.

Step 4: Set Up AI Processing and Sentiment Analysis

Gemini models power sentiment analysis, Q&A answering, and idea summarization.

Configure Gemini Chat Engine A with your Google Gemini settings.
Credential Required: Connect your googlePalmApi credentials for Gemini Chat Engine A.
Link Gemini Chat Engine A to Assess Sentiment as the language model.
In Assess Sentiment, set Input Text to {{ $json['Describe Your Feedback:'] }}.
Configure Gemini Chat Engine B and set Temperature to 0.4.
Credential Required: Connect your googlePalmApi credentials for Gemini Chat Engine B.
Link Gemini Chat Engine B to both Answer Assistant and Summarize Ideas as the language model.
In Answer Assistant, set Text to user: {{ $json['Describe Your Feedback:'] }} and keep Prompt Type as define. Keep the full System Message as provided to enforce tone and FAQ usage.
Connect Load FAQ Sheet to Answer Assistant as an AI tool.

⚠️ Common Pitfall: If Load FAQ Sheet isn’t connected as an AI tool to Answer Assistant, the assistant will answer without your FAQ context.

Step 5: Configure Notifications and Customer Responses

Alerts and customer replies are delivered via Telegram and Gmail based on routed feedback.

In Alert Support Channel, set Chat ID to [YOUR_ID] and Text to the full alert template: 🚨Customer Angry🚨 ....
Credential Required: Connect your telegramApi credentials for Alert Support Channel.
In Notify Product Chat, set Chat ID to [YOUR_ID] and Text to Suggestions from {{ $('Route Feedback Type').item.json.Name.first }} {{ $('Route Feedback Type').item.json.Name.last }} ....
Credential Required: Connect your telegramApi credentials for Notify Product Chat.
In Send Customer Reply, set Send To to {{ $('Route Feedback Type').item.json['E-mail'] }}.
Set Subject to AquaPure Smart Bottle - {{ $('Route Feedback Type').item.json['Describe Your Feedback:'] }} and keep the full HTML Message template intact.
Credential Required: Connect your gmailOAuth2 credentials for Send Customer Reply.
Ensure connections follow the execution flow: Answer Assistant → Send Customer Reply, Summarize Ideas → Notify Product Chat → Log Suggestions Sheet, and Assess Sentiment → Alert Support Channel and Record Comments Sheet.

Use Telegram test chats and a sandbox Gmail account before moving to production channels.

Step 6: Test and Activate Your Workflow

Validate each route and output before turning the workflow on.

Click Execute Workflow and submit a Jotform entry for each feedback type: comments, questions, and suggestions.
Confirm successful outputs: Telegram alerts from Alert Support Channel, product summaries from Notify Product Chat, email replies from Send Customer Reply, and rows appended to Record Comments Sheet and Log Suggestions Sheet.
When testing is complete, switch the workflow to Active so new Jotform submissions trigger the automation.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

Google Sheets access often fails because the connected Google account can’t see the target spreadsheet. Check the file’s sharing settings and confirm the correct spreadsheet and tab are selected in the Sheets nodes.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Gmail can silently refuse sends if you’re hitting daily limits or using the wrong “From” identity. Verify the sending account, confirm aliases, and test with one email before turning on full volume.

Quick Answers

What’s the setup time for this Jotform Sheets automation automation?

About 30 minutes if your accounts and sheets are ready.

Is coding required for this feedback triage?

No. You connect your apps and map a few fields in n8n.

Is n8n free to use for this Jotform Sheets automation 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 LLM API costs for sentiment analysis and drafted replies.

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 modify this Jotform Sheets automation workflow for different use cases?

Yes, and you should. You can change categories in the “Route Feedback Type” Switch, tweak the “Assess Sentiment” thresholds, and swap the destination sheets in “Log Suggestions Sheet” and “Record Comments Sheet.” Many teams also customize the “Send Customer Reply” Gmail HTML template so it matches brand voice and adds links to docs or booking pages.

Why is my Google Sheets connection failing in this workflow?

Usually it’s permissions. The Google account connected in n8n must have access to the spreadsheet, and the tab name has to match what the node expects. If it worked once and then stopped, reselect the spreadsheet in the node to refresh the file reference.

What volume can this Jotform Sheets automation workflow process?

On most setups, hundreds of submissions a day is realistic as long as your email and LLM limits can keep up. n8n Cloud plans cap monthly executions by plan, while self-hosting has no execution cap (your server is the limit). The heaviest parts are the AI steps and sending lots of emails, so that’s where you’ll feel scaling first.

Is this Jotform Sheets automation automation better than using Zapier or Make?

Often, yes, because this workflow isn’t just “send data from A to B.” You’re branching by type, running sentiment analysis, consulting a knowledge base sheet, and generating replies. n8n handles that kind of logic cleanly, and self-hosting can keep costs predictable when volume grows. Zapier or Make can still work if you simplify the process to basic routing and logging, but the AI agent and multi-path flow gets clunky fast. If you’re on the fence, Talk to an automation expert and we’ll help you pick the right approach.

Once this is live, feedback stops being a daily cleanup job. The workflow handles the sorting, logging, and first response so your team can focus on the real fixes.

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": null,
"meta": {
"instanceId": "60b1e10655316ae7c1149eacb100157808ea3f76abf61173d1fb67cd36e0b4af",
"templateCredsSetupCompleted": null,
"templateId": null
},
"name": "Automated Feedback Triage Workflow",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-9636",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 850,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "db688133-4596-47b2-9d63-5e91bc73753f",
"name": "Jotform Intake Trigger",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
0,
175
],
"webhookId": "REDACTED",
"parameters": {
"form": "[YOUR_ID]"
},
"credentials": {
"jotFormApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "9ebab0dd-5bac-443a-98ab-d30eff4b458a",
"name": "Route Feedback Type",
"type": "n8n-nodes-base.switch",
"position": [
145,
265
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "comments",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8868d5a6-f386-4f9d-bb65-b4373617bbf6",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json['Feedback Type'].toLowerCase() }}",
"rightValue": "comments"
}
]
},
"renameOutput": true
},
{
"outputKey": "questions",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6a821715-e994-4e85-8da3-9ba3b8e98bb5",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json['Feedback Type'].toLowerCase() }}",
"rightValue": "questions"
}
]
},
"renameOutput": true
},
{
"outputKey": "suggestions",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3eca34e9-2a95-424c-bfe7-2e2aa6092492",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json['Feedback Type'].toLowerCase() }}",
"rightValue": "suggestions"
}
]
},
"renameOutput": true
}
]
},
"options": []
},
"typeVersion": 3.3
},
{
"id": "efa026b3-0b2e-4ee7-8074-493902a91265",
"name": "Gemini Chat Engine A",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
180,
120
],
"parameters": {
"options": []
},
"credentials": {
"googlePalmApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "75bd3135-b303-4fed-95e4-50c2f8950f1a",
"name": "Gemini Chat Engine B",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
175,
565
],
"parameters": {
"options": {
"temperature": 0.4
}
},
"credentials": {
"googlePalmApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "631e6076-06f9-44c7-b2d3-2b9ed406cc5f",
"name": "Assess Sentiment",
"type": "@n8n/n8n-nodes-langchain.sentimentAnalysis",
"position": [
425,
235
],
"parameters": {
"options": [],
"inputText": "={{ $json['Describe Your Feedback:'] }}"
},
"typeVersion": 1.1
},
{
"id": "6b25a8c3-85c3-422b-8128-416afe44b98a",
"name": "Alert Support Channel",
"type": "n8n-nodes-base.telegram",
"position": [
610,
145
],
"webhookId": "REDACTED",
"parameters": {
"text": "=\ud83d\udea8Customer Angry\ud83d\udea8\n\nName: {{ $json.Name.first }} {{ $json.Name.last }}\nEmail: {{ $json['E-mail'] }}\n\nMessage: {{ $json['Describe Your Feedback:'] }}\n\nPlease reach out immediately \u2014 your SLA is only 6 hours.\n\n",
"chatId": "[YOUR_ID]",
"additionalFields": []
},
"credentials": {
"telegramApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "a0399c2f-8d4a-4ac5-ac55-7c086fd74f7b",
"name": "Send Customer Reply",
"type": "n8n-nodes-base.gmail",
"position": [
640,
385
],
"webhookId": "REDACTED",
"parameters": {
"sendTo": "={{ $('Route Feedback Type').item.json['E-mail'] }}",
"message": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n  <meta charset=\"UTF-8\">\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n  <title>AquaPure Smart Bottle Response</title>\n  <style>\n    body {\n      font-family: Arial, Helvetica, sans-serif;\n      background-color: #f6f8fa;\n      color: #333;\n      margin: 0;\n      padding: 0;\n    }\n    .email-container {\n      max-width: 600px;\n      margin: 30px auto;\n      background: #ffffff;\n      padding: 24px;\n      border-radius: 8px;\n      box-shadow: 0 2px 8px rgba(0,0,0,0.05);\n    }\n    p {\n      line-height: 1.6;\n      margin: 0 0 12px;\n    }\n    .question, .answer {\n      background-color: #f1f5f9;\n      padding: 12px;\n      border-radius: 6px;\n      margin-bottom: 16px;\n    }\n    .footer {\n      margin-top: 24px;\n      font-size: 14px;\n      color: #666;\n    }\n  </style>\n<link rel="preload" as="image" href="https://flowpast.s3.eu-north-1.amazonaws.com/featured_blog_images/106218.webp"><link rel="preload" as="image" href="https://flowpast.s3.eu-north-1.amazonaws.com/featured_blog_images/106218.webp"></head>
\n<body>\n  <div class=\"email-container\">\n    <p>\n      Dear {{ $('Route Feedback Type').item.json.Name.first }} {{ $('Route Feedback Type').item.json.Name.last }},\n    </p>\n\n    <p>Thank you for your interest in <strong>AquaPure Smart Bottle</strong>.</p>\n\n    <div class=\"question\">\n      <strong>Question:</strong><br>\n      {{ $('Route Feedback Type').item.json['Describe Your Feedback:'] }}\n    </div>\n\n    <div class=\"answer\">\n      <strong>Answer:</strong><br>\n      {{ $json.output }}\n    </div>\n\n    <p class=\"footer\">\n      Best regards,<br>\n      <strong>Jotform</strong>\n    </p>\n  </div>\n</body>\n</html>",
"options": [],
"subject": "=AquaPure Smart Bottle - {{ $('Route Feedback Type').item.json['Describe Your Feedback:'] }}"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "723d81fc-924b-46d2-b146-3544470daaa0",
"name": "Load FAQ Sheet",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
170,
480
],
"parameters": {
"options": [],
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "qna"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "[YOUR_ID]"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "5607dc4f-d50f-4425-824e-2462bf09ce20",
"name": "Answer Assistant",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
415,
345
],
"parameters": {
"text": "=user: {{ $json['Describe Your Feedback:'] }}",
"options": {
"systemMessage": "=# Role\n- you're a helpful assistant to answer user question\n- always respond in warm tone\n\n# Context\n- you must read the google sheets for getting the answer\n- paraphrase the result so user can easily understand\n\n# Important restrictions\n- keep polite and use a proper language"
},
"promptType": "define"
},
"typeVersion": 2.2
},
{
"id": "5162281b-fe6d-454d-88a4-7667b3b8d5c8",
"name": "Summarize Ideas",
"type": "@n8n/n8n-nodes-langchain.chainSummarization",
"position": [
430,
575
],
"parameters": {
"options": []
},
"typeVersion": 2.1
},
{
"id": "97913d99-2fe8-4afa-97b6-39627337f11a",
"name": "Notify Product Chat",
"type": "n8n-nodes-base.telegram",
"position": [
560,
640
],
"webhookId": "REDACTED",
"parameters": {
"text": "=Suggestions from {{ $('Route Feedback Type').item.json.Name.first }} {{ $('Route Feedback Type').item.json.Name.last }}\nEmail: {{ $('Route Feedback Type').item.json['E-mail'] }}\n\nSummary: {{ $json.output.text }}\n\nFull: {{ $('Route Feedback Type').item.json['Describe Your Feedback:'] }}",
"chatId": "[YOUR_ID]",
"additionalFields": []
},
"credentials": {
"telegramApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "43158b87-1336-417d-bbd0-6245f6adaa8e",
"name": "Log Suggestions Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
750,
665
],
"parameters": {
"columns": {
"value": {
"Name": "={{ $('Route Feedback Type').item.json.Name.first }} {{ $('Route Feedback Type').item.json.Name.last }}",
"Email": "={{ $('Route Feedback Type').item.json['E-mail'] }}",
"Summary": "={{ $('Summarize Ideas').item.json.output.text }}",
"Suggestions": "={{ $('Route Feedback Type').item.json['Describe Your Feedback:'] }}",
"Created Date": "={{ DateTime.now().format('yyyy-MM-dd') }}"
},
"schema": [
{
"id": "Created Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Created Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Suggestions",
"type": "string",
"display": true,
"required": false,
"displayName": "Suggestions",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "suggestions"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "[YOUR_ID]"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "4a67e4c3-13c7-497c-9ed4-bdf81123e0d2",
"name": "Record Comments Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
710,
290
],
"parameters": {
"columns": {
"value": {
"Name": "={{ $json.Name.first }} {{ $json.Name.last }}",
"Email": "={{ $json['E-mail'] }}",
"Comments": "={{ $json['Describe Your Feedback:'] }}",
"Sentiment": "={{ $json.sentimentAnalysis.category }}",
"Created Date": "={{ DateTime.now().format('yyyy-MM-dd') }}"
},
"schema": [
{
"id": "Created Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Created Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sentiment",
"type": "string",
"display": true,
"required": false,
"displayName": "Sentiment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comments",
"type": "string",
"display": true,
"required": false,
"displayName": "Comments",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"useAppend": false
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "comments"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "database"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Route Feedback Type": {
"main": [
[
{
"node": "Assess Sentiment",
"type": "main",
"index": 0
}
],
[
{
"node": "Answer Assistant",
"type": "main",
"index": 0
}
],
[
{
"node": "Summarize Ideas",
"type": "main",
"index": 0
}
]
]
},
"Answer Assistant": {
"main": [
[
{
"node": "Send Customer Reply",
"type": "main",
"index": 0
}
]
]
},
"Load FAQ Sheet": {
"ai_tool": [
[
{
"node": "Answer Assistant",
"type": "ai_tool",
"index": 0
}
]
]
},
"Jotform Intake Trigger": {
"main": [
[
{
"node": "Route Feedback Type",
"type": "main",
"index": 0
}
]
]
},
"Assess Sentiment": {
"main": [
[
{
"node": "Record Comments Sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "Record Comments Sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "Alert Support Channel",
"type": "main",
"index": 0
}
]
]
},
"Notify Product Chat": {
"main": [
[
{
"node": "Log Suggestions Sheet",
"type": "main",
"index": 0
}
]
]
},
"Alert Support Channel": {
"main": [
[
{
"node": "Record Comments Sheet",
"type": "main",
"index": 0
}
]
]
},
"Summarize Ideas": {
"main": [
[
{
"node": "Notify Product Chat",
"type": "main",
"index": 0
}
]
]
},
"Record Comments Sheet": {
"main": [
[]
]
},
"Gemini Chat Engine A": {
"ai_languageModel": [
[
{
"node": "Assess Sentiment",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Gemini Chat Engine B": {
"ai_languageModel": [
[
{
"node": "Answer Assistant",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Summarize Ideas",
"type": "ai_languageModel",
"index": 0
}
]
]
}
}
}