Jotform Feedback Analysis with Gemini AI - n8n Workflow

• Businesses that collect customer feedback or survey responses via Jotform.


• Data analysts and marketing teams needing instant, structured analysis of textual data.


• n8n users looking for advanced examples of parallel processing and structured AI output parsing.


• Operations specialists who want to automate data processing using a robust n8n workflow template.

Manually sorting and analyzing large volumes of feedback from online forms is time-consuming and prone to human error. This specialized n8n workflow solves this by instantly analyzing every new Jotform submission using Google Gemini, one of the leading generative AI models. The value of this n8n template lies in its ability to simultaneously perform two critical analyses—detailed sentiment analysis and comprehensive topic/keyword extraction—and enforce strict JSON output schemas on the AI results. The fully structured data is then written directly to Google Sheets, providing a clean, actionable dataset for immediate reporting, eliminating manual ETL steps. This powerful n8n node configuration ensures data quality and processing speed.

This automation begins with the JotForm n8n trigger, which activates the workflow upon the submission of a new form response.

1. Trigger and Formatting: The JotForm n8n trigger captures the raw data. It passes this data to the Format the Form Data Code n8n node, which standardizes the input JSON for prompt injection into the language models.


2. Parallel AI Processing: The flow then splits into two parallel branches, both using the Google Gemini Chat Model:

1. Data Aggregation: The results from both AI branches, now in structured JSON format, are collected by the Merge n8n node. The subsequent Aggregate n8n node combines these two distinct outputs into a single data item ready for storage.


2. Final Logging: The final Append or update row in sheet Google Sheets n8n node writes the comprehensive, AI-analyzed data into the designated spreadsheet, completing the automated n8n workflow.

To deploy this powerful n8n workflow template, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and paste it into your n8n instance using the 'New' button and 'Import from JSON'.


2. JotForm Setup: Click the JotForm Trigger n8n node and set up your JotForm API credentials. Select the specific form ID you want to monitor. This n8n trigger requires activation to listen for incoming submissions.


3. Google Gemini Credentials: Configure the Google Gemini credentials (used by both Chat Model n8n nodes) to enable AI processing. Note that the workflow uses the models/gemini-2.0-flash-exp model.


4. Google Sheets Setup: Update the Append or update row in sheet n8n node with your Google Sheets credentials and link it to the target spreadsheet where you want the structured analysis logged. Ensure your sheet columns match the data keys being passed (e.g., topicskeywords and feedbackanalysis).


5. Activate: Set the n8n workflow status to 'Active'.

This n8n workflow relies on several specialized n8n node types for its efficiency:

JotForm Trigger: The entry point. It is configured to monitor a specific form ID and acts as the n8n trigger for execution.
Format the Form Data (Code n8n node): Essential pre-processing step. It converts the raw incoming form data into a structured string wrapped in a body key for clean injection into the AI prompts.
Google Gemini Chat Model (LangChain n8n node): Used in both AI branches. It facilitates the conversation with the Gemini AI engine, specified using the models/gemini-2.0-flash-exp model.
Sentiment Analyzer / Topics & Keywords (LangChain LLM Chain n8n nodes): These are the core processing n8n nodes. They define the specific roles ('expert sentiment analyzer') and the user prompts sent to Gemini.
Structured Output Parser (LangChain n8n node): Crucial for data integrity. These n8n nodes use comprehensive JSON Schemas to force the AI output into predictable formats (including specific keys like sentiment, keyphrases, topics, and importancescore).
Merge & Aggregate n8n nodes: Used post-AI to combine the parallel results from the two analysis streams into a unified object.

• Append or update row in sheet (Google Sheets n8n node): The final action. It appends the aggregated, structured AI output to the designated Google Sheet, ensuring that the two large JSON outputs (topicskeywords and feedbackanalysis) are correctly stored.