Automate Google Sheets Price Updates with RAG and Weaviate
detail.loadingPreview
This workflow automates price updates in Google Sheets using a webhook trigger and a Retrieval Augmented Generation (RAG) agent. It stores product data in Weaviate for intelligent retrieval and updates the sheet with AI-processed information.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This n8n workflow is designed to automate the process of updating prices in a Google Sheet. It leverages a webhook to receive incoming price update requests, processes this data using a Retrieval Augmented Generation (RAG) agent powered by Langchain, and stores contextual information in a Weaviate vector database. The RAG agent retrieves relevant information from Weaviate, combines it with the input data, and then generates a response that is appended to a Google Sheet. This approach allows for intelligent and context-aware price updates, making the automation more robust and adaptable.
Key Features
- Webhook Trigger: Initiates the workflow when a price update request is received.
- Text Splitting & Embeddings: Prepares data for vector storage by splitting text and generating embeddings using Cohere.
- Weaviate Integration: Stores and retrieves product data and context in a Weaviate vector database.
- Langchain RAG Agent: Utilizes a RAG agent with OpenAI's chat model and window memory for intelligent data processing.
- Google Sheets Integration: Appends the processed update status to a specified Google Sheet.
- Error Alerting: Sends notifications to Slack in case of workflow errors.
How To Use
- Configure Webhook: Set up a
Webhook Triggernode to receive incoming price update requests via a POST request to the specified path. - Integrate with Weaviate: Set up
Text Splitter,Embeddings, andWeaviate Insertnodes to process incoming data and store it in your Weaviate instance. Ensure your Weaviate indexprice_update_google_sheetis configured. - Configure RAG Agent: Connect
Weaviate Query,Vector Tool,Window Memory, andChat Modelnodes to feed contextual data to theRAG Agent. - Google Sheets Update: Configure the
Append Sheetnode with your Google Sheets credentials, targetSHEET_ID, andLogsheet name to append the status of the price update. - Slack Alerts: Configure the
Slack Alertnode with your Slack credentials to receive error notifications.
Apps Used
Workflow JSON
{
"id": "3a4e7672-65b8-4245-b941-16845da5210f",
"name": "Automate Google Sheets Price Updates with RAG and Weaviate",
"nodes": 0,
"category": "Misc",
"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: 3a4e7672-65b8...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Automated Drink Water Reminder Workflow
This workflow uses n8n and Langchain to create an automated drink water reminder system. It leverages a Webhook Trigger, Text Splitter, Embeddings, and Supabase for RAG agent functionality, ultimately logging reminders to a Google Sheet.
Integrate Blog Comments with Discord via Webhook and AI
This workflow automates the process of receiving blog comments via a Webhook Trigger and processing them using Langchain AI. The processed comments are then stored in Supabase and logged to a Google Sheet, with error alerts sent to Slack.
Automate CSV Attachment to Airtable with a RAG Agent
This n8n workflow automates the process of handling CSV attachments by using a Retrieval Augmented Generation (RAG) agent. It leverages a Webhook Trigger, Text Splitter, Embeddings, Pinecone, and a Chat Model to intelligently process and log data.