# How I Built an AI Sales Agent That Makes $50k a Month Source: https://www.youtube.com/watch?v=U15D29BtfDI Recap page: https://rapidrecap.app/video/U15D29BtfDI Generated: 2025-12-14T15:36:42.329+00:00 --- ## Quick Overview The creator builds a fully automated AI sales agent using a workflow that integrates Supabase for knowledge retrieval, OpenAI for chat responses, and Airtable for CRM management, enabling the agent to answer product and testimonial questions by dynamically retrieving and indexing relevant data. **Key Points:** - The AI sales agent workflow is built to handle customer inquiries about products and testimonials using an automated system. - The core of the system involves using Supabase as a vector store for product information and testimonials retrieved from an Airtable base. - The workflow uses an Airtable base ('CRM Magic') with separate tables for 'Documents' (containing raw data) and 'Products' (for sales/CRM data). - Video testimonials are processed by downloading the file via an HTTP request, transcribing it using OpenAI's 'Transcribe a recording' tool, and indexing the text content into Supabase. - The AI Agent is configured with a system prompt instructing it to utilize the 'get_products' tool (which searches the Airtable 'Documents' table) when asked about product information or testimonials. - The system successfully demonstrates the agent retrieving both product details (from the 'get_products_details' tool) and testimonial information (from the RAG pipeline) based on the user's query. - The creator outlines future expansion to integrate other communication channels like Vapi, WhatsApp, Telegram, and web chatbots into the AI agent's capabilities. ![Screenshot at 00:00: The main workflow diagram shows the overall structure, including the initial chat trigger, an AI Agent, Supabase Vector Store for RAG, and an OpenAI Chat Model connection, illustrating the core components of the automated sales agent.](https://ss.rapidrecap.app/screens/U15D29BtfDI/00-00-00.png) **Context:** The video demonstrates the process of building an advanced AI sales agent using a visual workflow automation platform (implied to be Nodri or similar) that connects various AI tools (OpenAI, vector databases) with external data sources, specifically Airtable, to create a knowledge-grounded conversational system. ## Detailed Analysis The video details the construction of a fully automated AI sales agent designed to answer customer questions about products and testimonials, leveraging a combination of specialized tools and databases. The workflow begins with a 'When chat message received' trigger, which feeds into an AI Agent. This agent is configured to use two main tools: one for fetching specific product details ('get_products_details') and another for retrieving testimonial information via a RAG (Retrieval-Augmented Generation) pipeline connected to a Supabase Vector Store. The initial data setup involves creating an Airtable base ('CRM Magic') with a 'Documents' table structured to hold multimedia content (videos, documents) and associated metadata (source, context, MIME type). Video testimonials are processed by downloading them via an HTTP Request, transcribing them using OpenAI's transcription tool, and then embedding the resulting text into Supabase for vector search. Metadata, including context tags like 'Testimonial', is crucial for filtering search results. The product information is managed in a separate Airtable table ('Products'), which is linked to the 'Documents' table via lookup fields in the CRM setup. The AI Agent's system prompt is customized to direct it to use the product search tool when a query relates to product details or testimonials. Finally, the agent sends its response back to the user via a 'Respond to Chat' node. The creator also mentions future plans to integrate other communication channels like Vapi, WhatsApp, Telegram, and web chatbots, showcasing the system's extensibility. ### AI Agent Configuration - AI Agent is configured with an initial system prompt instructing it to use the 'get_products_details' tool for product information and the RAG pipeline (via Supabase Vector Store) for testimonials. ### Data Ingestion (Videos/Testimonials) - Videos are downloaded via HTTP Request, transcribed using OpenAI, and the resulting text, along with metadata (like 'Context: Testimonial'), is embedded and stored in Supabase. ### Airtable CRM Setup - Two main Airtable bases/tables are used: 'Documents' for raw content/metadata and 'Products' for sales/CRM data, linked via lookup fields in the Products table. ### Product Information Retrieval Tool - A custom tool named 'get_products' is created in the workflow, configured to search the Airtable 'Documents' table specifically for records where the 'Context' is 'Testimonial' and 'Source Media' is not empty. ### Workflow Execution - Upon receiving a chat message, the workflow executes the AI Agent, which correctly routes the query through the RAG pipeline to retrieve relevant testimonials, bypassing the product search tool in this specific test case. ### Future Expansion - The creator notes the system is extensible to integrate with various communication platforms like Vapi, WhatsApp, Telegram, and web chatbots for broader reach. ![Screenshot at 00:00: The main workflow diagram showing the initial setup with the chat trigger, AI Agent, Supabase Vector Store, and connections to OpenAI tools and memory.](https://ss.rapidrecap.app/screens/U15D29BtfDI/00-00-00.png) ![Screenshot at 00:05: The Airtable 'Documents' table setup, showing the initial fields created \(ID, Source Media, Source, Source URL, Description, Context, Content, MIME Type, Indexed\) ready for RAG data.](https://ss.rapidrecap.app/screens/U15D29BtfDI/00-00-05.png) ![Screenshot at 01:10: The Supabase Vector Store configuration screen, showing the connection to the Supabase API and selection of the 'documents' table for vector indexing.](https://ss.rapidrecap.app/screens/U15D29BtfDI/00-01-10.png) ![Screenshot at 04:04: The Airtable 'Documents' table setup showing the custom 'Source' field configured as a single-select dropdown with options like 'Skool', 'YouTube', 'Zoom', and 'Google Drive'.](https://ss.rapidrecap.app/screens/U15D29BtfDI/00-04-04.png) ![Screenshot at 21:55: The final workflow diagram showing the full integration path, including the AI Agent utilizing the 'get\_products\_details' tool and the RAG pipeline for knowledge retrieval, which is then fed to the 'Respond to Chat' node.](https://ss.rapidrecap.app/screens/U15D29BtfDI/00-21-55.png)