Workflow Execution Link:
Workflow Execution Link: Watch Execution Video Workflow Pre-requisites Step 1: Supabase Setup First, replace the keys in the "Save the embedding in DB" & "Search Embeddings" nodes with your new Supabase keys. After that, run the following code snippets in your Supabase SQL editor: Create the table to store chunks and embeddings: CREATE TABLE public."RAG" ( id bigserial PRIMARY KEY, chunk text NULL, embeddings vector(1024) NULL ) TABLESPACE pg_default; Create a function to match embeddings: DROP FUNCTION IF EXISTS public.matchembeddings1(integer, vector); CREATE OR REPLACE FUNCTION public.matchembeddings1( match_count integer, query_embedding vector ) RETURNS TABLE ( chunk text, similarity float ) LANGUAGE plpgsql AS $$ BEGIN RETURN QUERY SELECT R.chunk, 1 - (R.embeddings <=> query_embedding) AS similarity FROM public."RAG" AS R ORDER BY R.embeddings <=> query_embedding LIMIT match_count; END; $$; Step 2: Create Knowledge Base Create a new Google Doc with the complete knowledge base about your business and replace the document ID in the "Content for the Training" node. Step 3: Get Together AI API Key Get a Together AI API key and paste it into the "Embedding Uploaded document" node and the "Embed User Message" node. Step 4: Setup Meta App for WhatsApp Business Cloud Go to https://business.facebook.com/latest/settings/apps, create an app, and select the use case "Connect with customer through WhatsApp". Copy the Client ID and Client Secret and add them to the first node. Go to that newly created META app in the app dashboard, click on the use case, and then click on "customise...". Go to the API setup, add your number, and also generate an access token on that page. Now paste the access token and the WhatsApp Business Account ID into the send message node. Part A: Document Preparation (One-Time Setup) 1. When clicking ‘Execute workflow’ Type:** manualTrigger Purpose:** Manually starts the workflow for preparing training content. 2. Content for the Training Type:** googleDocs Purpose:** Fetches the document content that will be used for training. 3. Splitting into Chunks Type:** code Purpose:** Breaks the document text into smaller pieces for processing. 4. Embedding Uploaded document Type:** httpRequest Purpose:** Converts each chunk into embeddings via an external API. 5. Save the embedding in DB Type:** supabase Purpose:** Stores both the chunks and embeddings in the database for future use. Part B: Chat Interaction (Realtime Flow) 1. WhatsApp Trigger Type:** whatsAppTrigger Purpose:** Starts the workflow whenever a user sends a WhatsApp message. 2. If Type:** if Purpose:** Checks whether the incoming WhatsApp message contains text. 3. Embend User Message Type:** httpRequest Purpose:** Converts the user’s message into an embedding. 4. Search Embeddings Type:** httpRequest Purpose:** Finds the top matching document chunks from the database using embeddings. 5. Aggregate Type:** aggregate Purpose:** Merges retrieved chunks into one context block. 6. AI Agent Type:** langchain agent Purpose:** Builds the prompt combining user’s message and context. 7. Google Gemini Chat Model Type:** lmChatGoogleGemini Purpose:** Generates the AI response based on the prepared prompt. 8. Send message Type:** whatsApp Purpose:** Sends the AI’s reply back to the user on WhatsApp. An n8n automation workflow template by iamvaar.
iamvaar
web
paid
Others in the same category, ranked by how often they are opened.
