Automate Habit Form Weekly Summary with Webhook and Supabase
detail.loadingPreview
This n8n workflow automates the processing of weekly habit form submissions. It uses a Webhook Trigger to receive data, a Text Splitter and Embeddings node to prepare it for vector storage, and Supabase Insert to store it. A RAG Agent then summarizes the data, which is appended to a Google Sheet via Append Sheet, with Slack Alert for errors.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow is designed to automatically process and summarize weekly habit form submissions. It leverages n8n's webhook capabilities to receive incoming data, and integrates with Langchain and Supabase for advanced data processing and storage. The core logic involves receiving data via a webhook, splitting and embedding it for vector storage in Supabase, then using a RAG Agent to generate a weekly summary. This summary is then logged to a Google Sheet. This workflow solves the problem of manual data aggregation and summarization of recurring form submissions, saving time and ensuring consistent tracking of habits.
Key Features
- Webhook Trigger: Receives habit form data in real-time.
- Langchain Integration: Utilizes Text Splitter, Embeddings, Chat Model, and RAG Agent for intelligent data processing and summarization.
- Supabase Vector Store: Stores and retrieves embeddings for context-aware summarization.
- Google Sheets Integration: Appends the generated weekly summary to a Google Sheet for easy review.
- Error Alerting: Sends notifications to Slack in case of workflow failures.
How To Use
- Configure the Webhook Trigger node with your desired path (e.g.,
habit-form-weekly-summary). - Set up your OpenAI API credentials for the Embeddings and Chat Model nodes.
- Configure your Supabase credentials and ensure you have a table set up for vector storage (e.g.,
habit_form_weekly_summary). - Configure the Append Sheet node with your Google Sheet ID and desired sheet name (e.g.,
Log). - Set up your Slack credentials to receive error alerts.
- Trigger the webhook with your habit form data to initiate the workflow.
Apps Used
Workflow JSON
{
"id": "3cc0a218-d651-479c-9d25-dec64d865840",
"name": "Automate Habit Form Weekly Summary with Webhook and Supabase",
"nodes": 0,
"category": "Data Processing & Automation",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 3cc0a218-d651...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Automate Fitness API Weekly Reports with n8n
This workflow automates the generation of weekly fitness API reports. It uses a Webhook Trigger to receive data, processes it with Text Splitter and Embeddings, stores it in Supabase, and uses an OpenAI Chat Model and RAG Agent to generate a report, finally logging it to Google Sheets. Error handling is included with a Slack Alert.
Twitter Sentiment Analysis Pipeline to Database and Slack Notification
Automate Twitter sentiment analysis on #OnThisDay tweets. This workflow fetches tweets, stores them in MongoDB, analyzes sentiment with Google Cloud Natural Language, saves results to PostgreSQL, and notifies Slack based on sentiment score.