About

Job Title: Full-Stack Developer / Automation Engineer for Email-to-Database Integration & UI Overhaul Project Overview We have a 10-year-old MySQL database with a very basic UI. Right now, updating the database is a manual process- watch this loom video: https://www.loom.com/share/1269df2bc4b44b16b731a2e11bdb4dbd • Team members pull pricing info from two specific email inboxes. • Product photos arrive either as email attachments or as URLs in those emails. • Someone must manually enter prices and upload photos to the database. This is slow and error-prone. We need someone to use AI or something like N8N to go into those emails and put the pricing data direct into the database. Minor updates to the UI are also needed. For example, drag/drop screenshots into the photo section. I have no question, if you are helpful at this, there will be many other projects that I will have for you. Key Goals 1. Email & Data Automation • Connect securely to specified email addresses. • Detect and extract quoted prices and photo URLs/attachments automatically. • Insert parsed data into the correct MySQL tables without human intervention. 2. AI-Powered Parsing • Use AI/NLP to identify and map pricing details to the right database fields. 3. UI/UX Updates • Refresh the current web UI with a modern look. • Enable drag-and-drop image uploads (screenshots or files) instead of manual file selection. • Minor design and usability improvements for faster internal use. Deliverables • Automated pipeline to fetch & parse emails (pricing + images/URLs). • Integration that writes structured data directly into MySQL.