Abstract: The research describes a real-time ETL system which performs data validation and automation through Shell scripting and MySQL database integration and Zapier email notification automation.