Track Idealista market stats weekly and email Google Sheets reports with Idealista Scraper

 Who is this for

Real estate investors comparing markets across cities, agencies generating market reports for clients, property consultants doing due diligence, or analysts tracking price trends in Southern European property markets.

What this workflow does

Every Monday at 8am, this workflow scrapes property listings from multiple Idealista markets, calculates key statistics, builds an HTML comparison report, emails it to you, and logs data to Google Sheets for long-term trend tracking.

1. The Schedule Trigger fires every Monday at 8am 2. Two Idealista Scraper nodes fetch Madrid and Barcelona listings in parallel via API-based extraction (never breaks) 3. Code nodes calculate per-market statistics: average/median price, price range, price per m², average size, average rooms 4. The Merge node combines both market analyses into one dataset 5. A Code node builds a professionally formatted HTML comparison table 6. The report is emailed via Gmail and weekly stats are logged to Google Sheets

Idealista has no official API and no built-in market analytics. This workflow turns raw listing data into actionable market intelligence, automatically, every week.

Setup

1. Install n8n-nodes-idealista-scraper via Settings > Community Nodes (self-hosted n8n only) 2. Add your Apify API credential ([get token](https://console.apify.com/account/integrations)) 3. Add your Gmail credential (OAuth2) 4. Create a Google Sheet with a tab named "MarketHistory" 5. Update the email recipient in the Gmail node 6. Activate the workflow