Net4Venture
Net4Venture is a workflow automation system built for a German real estate investment firm — eliminating manual data entry from their property lead intake process entirely.
Before this system, every new property listing arrived as a PDF. An agent had to manually extract property details, create folders in Drive, populate spreadsheets, and coordinate viewings — 15 to 20 minutes of repetitive work per lead, repeated for every single incoming listing.
The solution is six interconnected n8n workflows covering the complete lifecycle from PDF drop to due-diligence report. A new PDF landing in a monitored Drive folder triggers the entire pipeline: AI extracts the property data, Drive organizes itself, the master spreadsheet gets a new row, and the Sprengnetter AVM API pulls an automated market valuation — all without a human touching anything.
Three additional workflows handle the human touchpoints that remain: a one-click address correction that propagates to all four locations simultaneously, a one-click viewing scheduler that creates the Calendar event and returns a confirmation page, and an on-demand due-diligence report generator that processes condominium association documents through GPT vision OCR.
The system went from concept to production handling real leads. Zero manual intervention on the intake pipeline is the measurable outcome.
Highlights
- ✓ PDF drop triggers the full pipeline — zero manual intervention from listing to analysis
- ✓ AI extracts 35+ structured fields per property using OpenAI with type-specific prompts
- ✓ Automated property valuation via Sprengnetter AVM API (market value, min/max, comparable €/m²)
- ✓ One-click address correction propagates to 4 places simultaneously via webhook
- ✓ One-click Google Calendar viewing scheduler — no copy-pasting, no app switching
- ✓ WEG due-diligence: GPT vision OCR extracts 30+ legal/financial fields from condo docs
Technical details
Architecture
Six interconnected n8n workflows (self-hosted) covering the full property lead lifecycle. Triggered by Google Drive folder monitoring, spreadsheet hyperlink webhooks, and manual uploads. All workflows share Google Workspace as the collaboration layer.
**Workflow 1 — PDF Processing:** Drive folder watcher picks up new property listing PDFs. OpenAI extracts 35+ structured fields using custom prompts per property type (apartments, multi-family, single-family). Type-specific prompts improve extraction accuracy significantly over a single generic prompt.
**Workflow 2 — Drive Organization:** Creates a `City - Address / REPORT` folder structure per property. Copies a calculation template spreadsheet into the new folder automatically.
**Workflow 3 — Spreadsheet Population:** Appends a row to the master lead list. Seeds the per-property calculation spreadsheet with AI-extracted data. Calls the Sprengnetter AVM API to fetch automated valuation (market value, min/max range, comparable €/m²) and writes results to the spreadsheet.
**Workflow 4 — One-Click Address Sync:** Webhook triggered by a hyperlink click in the spreadsheet. Propagates an address correction to 4 places: Drive folder name, spreadsheet file name, spreadsheet data row, master lead list. Returns a confirmation page in the browser.
**Workflow 5 — Viewing Scheduler:** Webhook triggered by a spreadsheet hyperlink click. Creates a Google Calendar event with property details. Returns a confirmation page with event info — no copy-pasting required.
**Workflow 6 — WEG Due-Diligence:** Accepts uploaded condominium association documents. Uses GPT vision OCR to extract 30+ legal and financial fields (maintenance reserves, special assessments, ownership shares, renovation plans). Populates a structured report sheet.
**Outcome:** What took 15–20 minutes of manual work per lead now requires zero intervention. A PDF drop triggers the entire pipeline.