Build a Knowledge-Based WhatsApp Assistant with RAG, Gemini, Supabase & Google Docs

Description

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.