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 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. Topics & Keyword Extraction (Google Gemini + Output Parser) Goal: Identify the main themes and important keywords from responses. Sentiment Analyzer (Google Gemini + Output Parser) Goal: Evaluate overall emotional tone and priority. Merge + Aggregate - Combines the topic/keyword extraction and sentiment output into a single structured dataset. - Aggregates both results for unified reporting. Persist Results (Google Sheets) - Writes combined output into your connected Google Sheet. - Two columns recommended: - feedbackanalysis → Sentiment + Summary JSON - topicskeywords → Extracted Topics + Keywords JSON - Enables easy visualization, filtering, and reporting. Visualization (Optional) Add Sticky Notes or a logo image node in your workflow to: - Visually describe sections (e.g., “Sentiment Analysis”, “Topic Extraction”). - Embed brand logo: Example AI Output (Combined) 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. Step 0: Local n8n (Optional) If using local n8n, set up ngrok: Use the generated public URL as your Webhook URL base for Jotform integration. Step 1: Configure the Webhook - Copy the Webhook URL generated by n8n (e.g., /webhook-test/f3c34cda-d603-4923-883b-500576200322). You can copy the URL by double clicking on the Webhook node. Make sure to replace the base url with the above Step 0, if you are running the workflow from your local machine. - In Jotform, go to your form → Settings → Integrations → Webhooks → paste this URL. - Now, every new form submission will trigger the n8n workflow. Step 2: Connect Google Gemini - Create a Google Gemini API Credential in n8n. - Select the model models/gemini-2.0-flash-exp. Step 3: Create Data Storage - Create a DataTable named JotformFeedbackInsights with columns: - feedbackanalysis (string) - topicskeywords (string) Step 4: Connect Google Sheets - Add credentials under Google Sheets OAuth2. - Link to your feedback tracking sheet. Step 5: Test the Workflow - Submit a form via Jotform. - Check results: - AI nodes return structured JSON. - Google Sheet updates with new records. Customization Tips Change the Prompt You can modify the topic extraction prompt to highlight specific themes: Extend the Output Schema Add more fields like: Then update your DataTable or Sheets schema accordingly. Integration Ideas - Send sentiment alerts to Slack for high-priority feedback. - Push insights into Notion, Airtable, or HubSpot. - Generate weekly reports summarizing trends across all submissions. 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.