Automate commercial real estate monitoring with ScrapeGraphAI, Notion and Mailchimp

Property Listing Aggregator with Mailchimp and Notion ⚠️ COMMUNITY TEMPLATE DISCLAIMER: This is a community-contributed template that uses ScrapeGraphAI (a community node). Please ensure you have the ScrapeGraphAI community node installed in your n8n instance before using this template. This workflow scrapes multiple commercial-real-estate websites, consolidates new property listings into Notion, and emails weekly availability updates or immediate space alerts to a Mailchimp audience. It automates the end-to-end process so business owners can stay on top of the latest spaces without manual searching. Pre-conditions/Requirements Prerequisites - n8n instance (self-hosted or n8n.cloud) - ScrapeGraphAI community node installed - Active Notion workspace with permission to create/read databases - Mailchimp account with at least one Audience list - Basic understanding of JSON; ability to add API credentials in n8n Required Credentials - ScrapeGraphAI API Key – Enables web scraping functionality - Notion OAuth2 / Integration Token – Writes data into Notion database - Mailchimp API Key – Sends campaigns and individual emails - (Optional) Proxy credentials – If target real-estate sites block your IP Specific Setup Requirements | Resource | Requirement | Example | |----------|-------------|---------| | Notion | Database with property fields (Address, Price, SqFt, URL, Availability) | Database ID: abcd1234efgh | | Mailchimp | Audience list where alerts are sent | Audience ID: f3a2b6c7d8 | | ScrapeGraphAI | YAML/JSON config per site | Stored inside the ScrapeGraphAI node | How it works This workflow scrapes multiple commercial-real-estate websites, consolidates new property listings into Notion, and emails weekly availability updates or immediate space alerts to a Mailchimp audience. It automates the end-to-end process so business owners can stay on top of the latest spaces without manual searching. Key Steps: - Manual Trigger / CRON: Starts the workflow weekly or on-demand. - Code (Site List Builder): Generates an array of target URLs for ScrapeGraphAI. - Split In Batches: Processes URLs in manageable groups to avoid rate limits. - ScrapeGraphAI: Extracts property details from each site. - IF (New vs Existing): Checks whether the listing already exists in Notion. - Notion: Inserts new listings or updates existing records. - Set: Formats email content (HTML & plaintext). - Mailchimp: Sends a campaign or automated alert to subscribers. - Sticky Notes: Provide documentation and future-enhancement pointers. Set up steps Setup Time: 15-25 minutes 1. Install Community Node Navigate to Settings → Community Nodes and install “ScrapeGraphAI”. 2. Create Notion Integration - Go to Notion Settings → Integrations → Develop your own integration. - Copy the integration token and share your target database with the integration. 3. Add Mailchimp API Key - In Mailchimp: Account → Extras → API keys. - Copy an existing key or create a new one, then add it to n8n credentials. 4. Build Scrape Config In the ScrapeGraphAI node, paste a YAML/JSON selector config for each website (address, price, sqft, url, availability). 5. Configure the URL List Open the first Code node. Replace the placeholder array with your target listing URLs. 6. Map Notion Fields Open the Notion node and map scraped fields to your database properties. Save. 7. Design Email Template In the Set node, tweak the HTML and plaintext blocks to match your brand. 8. Test the Workflow Trigger manually, check that Notion rows are created and Mailchimp sends the message. 9. Schedule Add a CRON node (weekly) or leave the Manual Trigger for ad-hoc runs. Node Descriptions Core Workflow Nodes: - Manual Trigger / CRON – Kicks off the workflow either on demand or on a schedule. - Code (Site List Builder) – Holds an array of commercial real-estate URLs and outputs one item per URL. - Split In Batches – Prevents hitting anti-bot limits by processing URLs in groups (default: 5). - ScrapeGraphAI – Crawls each UR