OpenAI and Redis integration

🧠 Intelligent AI Assistant with RAG & Voice for WhatsApp – Built with GPT-4o & Supabase 📌 About this workflow and its creator Hi! I’m Amanda, a creator of intelligent automations using n8n and Make. I’ve been building AI-powered workflows for over 2 years, always focused on usability and innovation. This one here is very special to me – a truly advanced AI assistant that reads, listens, interprets and responds like a real human 🤖✨ This ready-to-use workflow acts as a powerful AI personal assistant capable of understanding messages via voice, text, documents, or even images. It supports full multi-channel operation (WhatsApp via Evolution API, Instagram, Facebook, and more), and includes advanced RAG capabilities using Supabase + GPT-4o. It’s designed to be highly extensible, with memory, prompt update tools, and knowledge base management. ⚙️ What this workflow does 💬 Understands user input via text, document, audio or image (voice, OCR, PDF) 🎤 Transcribes and interprets voice messages using OpenAI Whisper 🧠 Understands prompts and user commands using GPT-4o via LangChain agent 🗂️ Searches knowledge base using RAG + Supabase vector DB 📄 Accepts documents and automatically indexes them for future questions 🧾 Summarizes documents and stores metadata in Supabase 🗃️ Offers memory support (PostgreSQL chat memory per user session) 📧 Sends replies through WhatsApp (Evolution API), Instagram, Facebook, etc. 📅 Manages schedules (via tool integration with Google Calendar) 📬 Sends and searches emails (with support tools) 🛠 Modular and expandable structure (tools for saving knowledge, deleting, updating prompt) 🔧 Setup Instructions n8n Hosting This workflow requires n8n self-hosted (or n8n Cloud with custom credentials + community nodes enabled). Create required databases Use the provided SQL queries inside the setar_supabase_tabelas_vectoriais, criar_cerebro, and criar_rag_controle nodes to initialize: documents table for RAG cerebro table for prompt memoria_chat for session memory rag_controle for summaries and indexing Credentials needed OpenAI API (for chat, embeddings and Whisper transcription) Redis (for managing message buffer) Supabase (for vector store + metadata) Postgres (for memory and prompts) Evolution API (or other messaging platforms) Webhook Set the webhook path to receive messages from your Evolution or WhatsApp API provider. Configure ‘Set’ node In the config node, adjust: adminNumero: your personal WhatsApp or admin number evolutionApiKey: your private API key utilizacaoApenasViaAdmin: toggle if this should only respond to admin numbers Tool connections Ensure the supporting workflows are also imported and connected for: Emails Knowledge management Calendar events 📎 Notes This workflow uses LangChain agents, OpenAI GPT-4o, Supabase, Redis, and PostgreSQL. It includes multiple “sticky notes” inside the workflow with explanations. Ideal for businesses, consultants, and developers looking to offer an intelligent and extendable AI chatbot experience. 🛍 Want to use this on your system? ❤️ Buy workflows: https://iloveflows.com ☁️ Use n8n Cloud with my partner link: https://n8n.partnerlinks.io/amanda

🤖 Multi-Agent AI Telegram Bot for Service Businesses Transform your salon/service business with this streamlined Telegram automation system featuring Claude integration, zero-setup database management, and intelligent conversation handling. How It Works Core Architecture Claude MCP Integration** - Direct connection to Claude Sonnet 4 via Model Context Protocol Streamlined 2-Agent System** - Booking Agent and Admin Agent (simplified from 5 for better reliability) GPT-5 Mini Primary** with Gemini 2.5 Flash backup for cost-effective processing Multi-Media Support** - Handles text, voice (Whisper transcription), images, and PDFs with cost extraction Smart Acknowledgments** - "One moment…", "Let me check availability…" during processing Rate Limiting & Spam Protection** - Configurable limits (default: 100 msg/hour) with professional UX Zero-Setup Database Management Autonomous Airtable Creation** - Bot creates all necessary tables automatically Complete CRUD Operations** - Create, edit, delete services and settings via Telegram Dynamic Business Configuration** - Modify hours, pricing, services conversationally Friend Booking Support** - "Book for my friend Sarah" functionality Setup Steps Telegram Business API setup (detailed instructions included) Airtable Base ID extraction (store in Redis or hardcode - recommended) Google Calendar integration for scheduling Redis for caching, rate limiting, and conversation memory MCP Server deployment for Claude integration Telegram for notifications Key Features Booking Management Booking Limit Control** - Default 6 appointments per customer (configurable in workflow) Service Name Matching** - GPT-5 Nano workflow for cost-optimized service recognition 24-Hour Advance Reminders** - Automatic Telegram reminders sent at 8 PM Conversation Handling Conversation Memory** maintains context across interactions Error Resilience** with backup models and graceful failure handling Use Cases Perfect for: Salons Spas Clinics Consulting services Any appointment-based business Complete business setup happens through conversational commands - no manual database configuration required. Transform your service business with intelligent automation powered by AI and Telegram integration.

