Track real estate competitor prices & features with Google Sheets & email alerts

Competitor Price & Feature Tracker for Real Estate Projects

Overview This solution monitors competitor pricing and features for real estate projects by fetching data from a competitor API, parsing it, logging it to Google Sheets, and sending email alerts for significant price changes. It runs on a scheduled basis to keep real-time track of market trends.

Operational Process - Set Cron: Triggers the workflow on a scheduled basis (e.g., hourly). - Fetch Competitor Data: Performs GET requests to retrieve competitor pricing and feature data (e.g., https://api.competitor.com). - Wait For Data: Introduces a delay to ensure data is fully retrieved. - Parse Data: Processes and extracts relevant pricing and feature details. - Log to Google Sheets: Appends the parsed data to a Google Sheet for tracking. - Check Price Change: Evaluates if there’s a significant price change. - Send Alert Email: Sends an email notification if a price change is detected. - No Action for Minor Changes: Skips action if no significant price change is found.

Implementation Guide - Import the workflow JSON into n8n. - Configure the Cron node for the desired schedule (e.g., every hour). - Set up the HTTP node with the competitor API URL (e.g., https://api.competitor.com). - Configure Google Sheets integration and specify the log sheet. - Test with a sample API call and verify email alerts. - Adjust price change thresholds in the Check Price Change node as needed.

Requirements - HTTP request capability for API data retrieval. - Google Sheets API for data logging. - Email service (e.g., SMTP) for alerts. - n8n for workflow automation and scheduling.

Customization Options - Adjust the Cron schedule for different intervals (e.g., daily). - Modify the HTTP node to fetch additional competitor data (e.g., features, availability). - Customize email alert content in the Send Alert Email node. - Enhance Google Sheets log with additional fields (e.g., timestamp, competitor name). - Add Slack or WhatsApp notifications for additional alert channels.