Templates / Generate personalized and aggregate survey reports with Jotform and Gemini AI

Generate personalized and aggregate survey reports with Jotform and Gemini AI

Ready for 3.0

by Roshan Ramani ✓ · 256 views · created 2025-10-11 · Market Research, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 17 nodes and runs on Jotform events (plus 1 other trigger). Along the way it connects Jot Form, Google Gemini Chat Model and Gmail. It also calls api.jotform.com over HTTP.

How it runs

Trigger: On Jotform events (plus 1 other trigger).

  1. Collect Individual Response (Aggregate): combines items into one
  2. Fetch Survey Submissions (HTTP Request): calls api.jotform.com
  3. Generate Personal Report (AI Agent): runs an AI agent, with model: Gemini LLM (Personal); output parser: Parse Personal Report JSON
  4. Unpack Response Objects (Split Out): splits a list into separate items
  5. Response Ready - Pause (Wait): pauses before continuing
  6. Normalize Response Fields (Edit Fields (Set)): sets 2 fields: content.id, content.answers
  7. Send Personal Report (Gmail): uses Gmail
  8. Extract Q&A Pairs (Code): runs custom JavaScript code
  9. Merge All Responses (Aggregate): combines items into one
  10. Analyze & Report (AI Agent): runs an AI agent, with model: Gemini LLM; output parser: Structured Output Parser

…plus 1 more step. See the full node list below.

Services it uses

Jot FormGoogle Gemini Chat ModelGmail

HTTP calls to: api.jotform.com

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (12)

From the author

Generate Personalized & Aggregate Survey Reports with Jotform and Gemini AI Overview Automatically transform Jotform survey responses into intelligent, professional reports. This workflow generates personalized insights for each respondent and statistical…

Excerpt from Roshan Ramani's description on n8n.io.

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.