Automated Price Updates with AI and Google Sheets

This n8n workflow automates the process of updating product prices in a Google Sheet based on new data inputs. It leverages AI and vector search to analyze and process data efficiently, providing real-time updates and error alerts.

The workflow begins with an HTTP Webhook trigger that listens for incoming price update requests. Once triggered, the data is split into manageable chunks and stored in a vector database (Weaviate) for semantic indexing.

Using LangChain’s embeddings, the workflow generates vector representations of the data, enabling advanced search capabilities within Weaviate. The system uses a combination of AI models, including OpenAI’s language model, to understand and process the information contextually.

A Retrieval-Augmented Generation (RAG) agent orchestrates the AI-powered analysis, referencing previous data stored in the vector database. It processes the information to determine the status of each update.

Finally, the results, including update status, are appended to a designated ‘Log’ sheet in Google Sheets. If any errors occur during processing, a Slack alert notifies the user promptly.

This workflow is highly useful for e-commerce or inventory management teams looking to automate price updates efficiently, ensuring data consistency and reducing manual effort.