Competitor Price Monitor | n8n + Google Sheets

Keeping track of competitor prices becomes repetitive when a retailer manages several product categories and regularly adds new SKUs.

I built this automation around TechNest Accessories, a simulated electronics retailer, with a practical brief: monitor comparable competitor products while keeping the solution affordable and easy to manage.

The budget shaped the approach. Product discovery and matching stayed manual: the retailer enters its own SKU, selling price and chosen competitor URL in Google Sheets. This keeps control over which products are compared and reduces the complexity of the build.

Once a listing is selected, the repeated checking is automated.

The workflow reads active listings, retrieves competitor prices and availability, and compares each result with both the retailer’s price and the previously recorded competitor price. It then updates the Current Prices tab and appends a timestamped record to Price History.

The retailer can manage everything from the sheet—add listings, update selling prices, or pause monitoring with a Yes/No dropdown.

The workflow also handles failed page requests and price extraction. It records the error, preserves the last valid price and continues to the next listing. A successful later check clears the error.

I tested the build with two Portronics charger listings, confirming price comparisons, historical records and recovery after a deliberately failed check. The workflow supports scheduled daily checks and manual runs.

The result is a working prototype that brings selected competitor prices into one place, highlights meaningful differences and preserves a record for review—while leaving product selection and pricing decisions with the retailer.

Built with: n8n, JavaScript, HTTP requests and Google Sheets.

Independent portfolio project based on a simulated client brief. Images show recorded test data and simplified views of the working system.