Automated Competitor Price Data Collection and Analysis

This n8n workflow automates the process of scraping, analyzing, and storing competitor pricing data. It starts with a webhook trigger that receives incoming data, typically from a scraping tool or external source. The data is then split into manageable chunks for natural language processing. Using a language model, the workflow generates semantic embeddings of the data, which are stored in a vector database (Supabase). It performs similarity searches to find relevant data, then passes this context to a language model for analysis. The results are logged into Google Sheets for record-keeping and are also processed by a Retrieval-Augmented Generation (RAG) agent for deeper insights. In case of errors, a Slack notification is sent. This workflow is ideal for competitive pricing monitoring to adapt strategies quickly and stay ahead in the market.