n8n Job Automation & Scoring Workflow - 2026
Built an automated workflow using n8n, self-hosted on a pi5, to fetch job listings via API, process the data, and store structured results in Google Sheets. The system handles filtering, formatting, and error cases such as empty responses.
- Scrapes jobs from multiple sources (APIs)
- Deduplicates results (self-reference comparison)
- AI-based scoring (OpenAI API)
- Automated cover letter generation (OpenAI API)
- Structured output to Google Sheets (Google API)
Python Applications & Database Integration (2023-2026)
SMS Notification Integration
Built a Python application to send SMS notifications by integrating with a provider’s API. The system constructs structured JSON payloads and triggers messages based on database events.
System Monitoring & Email Alerts
Developed monitoring scripts that query SQL Server using pyodbc to track critical indicators. Automatically sends email alerts when major errors or abnormal conditions are detected.
Data Comparison & Correction Tool
Created a data validation tool to compare legacy datasets with production data, identify discrepancies, and generate structured templates for re-import and correction.
Flask Database Dashboard
Built a Flask web application to display key database tables and system status, accessible via a public IP for real-time monitoring and reporting.
Python Flask CCTV Monitoring Dashboard - 2023-2026
Built a Python Flask application that monitors CCTV device status using IMAP email notifications. The system reads device emails, tracks when devices go offline or come back online, and presents the information in a browser-based dashboard.
The dashboard provides real-time status visibility, downloadable records, automatic updates and IIS integration for access through a Windows server.
SQL Triggers and Procedures - 2023-2026
Designed and implemented SQL Server triggers to enforce data integrity, including validating user inputs, handling errors, and automating updates across related tables.
Developed stored procedures to support operational workflows, such as structured equipment imports and controlled data updates within a production environment.
Card Tracker App - in 2022 (didn't have AI)
Built a card-tracking app for the strategic card game. The idea came from a practical gameplay problem: players benefit from tracking previously played cards to better predict future draws.
I designed and built the app from scratch, learning SwiftUI and Xcode, developing a working prototype, preparing supporting documentation, conducting beta testing, and managing the App Store submission process. However, the app was ultimately not permitted under Apple’s App Store guidelines, which restricted the core functionality of the product, leading to the project being discontinued.
Custom Browser Extension Shortcuts - in 2021 (didn't have AI)
Created a custom browser extension to speed up a frequent daily workflow: accessing webpages linked to specific datasets. The extension allows an ID to be entered and opens the relevant dashboard in one click.
This reduced repetitive manual navigation and made operational work faster and more consistent.
▶ Try a similar idea: Send a WhatsApp message
Spreadsheet, VBA and Workflow Tools - 2021 (didn't have AI)
Created practical tools including formulated spreadsheets, VBA macros, custom keyboard shortcuts and operational shortcuts to improve campaign setup and application-support workflows.