AI-Powered Business Intelligence Assistant for Restaurant Insights
detail.loadingPreview
This n8n workflow creates an intelligent AI Assistant that serves as a business intelligence tool, leveraging your company's internal documents and a specialized restaurant leads database. It automates the process of ingesting new knowledge and provides comprehensive, conversational insights on demand, likely via a messaging platform like WhatsApp.
About This Workflow
Empower your team with a dedicated AI Business Intelligence Assistant. This robust workflow automatically ingests updated documents from Google Drive, processes them using OpenAI embeddings, and stores them in a Supabase vector database, building a dynamic 'Company Knowledge Base'. Concurrently, an advanced AI Agent, powered by gpt-4o-mini, accesses this knowledge base alongside a 'Restaurant Leads Database' to answer complex business queries. The assistant maintains conversational memory using PostgreSQL, enabling seamless, ongoing interactions. From identifying high-potential restaurant leads to analyzing market opportunities and crafting cold outreach strategies, this solution provides real-time, data-driven insights to boost your operational and sales efficiency.
Key Features
- Automated Knowledge Base Ingestion: Automatically updates your AI's knowledge with new documents from a specified Google Drive folder.
- Advanced AI Agent: Utilizes an OpenAI-powered agent (
gpt-4o-mini) configured with a specialized system message for business intelligence. - Dual Knowledge Source Integration: Accesses both a 'Company Knowledge Base' (from Google Drive) and a 'Restaurant Leads Database' for comprehensive answers.
- Conversational Memory: Stores chat history in PostgreSQL, allowing for context-aware, ongoing conversations.
- Vector Database Integration: Leverages Supabase for efficient storage and retrieval of document embeddings for RAG (Retrieval Augmented Generation).
- Scalable Document Processing: Includes text splitting and embedding generation for large documents, ensuring effective information retrieval.
How To Use
- Set up Google Drive Credentials: Connect your Google Drive account, ensuring the specified 'Company A' folder (ID:
1dh1Rr2yrhSdoSYpiR8s1yXiSWLYxpoLJ) is accessible for theGoogle Drive TriggerandSearch File/Get Datanodes. - Configure Supabase: Provide your Supabase API credentials for the
Supabase Vector Storenode. Ensure you have a table named 'documents' set up in your Supabase project to store vector embeddings. - Integrate OpenAI: Add your OpenAI API credentials for both
Embeddings OpenAInodes and theOpenAI Chat Model. The workflow usesgpt-4o-miniby default. - Connect PostgreSQL: Set up your PostgreSQL database credentials for the
Postgres Chat Memorynode. This database will store the conversational history for your AI Assistant. - Customize AI Agent (Optional): Review and adapt the 'systemMessage' within the
AI Agentnode to further tailor its persona and specific instructions for your business needs. - Connect a Messaging Trigger (e.g., WAHA): This workflow is designed to integrate with an external trigger like 'WAHA Trigger' for conversational input. Ensure your external trigger is configured to pass the appropriate
remoteJidas the session key to thePostgres Chat Memorynode. - Run the workflow: Activate the workflow. New files updated in your designated Google Drive folder will automatically be ingested, processed, and added to your knowledge base. The AI Agent will be ready to respond to queries via its integrated messaging platform.
Apps Used
Workflow JSON
{
"id": "0042dc85-74d0-43a3-ba2a-2579b3aadc23",
"name": "AI-Powered Business Intelligence Assistant for Restaurant Insights",
"nodes": 22,
"category": "Operations",
"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: 0042dc85-74d0...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.
Automate Getty Images Editorial Search & CMS Integration
This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.