Automated construction project alerts with email notifications and data APIs

This n8n workflow monitors and alerts you about new construction projects in specified areas, helping you track competing builders and identify business opportunities. The system automatically searches multiple data sources and sends detailed email reports with upcoming projects.

Good to know Email parsing accuracy depends on the consistency of request formats - use the provided template for best results. The workflow includes fallback mock data for demonstration when external APIs are unavailable. Government data sources may have rate limits - the workflow includes proper error handling. Results are filtered to show only upcoming/recent projects (within 3 months).

How it works Email Trigger - Detects new email requests with "Construction Alert Request" in the subject line Check Email Subject - Validates that the email contains the correct trigger phrase Extract Location Info - Parses the email body to extract area, city, state, and zip code information Search Government Data - Queries government databases for public construction projects and permits Search Construction Sites - Searches construction industry databases for private projects Process Construction Data - Combines and filters results from both sources, removing duplicates Wait For Data - Wait for Combines and filters results. Check If Projects Found - Determines whether to send a results report or no-results notification Generate Email Report - Creates a professional HTML email with project details and summaries Send Alert Email - Delivers the construction project report to the requester Send No Results Email - Notifies when no projects are found in the specified area

The workflow also includes a Schedule Trigger that can run automatically on weekdays at 9 AM for regular monitoring.

Email Format Examples

Input Email Format

To: alerts@yourcompany.com Subject: Construction Alert Request

Area: Downtown Chicago City: Chicago State: IL Zip: 60601