Maintenance Connection Monitor

⚙Robotic Process Automation

A lightweight RPA solution built with PowerShell to monitor work order assignments and provide real-time email alerts.

Technology Stack

PowerShellWindows User32 APISystem.Windows.FormsGmail SMTP

System Architecture

Loading diagram...

Specifications

▸Window Automation: Uses Win32 API calls to reliably bring Edge to foreground
▸Data Extraction: Simulates Ctrl+A/Ctrl+C and parses clipboard with regex
▸State Management: Tracks previous count to detect increases
▸Email Alerts: Sends baseline email on startup + alerts when count rises
▸Scheduled Polling: 10-minute refresh cycle

Design Decisions

Challenge	Solution
Browser already authenticated	Leverage existing session instead of API auth
Window focus reliability	Win32 API (SetForegroundWindow + ShowWindow)
Page content extraction	Clipboard-based approach via SendKeys
Secure email auth	Gmail App Password over SMTP TLS

Process Flow

Loading diagram...