🤖Multi-Agent AI WhatsApp Bot for Service Businesses Transform your salon/service business with this streamlined WhatsApp automation system featuring Claude integration, zero-setup database management, and intelligent conversation handling. How it works Claude MCP Integration** - Direct connection to Claude Sonnet 4 via Model Context Protocol Streamlined 2-Agent System** - Booking Agent and Admin Agent (simplified from 5 for better reliability) GPT-5 Mini Primary** with Gemini 2.5 Flash backup for cost-effective processing Multi-Media Support** - Handles text, voice (Whisper transcription), images, and PDFs with cost extraction Smart Acknowledgments** - "One moment...", "Let me check availability..." during processing Rate Limiting & Spam Protection** - Configurable limits (default: 100 msg/hour) with professional UX Zero-Setup Database Management Autonomous Airtable Creation** - Bot creates all necessary tables automatically Complete CRUD Operations** - Create, edit, delete services and settings via WhatsApp Dynamic Business Configuration** - Modify hours, pricing, services conversationally Friend Booking Support** - "Book for my friend Sarah" functionality Set up steps WhatsApp Business API** setup (detailed instructions included) Airtable Base ID** extraction (store in Redis or hardcode - recommended) Google Calendar** integration for scheduling Redis** for caching, rate limiting, and conversation memory MCP Server** deployment for Claude integration Whatsapp** for notifications Key Features Booking Limit Control** - Default 6 appointments per customer (configurable in workflow) Service Name Matching** - GPT-5 Nano workflow for cost-optimized service recognition 24-Hour Advance Reminders** - Automatic WhatsApp reminders sent at 8 PM Conversation Memory** maintains context across interactions Error Resilience** with backup models and graceful failure handling Perfect for salons, spas, clinics, consulting services, or any appointment-based business. Complete business setup happens through conversational commands - no manual database configuration required.

