Block 1 - Every Monday 8am
- Type / Role
- n8n-nodes-base.scheduleTrigger - scheduleTrigger
- Config choices
- Version 1.2
Track Idealista market stats weekly and email Google Sheets reports with Idealista Scraper
Workflow preview
100%
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER 
Early Deal
DISCOUNT 20% Try free
Early DealDISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
1. Workflow Overview
Who is this for Real estate investors comparing markets across cities, agencies generating market reports for clients, property consultants doing...
Best for
- Market Research automation workflows
- intermediate n8n builders looking for reusable templates
Tools used
n8n-nodes-base.scheduletrigger, n8n-nodes-idealista-scraper.idealistascraper, n8n-nodes-base.code, n8n-nodes-base.merge, n8n-nodes-base.gmail, n8n-nodes-base.googlesheets, n8n-nodes-base.stickynote
Source and attribution
This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by SIÁN Agency.
Original n8n.io source1.1 Workflow description
- Title
- Track Idealista market stats weekly and email Google Sheets reports with Idealista Scraper
- Workflow name
- 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.
- The Schedule Trigger fires every Monday at 8am
- Two Idealista Scraper nodes fetch Madrid and Barcelona listings in parallel via API-based extraction (never breaks)
- Code nodes calculate per-market statistics: average/median price, price range, price per m2, average size, average rooms
- The Merge node combines both market analyses into one dataset
- A Code node builds a professionally formatted HTML comparison table
- 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
- Install n8n-nodes-idealista-scraper via Settings > Community Nodes (self-hosted n8n only)
- Add your Apify API credential (get token)
- Add your Gmail credential (OAuth2)
- Create a Google Sheet with a tab named "MarketHistory"
- Update the email recipient in the Gmail node
- Activate the workflow
Requirements
- Self-hosted n8n instance (community node not available on n8n Cloud)
- Apify account with API token
- Gmail account with OAuth2 credential configured in n8n
- Google Sheets account with OAuth2 credential configured in n8n
How to customize this workflow
- Add more cities by duplicating a Scraper + Analysis pair (Valencia, Rome, Lisbon, Milan)
- Switch
operationfromsaletorentto analyze rental markets - Add price filters to focus on specific segments (luxury above 1M EUR, budget below 200K EUR)
- Calculate rental yield by scraping both sale and rent for the same area
- Add an IF node after analysis to send alerts when average price drops below a threshold
- Cost: ~$0.50/week (2 markets x 3 pages x ~40 properties each)
1.2 Logical Blocks
This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.
2. Block-by-Block Analysis
Block 2 - Scrape Madrid
- Type / Role
- n8n-nodes-idealista-scraper.idealistaScraper - idealistaScraper
- Config choices
- Version 1
Block 3 - Scrape Barcelona
- Type / Role
- n8n-nodes-idealista-scraper.idealistaScraper - idealistaScraper
- Config choices
- Version 1
Block 4 - Analyze Madrid
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 5 - Analyze Barcelona
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 6 - Merge Market Data
- Type / Role
- n8n-nodes-base.merge - merge
- Config choices
- Version 3.1
Block 7 - Build HTML Report
- Type / Role
- n8n-nodes-base.code - code
- Config choices
- Version 2
Block 8 - Email Report
- Type / Role
- n8n-nodes-base.gmail - gmail
- Config choices
- Version 2.2
Block 9 - Log to Market History
- Type / Role
- n8n-nodes-base.googleSheets - googleSheets
- Config choices
- Version 4.5
Block 10 - Sticky Note
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 11 - Sticky Note1
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 12 - Sticky Note2
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 13 - Sticky Note3
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
Block 14 - Sticky Note4
- Type / Role
- n8n-nodes-base.stickyNote - stickyNote
- Config choices
- Version 1
3. Summary Table
| Workflow | Track Idealista market stats weekly and email Google Sheets reports with Idealista Scraper |
|---|---|
| Complexity | intermediate |
| Nodes | 14 |
| Categories | Market Research |
| Author | SIÁN Agency |
| Published | 13 Apr 2026 |
4. Reproducing the Workflow from Scratch
-
1. Download the workflow JSON
Use the JSON export at /data/workflows/15008/15008.json as the source template for this automation.
-
2. Import the template into n8n
Open n8n, import the downloaded JSON, and review each node before activating the workflow.
-
3. Configure credentials and variables
Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
-
4. Test with sample data
Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.
-
5. Activate and monitor
Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.
5. General Notes & Resources
Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.
Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.
Frequently asked questions
What does Track Idealista market stats weekly and email Google Sheets reports with Idealista Scraper do?
Who is this for Real estate investors comparing markets across cities, agencies generating market reports for clients, property consultants doing...
What do I need before importing this workflow?
Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.
Can I customize this workflow?
Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research use case.