📊 Automatic Topic & Sentiment Extraction from Jotform Responses with Google Gemini

⚡ 82 views · 📊 Market Research & Insights

💡 Pro Tip — For competitive intelligence, ScraperNode can automate the data collection — Yelp reviews, Glassdoor company data, and Crunchbase profiles all return structured JSON you can feed straight into this workflow.

View All Scrapers

Description

Who this is for

This workflow is designed for teams that collect feedback or survey responses via Jotform and want to automatically:

Use Cases

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

Format Form Data (Code Node)

Topics & Keyword Extraction (Google Gemini + Output Parser)

Goal: Identify the main themes and important keywords from responses.

{
  "topics": [
    {
      "topic": "Product Features",
      "summary": "Users request more automation templates.",
      "keywords": ["AI templates", "automation", "workflow"],
      "sentiment": "positive",
      "importance_score": 0.87
    }
  ],
  "global_keywords": ["AI automation", "developer tools"],
  "insights": ["Developers desire more creative, ready-to-use AI templates."],
  "generated_at": "2025-10-08T10:30:00Z"
}

Sentiment Analyzer (Google Gemini + Output Parser)

Goal: Evaluate overall emotional tone and priority.

{
  "customer_name": "Ranjan Dailata",
  "customer_email": "ranjancse@gmail.com",
  "feedback_text": "Please build more interesting AI automation templates.",
  "sentiment": "positive",
  "confidence_score": 0.92,
  "key_phrases": ["AI automation templates", "developer enablement"],
  "summary": "Customer requests more AI automation templates to boost developer productivity.",
  "alert_priority": "medium",
  "timestamp": "2025-10-08T10:30:00Z"
}

Merge + Aggregate

Persist Results (Google Sheets)

Visualization (Optional)

Add Sticky Notes or a logo image node in your workflow to:

Example AI Output (Combined)

{
  "feedback_analysis": {
    "customer_name": "Ranjan Dailata",
    "sentiment": "positive",
    "summary": "User appreciates current templates and suggests building more advanced AI automations.",
    "key_phrases": ["AI automation", "developer templates"]
  },
  "topics_keywords": {
    "topics": [
      {
        "topic": "AI Template Expansion",
        "keywords": ["AI automation", "workflow templates"],
        "sentiment": "positive",
        "importance_score": 0.9
      }
    ],
    "global_keywords": ["automation", "AI development"]
  }
}

Setup Instructions

Pre-requisite

If you are new to Jotform, Please do signup using Jotform Signup

For the purpose of demonstation, we are considering the Jotforms Prebuilt New Customer Registration Form as a example. However, you are free to consider for any of the form submissions.

image.png

Step 0: Local n8n (Optional)

If using local n8n, set up ngrok:

ngrok http 5678

Use the generated public URL as your Webhook URL base for Jotform integration.

Step 1: Configure the Webhook

n8n-workflow

Jotform-Webhook-Integration

Step 2: Connect Google Gemini

Step 3: Create Data Storage

Step 4: Connect Google Sheets

Step 5: Test the Workflow

Customization Tips

Change the Prompt

You can modify the topic extraction prompt to highlight specific themes:

You are a research analyst. Extract main topics, keywords, and actionable insights from this feedback: {{ $json.body }}

Extend the Output Schema

Add more fields like:

{
  "suggested_blog_title": "",
  "tone": "",
  "recommendations": []
}

Then update your DataTable or Sheets schema accordingly.

Integration Ideas

Summary

This workflow turns raw Jotform submissions into actionable insights using Google Gemini AI — extracting topics, keywords, and sentiment while automatically logging everything to Google Sheets.

🔗 Nodes Used

Google Sheets, Jotform Trigger, Basic LLM Chain, Structured Output Parser, Google Gemini Chat Model

📥 Import

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

📖 Importing guide · 🔑 Credential setup