AI-Powered WhatsApp Assistant for Restaurant & Delivery – Automate Orders, Calculate Delivery Fees & Enhance Customer Service with n8n 📌 Optimize your restaurant's delivery process with AI-powered automation! This n8n workflow enables an intelligent WhatsApp assistant for restaurants, burger joints, and delivery businesses. The AI chatbot efficiently handles orders, calculates delivery fees based on distance, manages customer interactions, and seamlessly integrates with your CRM and database for streamlined operations. ⚠️ Important Notice: This template is only compatible with self-hosted n8n instances as it uses community nodes. Ensure secure credential management when configuring APIs. 🔹 Key Features ✅ AI-Powered Order Processing – Automatically receive and confirm orders via WhatsApp. ✅ Real-Time Distance Calculation – Determines the delivery distance and calculates the fee dynamically. ✅ Automated Customer Interaction – Engages customers with intelligent conversation and order updates. ✅ WhatsApp Integration – Processes messages, saves customer details, and retrieves past interactions. ✅ Secure Customer Data Storage – Saves order history, customer preferences, and location details in a database. ✅ Seamless CRM & POS System Integration – Sync orders and customer data with your existing platforms. 📌 How It Works 1️⃣ A customer sends a message via WhatsApp to start an order. 2️⃣ The AI assistant guides them through the menu, recommends items, and confirms their choices. 3️⃣ The system retrieves and saves customer details (name, phone number, and address). 4️⃣ The AI calculates the delivery distance and applies the appropriate delivery fee. 5️⃣ The order details are saved and forwarded to the restaurant’s system for preparation. 6️⃣ The assistant keeps the customer updated about the order status. ⚙️ Setup & Customization 🔧 Webhook for WhatsApp – Capture and process customer messages automatically. 🔧 OpenAI-Powered AI Assistant – Configure conversation flows for natural and engaging interactions. 🔧 Delivery Fee Calculation – Set your delivery price per kilometer and adjust base rates. 🔧 Database & CRM Integration – Store customer details, order history, and location data. 🔧 Customizable Order Flow – Adapt the workflow for different restaurant models. 🔧 Secure Credential Management – Store API keys safely to prevent unauthorized access. 💡 Requirements: This template is recommended for users with basic knowledge of n8n. If you need custom development or setup assistance, contact us via WhatsApp: +55 17 99155-7874. 🚀 Automate order processing, reduce manual tasks, and improve customer satisfaction with AI-powered WhatsApp automation! Assistente de WhatsApp com IA para Restaurantes & Delivery – Automatize Pedidos, Calcule Taxas de Entrega e Melhore o Atendimento ao Cliente com n8n 📌 Otimize o processo de entrega do seu restaurante com automação baseada em IA! Este fluxo para n8n permite criar um atendente virtual inteligente no WhatsApp, ideal para hamburguerias, restaurantes e serviços de delivery. O chatbot baseado em IA recebe pedidos, calcula a taxa de entrega com base na distância, interage com os clientes e integra-se ao seu CRM para operações mais eficientes. ⚠️ Aviso Importante: Este template é compatível apenas com instâncias auto-hospedadas do n8n, pois utiliza nós da comunidade. Certifique-se de gerenciar credenciais de forma segura ao configurar APIs. 🔹 Principais Funcionalidades ✅ Processamento Inteligente de Pedidos – Recebe e confirma pedidos automaticamente via WhatsApp. ✅ Cálculo Dinâmico da Taxa de Entrega – Mede a distância e aplica a taxa correta automaticamente. ✅ Atendimento Automatizado ao Cliente – Interage com clientes de forma natural e profissional. ✅ Integração com WhatsApp – Captura mensagens, armazena dados e recupera histórico de pedidos. ✅ Armazenamento Seguro de Dados do Cliente – Salva pedidos, preferências e endereços de entrega. ✅ Sincronização com CRM e Sistema de PDV – Conecta-se ao seu sistema de gestão para um fluxo contínuo. 📌 Como Funciona 1️⃣ O cliente envia uma mensagem via WhatsApp para iniciar um pedido. 2️⃣ O assistente de IA apresenta o menu, sugere itens e confirma a escolha do cliente. 3️⃣ O sistema captura e salva os dados do cliente (nome, telefone e endereço). 4️⃣ A IA calcula a distância de entrega e aplica a taxa de acordo com a localização. 5️⃣ Os detalhes do pedido são registrados e enviados para a cozinha. 6️⃣ O assistente atualiza o cliente sobre o status do pedido. ⚙️ Configuração e Personalização 🔧 Webhook para WhatsApp – Configuração para capturar e processar pedidos automaticamente. 🔧 Assistente de IA com OpenAI – Configuração de fluxos conversacionais naturais e envolventes. 🔧 Cálculo de Taxa de Entrega – Definição de valores por quilômetro e ajustes de tarifas base. 🔧 Banco de Dados & CRM – Armazena dados de clientes, histórico de pedidos e localização. 🔧 Fluxo de Pedidos Personalizável – Adapte para diferentes tipos de restaurantes e serviços de delivery. 🔧 Gerenciamento Seguro de Credenciais – Proteja suas chaves de API contra acessos não autorizados. 💡 Requisitos: Este template é recomendado para usuários que já possuem conhecimentos básicos em n8n. Se precisar de personalização ou suporte para instalação, entre em contato pelo WhatsApp: +55 17 99155-7874. 🚀 Automatize o processamento de pedidos, reduza tarefas manuais e melhore a satisfação dos clientes com um WhatsApp automatizado e inteligente!

🐶🤖 AI Agent for Pet Shops – Automate Customer Service & Bookings! 🐾💡 Transform Your Pet Shop with AI-Powered Automation! 🚀 Enhance customer experience and optimize operations with this n8n AI Agent designed for pet shops. 📲🐾 Automate client interactions, appointment scheduling, and service recommendations—saving time and increasing revenue! 🔹 Key Features: ✅ Instant WhatsApp responses – AI-powered chatbot handles customer inquiries. 💬 ✅ Automated appointment scheduling – Clients can book services hassle-free. 📅✂️ ✅ Personalized reminders – Reduce no-shows with automated notifications. 📢🐾 ✅ Customer data & service history management – Track interactions effortlessly. 📊📁 ✅ Product & service recommendations – Improve sales with smart suggestions. 🎁🐶 📌 How It Works 1️⃣ The workflow captures customer inquiries via WhatsApp. 2️⃣ AI processes requests, provides information, and offers booking options. 3️⃣ Clients can schedule grooming, vet visits, or other services in seconds. 4️⃣ Automated reminders ensure appointments are remembered. 5️⃣ Customer data is stored for better service personalization. ⚙️ Setup & Customization 🔧 Connect your WhatsApp API (evolution) for instant messaging. 🔧 Integrate with Google Calendar for appointment booking. 🔧 Customize reminders, services, and pricing rules to fit your business. 💡 Reduce manual work, improve customer satisfaction, and scale your pet shop with AI automation! 🐶🤖 [PT-BR] Agente de IA para Pet Shops – Atendimento e Agendamentos Automatizados! 🐾💡 Transforme Seu Pet Shop com Automação Inteligente! 🚀 Otimize o atendimento ao cliente e agilize processos com este Agente de IA para n8n. 📲🐾 Automatize interações, agendamentos e recomendações de serviços—economizando tempo e aumentando as vendas! 🔹 Principais Funcionalidades: ✅ Atendimento automático no WhatsApp – IA responde clientes instantaneamente. 💬 ✅ Agendamento de serviços automatizado – Clientes marcam banho, tosa ou consultas facilmente. 📅✂️ ✅ Lembretes personalizados – Reduza faltas com notificações automáticas. 📢🐾 ✅ Gestão de clientes e histórico de serviços – Controle dados de forma eficiente. 📊📁 ✅ Sugestão de produtos e serviços – Venda mais com recomendações inteligentes. 🎁🐶 📌 Como Funciona 1️⃣ O fluxo recebe perguntas dos clientes via WhatsApp. 2️⃣ A IA processa os pedidos e fornece opções de agendamento. 3️⃣ O cliente escolhe o serviço desejado e agenda em segundos. 4️⃣ Lembretes automáticos garantem que os clientes não esqueçam os horários. 5️⃣ O histórico do cliente é salvo para oferecer um atendimento mais personalizado. ⚙️ Configuração e Personalização 🔧 Conecte sua API do WhatsApp (evolution) para interação automática. 🔧 Integre ao Google Calendar para gerenciar agendamentos. 🔧 Personalize valores, serviços e regras de envio de lembretes conforme sua necessidade. 💡 Automatize processos, melhore a experiência do cliente e escale seu pet shop com IA! 🚀

