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.
