Database Update Automation Script

I’m looking to replace a repetitive, manual workflow that currently has me copying information from spreadsheets and web forms into our SQL-based database. The end goal is simple: one click and the records are updated accurately every time, without me hovering over rows and columns.

Here’s what I need the solution to handle:
• Read incoming data files (typically CSV or Excel).
• Validate each row against a few basic business rules I will provide (e.g., required fields can’t be blank, date format must be YYYY-MM-DD).
• Push the clean data into our existing SQL tables, creating new entries or updating matches on a unique ID.
• Log any errors or skipped rows so I can review them later.

I’m flexible on the technology stack, though Python with pandas + SQLAlchemy is what I had in mind. If you prefer a different language or low-code tool that achieves the same reliability and speed, let me know.

Deliverable: a tested script or small application, plus clear setup instructions so I can run it on my Windows machine whenever new data arrives.