Automated Price Tracking and Report Generation Workflow

This n8n workflow automates the process of monitoring product prices from Google Shopping, fetching relevant data, analyzing the lowest offers, and sending a comprehensive report via email. It begins with a manual trigger allowing user-initiated execution, then retrieves product data from Google Sheets. The workflow interacts with Bright Data APIs to solicit and monitor data snapshots of product listings filtered by specific keywords and price. It includes polling mechanisms to monitor snapshot status, error handling, and data extraction phases. Once the data is ready, it uses AI language models to analyze and rank the lowest-priced listings, generating an insightful Markdown report. The report is formatted into styled HTML and sent via email. This automation is ideal for online sellers, price comparison services, or anyone needing ongoing market price analysis to make informed purchasing or selling decisions.