Automatically capture, categorize, and log expenses from receipts, PDFs, voice notes, or text — powered by AI and integrated with Telegram and Google Sheets. 🧑‍💼 Who is this for? Small business owners, freelancers, digital nomads, and finance professionals who want to eliminate manual expense tracking and automate financial data entry through chat, AI, and cloud tools. ❓ What problem is this workflow solving? Manually managing receipts and tracking expenses across various formats (paper, PDF, or voice) is time-consuming and error-prone. This workflow automates that entire process—OCR, categorization, validation, and reporting—so your finances stay organized with zero manual effort. 📦 What You Get ✅ Complete Smart_Money_Manager.json n8n workflow 📄 API credential setup guide 📈 Google Sheets sample template 🛠️ AI prompt customization examples 🧪 Troubleshooting & error handling logic 📺 Bonus video tutorial (if provided) 💬 Telegram support from the developer ⚙️ What this workflow does 🎯 Triggers Runs on Telegram message (text, image, voice note, PDF) Smart inline menu to select income or expense tracking 🧠 Processing Auto-detects content type (photo, PDF, voice note, or text) Transcribes voice using OpenAI Whisper Extracts data from images using Google Vision OCR Parses PDFs via LlamaIndex Uses OpenAI GPT-4 for intelligent expense categorization and validation Categorizes by income/expense, with subcategories like Food, Transport, etc. Parses currency and performs logic validation on totals 📊 Logging Automatically appends categorized transaction data into Google Sheets Adds details like date, merchant, item list, payment method, etc. Saves both income and expenses with conditional Google Sheet routing 💬 Notifications Sends detailed transaction summaries via Telegram Warns users of errors or invalid inputs with friendly retry guidance Voice-command friendly for hands-free logging 🔧 How to customize this workflow to your needs 🧾 Add custom expense types — edit categorization prompts in the GPT node 🌎 Enable multi-language or multi-currency support by modifying AI prompts 🗂️ Route to different Google Sheets by user ID, business unit, or project 📣 Expand to other platforms — Add Slack or email notifications 🔍 Enhance validation with stricter logic for budgets, tax codes, or policy rules 🚀 Setup Instructions Requirements: n8n instance (Cloud or self-hosted)** (Cloud or self-hosted) Telegram Bot API credentials Google Cloud (Vision API) OpenAI API key LlamaIndex API key Google Sheets API Redis (optional, for session memory) Step-by-step: Import workflow.json into your n8n instance Configure credentials for all services: Telegram, OpenAI, Google, Redis Set up your Google Sheets with defined columns Modify AI prompts (optional) for categories and business rules Test by sending a receipt photo, PDF invoice, or voice note to your bot Monitor output in Google Sheets and Telegram summaries 🧩 Nodes Used Telegram Trigger + Chat Node** (bot interaction and input selection) Switch/IF nodes** (content-type routing and condition checking) OpenAI Whisper & GPT-4** (voice transcription and categorization) Google Vision OCR** (receipt image processing) LlamaIndex PDF API** (PDF parsing and extraction) Google Sheets Append** (expense logging and formatting) Redis** (session and state tracking) Custom JS nodes** (data transformation and formatting) Made by: Khaisa Studio Tag: youtube, summarizer, telegram, openai Category: AI Automation, Video Tools Need a custom? Contact Me 💸 Take control of your finances with zero manual work. Let Smart Money Manager handle the receipts, so you can focus on growing your business.