Automated customer feedback analysis & response with Jotform, GPT-4.1 & Google Sheets

by Aayushman Sharma ✓ · 140 views · created 2025-10-14 · Support Chatbot, AI Summarization

What this workflow does

This AI workflow has 13 nodes and runs on Jotform events. Along the way it connects Jot Form, OpenAI, Slack and Google Sheets.

How it runs

Trigger: On Jotform events.

1. Extract Key Fields (Normalize Input) (Edit Fields (Set)): sets 8 fields: submissionId, fullName, email…
2. AI Analysis — Sentiment & Root Cause (OpenAI): uses OpenAI
3. Check if Feedback is Negative or Rating ≤ (If): checks a condition and branches into true / false
4. AI Generator — Personalized Recovery Message (OpenAI): uses OpenAI
5. Prepare Data for Sheet & Notifications (Positive Path) (Edit Fields (Set)): sets 13 fields: Submission Id, Full Name, Email…
6. Prepare Data for Sheet & Notifications (Negative Path) (Edit Fields (Set)): sets 17 fields: Submission Id, Full Name, Email…
7. Log Feedback in Google Sheet (Positive Path) (Google Sheets): append
8. Send Appreciation Email (Positive Path) (Send Email): sends an email over SMTP
9. Log Feedback in Google Sheet (Negative Path) (Google Sheets): append
10. Send Recovery Email (Negative Path) (Send Email): sends an email over SMTP

…plus 2 more steps. See the full node list below.

Services it uses

Jot FormOpenAISlackGoogle Sheets

Before you upgrade to n8n 3.0

Nodes used (7)

• Jotform Triggern8n-nodes-base.jotFormTrigger
• Edit Fields (Set)n8n-nodes-base.set
• OpenAI@n8n/n8n-nodes-langchain.openAi
• Ifn8n-nodes-base.if
• Send Emailn8n-nodes-base.emailSend
• Slackn8n-nodes-base.slack
• Google Sheetsn8n-nodes-base.googleSheets

From the author

AI-powered feedback analysis and response automation from Jotform to Google Sheets and Slack Who’s it for Businesses using Jotform to collect customer feedback who want to automate sentiment analysis, email responses, and internal reporting — especially…

View the original on n8n.io → Check your own copy