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

⚡ 83 views · 💬 Support Chatbots

Description

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 eCommerce, support, or CX teams looking to scale without hiring more agents.

How it works

This workflow captures every new Jotform submission, extracts key fields, and uses OpenAI GPT-4.1 to classify sentiment and root cause.

• Negative feedback or ratings ≤3: Generates a recovery email, logs it in Google Sheets, and alerts your CX team on Slack.
• Positive or neutral feedback: Sends a personalized thank-you email with a link to leave a public review.

All submissions are stored in Google Sheets for analytics and performance tracking.

How to set up

1. Visit Jotform and sign up (if you’re new) or log in to your existing account.
2. Click your profile icon (top-right) → go to Settings.
3. In the left sidebar, open the API section.
4. Click Create New Key.
5. Set permission to Full Access (recommended for full workflow functionality).
6. Copy the generated API key.
7. In n8n, open Credentials → Create New → JotForm API.
8. Paste your API key and save it as JotForm account.
9. Test the connection by running your Jotform Trigger node.

Jotform Configuration Guide (for n8n Feedback Workflow)

Follow these steps to connect your Jotform to n8n:

1️⃣ Create the Feedback Form

Build a form in Jotform with the following exact fields:

• Field Label - Field Type - Example Input
• Full Name - Short Text - Customer Name
• Email - Email - test@gmail.com
• Whatsapp Number - Short Text- 91xxxxxxxxxx
• Order Id - Short Text - #2321
• Ratings - Ratings - 3
• Please describe your experience in detail. - Long Text - “Feedback”
• Would you recommend us to others? - Single Choice (Yes/No) - No

💡 Tip: Keep field labels identical — n8n uses these exact keys for data mapping.

Requirements

• Jotform API key (Full Access)
• OpenAI API key
• SMTP or transactional email service
• Google service account or Authenticate using Oauth2
• Slack token

How to customize

You can easily adjust rating thresholds, AI prompts, or email templates to match your brand’s tone.
The structure is modular — no code changes needed, just edit nodes and re-deploy.

image.png

🔗 Nodes Used

Send Email, Google Sheets, Slack, Jotform Trigger, OpenAI

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup