Automatic Topic & Sentiment Extraction from Jotform Responses with Google Gemini
Who this is for This workflow is designed for teams that collect feedback or survey responses via Jotform and want to automatically: - Analyze sentiment (positive, neutral, negative) of each response. - Extract key to...
Template notes
Who this is for This workflow is designed for teams that collect feedback or survey responses via Jotform and want to automatically: - Analyze sentiment (positive, neutral, negative) of each response. - Extract key topics and keywords from qualitative text. - Generate AI summaries and structured insights. - Store results in Google Sheets and n8n DataTables for easy reporting and analysis.
Use Cases - Customer experience analysis - Market research & survey analysis - Product feedback clustering - Support ticket prioritization - AI-powered blog or insight generation from feedback
What this workflow does
This n8n automation connects Jotform, Google Gemini, and Google Sheets to turn raw responses into structured insights with sentiment, topics, and keywords.
Pipeline Overview
Jotform → Webhook → Gemini (Topics + Keywords) → Gemini (Sentiment) → Output Parser → Merge → Google Sheets
Jotform Trigger - Captures each new submission from your Jotform (e.g., a feedback or survey form). - Extracts raw fields ($json.body.pretty) such as name, email, and response text.
Format Form Data (Code Node) - Converts the Jotform JSON structure into a clean string for AI input. - Ensures the text is readable and consistent for Gemini.