Scrape Berlin 2-Room Rentals
Daily scrape and update 2-room Berlin apartment rentals in Google Sheets with email summaries of new listings.
Real EstateRental ListingsData ScrapingGoogle Sheets
Apartment Scraper to Google Sheets
This workflow automates daily tracking of current 2-room apartment rentals in Berlin. It scrapes popular apartment listing sites, validates availability, extracts key details, and logs everything into a Google Sheet. You also get a daily email summary highlighting new and updated listings.
What it does
- Runs every day at 9 AM Berlin time.
- Performs targeted internet searches to find 10-15 apartment listing URLs from major German rental platforms.
- Visits each URL, checks if listing is still available, and grabs detailed info like title, price, size, address, landlord, and availability.
- Parses and formats this data for Google Sheets.
- Compares scraped listings with existing sheet entries by URL; updates existing rows or adds new ones.
- Sends an email summary with counts of new and updated listings, including direct links.
Requirements
- Needle platform account to run and schedule the workflow.
- Google Sheets with a prepared spreadsheet for listings.
- Google Sheets API connected in Needle with permission to read/write.
- Gmail connected for sending daily email summaries.
Workflow Details
| Node | Purpose |
|---|---|
| Scheduled Trigger | Fires daily at 9 AM Europe/Berlin time. |
| AI Internet Search & Scraper | Searches and scrapes detailed 2-room Berlin apartment listings from selected websites. |
| Code (Parse & Format) | Converts AI output into structured rows suitable for Google Sheets. |
| Google Sheets Get Values | Retrieves existing listing URLs from the sheet to detect duplicates. |
| Merge | Combines scraped and existing listing URLs for comparison. |
| Code (Compare Listings) | Distinguishes new from existing listings; counts and prepares stats for reporting. |
| Google Sheets Upsert Row | Inserts new listings and updates existing ones based on unique URL key. |
| Gmail Send Email | Sends a styled HTML email summarizing new, updated, and total listings with clickable links. |
Output
- An up-to-date Google Sheet with comprehensive current data on 2-room apartments in Berlin.
- A daily email that summarizes new and updated listings with direct links to both listings and the spreadsheet.
Notes
- Search queries include both German and English terms to cover multiple platforms.
- Validation rules help filter out unavailable or stale listings.
- Make sure your Google Sheet permissions allow seamless upserts.
- Email notifications let you keep track without frequent manual checks.
- Scheduling can be adjusted to get updates whenever you prefer.
This workflow removes the hassle of manual apartment hunting by keeping your data fresh and organized automatically.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.