Smart Hydration Tracker with RAG AI
detail.loadingPreview
Transform your hydration habit with an intelligent AI assistant. This workflow leverages Retrieval Augmented Generation (RAG), vector databases, and conversational memory to track your water intake, provide smart insights, and log progress effortlessly.
About This Workflow
This n8n workflow creates a sophisticated AI assistant dedicated to optimizing your hydration. Triggered by a simple webhook, it processes your hydration data, splits it into manageable chunks, and generates embeddings using OpenAI. These embeddings are then stored in a Supabase vector database, forming a dynamic knowledge base. An OpenAI RAG agent, equipped with conversational memory and the ability to query your hydration data from Supabase, processes incoming requests. It can answer questions, log intake, and provide personalized reminders. All agent outputs are meticulously logged into a Google Sheet for easy tracking, and critical errors are immediately reported via Slack, ensuring a robust and reliable hydration monitoring system.
Key Features
- AI-Powered RAG Agent: Utilizes OpenAI's Retrieval Augmented Generation (RAG) to provide intelligent, context-aware responses and insights about your hydration.
- Dynamic Knowledge Base: Stores and retrieves hydration-related data efficiently using Supabase as a vector database, building a personalized memory of your habits.
- Conversational Memory: Maintains context across interactions, allowing the AI assistant to engage in more natural and helpful dialogues about your water intake.
- Automated Logging & Tracking: Automatically records all AI agent outputs and hydration statuses directly into a Google Sheet for comprehensive historical tracking.
- Real-time Error Alerts: Instantly notifies you of any workflow issues via Slack, ensuring continuous and uninterrupted operation of your smart hydration system.
How To Use
- Set Up Webhook: Configure the
Webhook Triggernode with your desired path (e.g.,/drink-water-reminder). This will be your endpoint for sending hydration events or queries. - Configure AI & Database Credentials: Provide your OpenAI API key for the
EmbeddingsandChat Modelnodes, and your Supabase API keys forSupabase InsertandSupabase Query. Ensure your Supabase project has a vector store nameddrink_water_reminder. - Google Sheets Integration: Authenticate your Google Sheets account and update the
Append Sheetnode with your specific Google Sheet ID and the sheet name (Log) where the AI's responses will be recorded. - Slack Error Notifications: Connect your Slack workspace credentials to the
Slack Alertnode and specify the#alertschannel for receiving any workflow error messages. - Trigger and Test: Once configured, send data to your webhook (e.g., via a simple HTTP POST request or another n8n workflow) to test the RAG agent's responses and verify that data is logged correctly in Google Sheets.
Apps Used
Workflow JSON
{
"id": "bce26b29-c14e-4460-9e69-1bb035d05937",
"name": "Smart Hydration Tracker with RAG AI",
"nodes": 29,
"category": "Personal",
"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: bce26b29-c14e...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Voice Task to Notion: AI-Powered Processing
This n8n workflow automates the intelligent processing of voice-activated tasks intended for Notion or similar tools. It leverages advanced AI to understand inputs, builds a dynamic knowledge base from them, and logs processing outcomes to Google Sheets. Instantly get alerted via Slack for any errors, ensuring reliable task management.
Smart Expense Tracking with Telegram & AI
Automate your personal finance management by turning your Telegram chat into an intelligent expense tracker. Simply send a photo of a receipt or a text message, and this workflow uses AI to categorize your spending, extract crucial details, and provide instant summaries.
Send Obsidian Notes as Emails with Dynamic Attachments
This workflow empowers you to transform your Obsidian notes into dynamic emails, complete with custom metadata from YAML frontmatter and automated attachment handling. Seamlessly share your thoughts and files directly from your preferred note-taking environment.