Track competitor pricing and features with BrowserAct and Google Sheets

Track competitor pricing and features from BrowserAct to Google Sheets

Introduction

This workflow automates competitive intelligence by continuously monitoring competitor websites for pricing and feature updates. It scrapes current data using BrowserAct, compares it against historical records using AI to identify specific changes (like price increases or removed features), and archives the findings in a new Google Sheet tab every week.

Target Audience

Product managers, pricing analysts, and market researchers who need to stay updated on competitor moves without manually checking websites.

How it works

1. Scheduling: A Weekly Trigger initiates the workflow to ensure regular monitoring. 2. Database Retrieval: The workflow fetches a list of competitor URLs and their previous scrape data from a Google Sheet. 3. Data Extraction:

A BrowserAct node visits each URL and extracts the current pricing plans and feature lists using the "AI Competitor Spy" template. 4. AI Comparison: An AI Agent (using Google Gemini Flash via OpenRouter) compares the live data against the historical data stored in the sheet. It identifies exactly what changed (e.g., "Basic plan increased by $5"). 5. Database Update: The workflow updates the main database with the new "Last Scrape Content" and the date, establishing a new baseline for the next run. 6. Report Generation: After processing all competitors, a second AI Agent (using Google Gemini Pro) aggregates the findings into a comprehensive text report. 7. Archiving: The workflow creates a new tab in the Google Sheet (named with the current date) and appends the full comparative report. 8. Notification: A Slack message is sent to notify the team that the weekly analysis is complete.