📊 Track real estate market pain points with Apify, GPT-4o and Telegram alerts
⚡ 848 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
How it works
This workflow runs on a daily schedule. It starts by scraping real estate-related queries from Google using Apify. The organic search results are parsed and summarized into a single text block. That text is then sent to an AI model (GPT-4o) which extracts the top 3 pain points faced by real estate agents based on current online sentiment. The workflow compares today’s insights with yesterday’s data stored in Airtable to detect recurring or new pain points. Finally, it sends a summary notification via Telegram and stores the current day’s insights into Airtable for trend tracking.
How to set up
- Clone or import the workflow into your n8n instance.
- Get an Apify API token and insert it into the HTTP Request node.
- Create an Airtable base with a table containing two fields: “Date” (text) and “Summary” (long text). Copy the Base ID and Table ID into the Airtable nodes.
- Connect your Telegram bot and replace the chat ID in the Telegram node.
- Set up OpenAI credentials with GPT-4o or GPT-4o-mini for the LLM node.
- Run once manually to test, then activate the schedule trigger to run daily.
- (Optional) Extend the flow to generate cold outreach emails based on pain points, or sync to Notion/CRM.
🔗 Nodes Used
Airtable, HTTP Request, Telegram, Schedule Trigger, AI Agent, OpenAI Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File