Automate Survey Analysis with Webhooks and AI

Name: Automate Survey Analysis with Webhooks and AI
Rating: 5 (12 reviews)
Author: Free N8N

Community Verified

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

62 views

0 downloads

AI & Machine Learningautomationgoogle sheetslangchainopenaipineconeragslacksurvey analysiswebhook

This n8n workflow automates survey analysis by triggering via a webhook, splitting text, embedding it, and storing it in Pinecone for AI-powered insights. It then logs the results to a Google Sheet and alerts on errors.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This n8n workflow is designed to automate the analysis of survey responses. It leverages a webhook trigger to receive survey data, then utilizes Langchain nodes to process this data. The text is split into manageable chunks, embedded using OpenAI's models, and then stored in a Pinecone vector database for efficient retrieval and analysis. A RAG (Retrieval Augmented Generation) agent then processes the data, using the vector store for context and a chat model for generating insights. Finally, the results are appended to a Google Sheet for logging and a Slack alert is configured to notify of any errors. This workflow solves the problem of manual, time-consuming survey data analysis by providing a fully automated and intelligent solution.

Key Features

Webhook Trigger: Initiate analysis automatically upon receiving new survey data.
AI-Powered Text Processing: Utilizes Langchain nodes for text splitting, embedding, and AI analysis.
Vector Database Integration: Stores and retrieves data efficiently using Pinecone for context-aware AI responses.
Automated Logging: Appends analysis results directly to a Google Sheet.
Error Alerting: Notifies users via Slack in case of any workflow failures.

How To Use

Set up Webhook: Configure your survey platform to send POST requests to the provided webhook URL.
Configure Langchain Nodes: Ensure your OpenAI and Pinecone API keys are set up in n8n credentials. Customize the model, chunkSize, chunkOverlap, and pineconeIndex parameters as needed.
Configure Google Sheets: Set up your Google Sheets API credentials in n8n and specify the target SHEET_ID and Log sheet name.
Configure Slack Alert: Set up your Slack API credentials and the channel for error notifications.
Run the Workflow: Activate the workflow and test by sending sample survey data to the webhook.

Apps Used

automation

google sheets

langchain

openai

pinecone

rag

slack

survey analysis

webhook

Workflow JSON

{
  "id": "1d973e3a-ea97-4568-9b4a-273fc774678e",
  "name": "Automate Survey Analysis with Webhooks and AI",
  "nodes": 0,
  "category": "AI & Machine Learning",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.