Automate Maintenance Tickets with n8n: Airtable, Twilio & Gmail

Transform your property maintenance chaos into a streamlined operation with this intelligent n8n workflow that automatically triages tenant requests, matches tickets to the right contractors by category and location, and eliminates costly duplicate submissions before they spiral out of control.

What this workflow does

This automation monitors your Airtable maintenance tickets table every minute, instantly processing new tenant submissions through a sophisticated triage system. First, it scans for duplicates using smart matching logic—same tenant, property, and category within 24 hours—flagging potential duplicates and alerting administrators via Gmail. For genuine new tickets, the system extracts UK postcode districts (e.g., SW1A 1AA → SW1) and automatically assigns contractors based on their service categories and coverage areas. Once matched, it dispatches job details simultaneously through Gmail and Twilio SMS, ensuring contractors receive immediate notification through their preferred channels.

Perfect for

• Residential lettings agencies managing dozens of properties who need reliable contractor dispatch
• Short-let and HMO operators tired of handling duplicate "is anyone fixing this?" tickets
• Commercial property managers requiring complete paper trails for every maintenance dispatch
• Any ticket-based operation needing intelligent routing and duplicate prevention

Technical details

Built with essential n8n nodes including Airtable triggers for real-time monitoring, Code nodes for UK postcode parsing and duplicate detection logic, Gmail integration for administrative alerts and contractor notifications, Twilio SMS for instant mobile alerts, If nodes for conditional routing, and Limit nodes for controlled processing. The template includes configurable duplicate detection windows and postcode matching specifically designed for UK formats.

Important considerations

Each Twilio SMS incurs standard messaging rates (approximately $0.04 per UK SMS). The postcode logic targets UK formats—US ZIP codes require Code node adjustments. The 24-hour duplicate detection window is customizable within the Evaluate Duplicates node. While optimized for Airtable, any CRM system can replace the data source with minor modifications.