Abandoned Cart Email Automation

• Webhook Trigger: Initiates the workflow with incoming abandoned cart data.
• Text Splitting: Prepares text data for embedding.
• Cohere Embeddings: Creates vector representations of text for semantic search.
• Supabase Vector Store: Efficiently stores and retrieves vectorized data.
• OpenAI Chat Model: Powers the conversational AI for generating email content.
• RAG Agent: Implements Retrieval Augmented Generation for context-aware responses.
• Google Sheets Logging: Records workflow execution status.
• Slack Alerts: Notifies of any errors during execution.

1. Webhook Trigger (Webhook Trigger): Configure this node to receive POST requests containing abandoned cart data. Ensure the path is set to abandoned-cart-email.
2. Text Splitter (Text Splitter): This node automatically splits the incoming text data into manageable chunks.
3. Embeddings (Embeddings): Connect the output of the Text Splitter to this node. Configure it to use embed-english-v3.0 with your Cohere API credentials (COHERE_API).
4. Supabase Insert (Supabase Insert): Connect the embeddings to this node. Set the indexName to abandoned_cart_email and use your Supabase credentials (SUPABASE_API). This stores the embeddings and associated data.
5. Supabase Query (Supabase Query): This node is used internally by the RAG Agent to retrieve relevant context from Supabase. It also uses your Supabase credentials and the abandoned_cart_email index.
6. Vector Tool (Vector Tool): This node prepares the retrieved data from Supabase to be used as context for the RAG Agent.
7. Window Memory (Window Memory): This node maintains the conversation history for the RAG Agent.
8. Chat Model (Chat Model): Connect this node to your OpenAI API credentials (OPENAI_API). It will be used by the RAG Agent for generating responses.
9. RAG Agent (RAG Agent): This is the core AI node. Configure its text parameter to `Process the following data for task 'Abandoned Cart Email':

{{ $json }}and set thesystemMessagetoYou are an assistant for Abandoned Cart Email. 10. **Append Sheet (Append Sheet):** Connect the RAG Agentto this node. Configure it to append the generated email status to your Google Sheet. EnsureSHEET_IDandLogsheet name are correctly set. TheStatuscolumn should map to={{$json["RAG Agent"].text}}. 11. **Slack Alert (Slack Alert):** Connect the onErroroutput of theRAG Agent to this node. Configure it with your Slack credentials (SLACK_API) and a channel (e.g., #alerts`) to receive error notifications.