n8n Data Automation Workflow Build

I need a complete n8n workflow that automates data moving in and out of my MySQL database. The main goal is to eliminate the manual steps we currently take when importing raw records, enriching them, and pushing the cleaned data back into the same or another table for downstream reporting.

Here’s what I have in mind:
• The workflow should watch a specific table (or a cron-based trigger is fine if polling suits the job) and pull new rows as soon as they appear.
• Once fetched, the data needs a quick transformation step—simple field mapping and a couple of calculated columns.
• After transformation, updated rows should be written back to MySQL, with basic error handling so failed writes are logged.
• I’d like email or Slack notifications for any run that throws an error to make debugging faster.

Everything must run inside our existing self-hosted n8n instance, so please use native n8n MySQL nodes rather than custom code unless a small JavaScript function is the cleanest answer. If you see an advantage in bringing in spreadsheets or calling a Web API down the line, let me know; right now the scope stays on MySQL but I’m open to scalable ideas.

Deliverables:
1. The exported .json workflow file, ready to import.
2. A short read-me explaining environment variables, node credentials, and how to tweak schedule or triggers.
3. A quick screenshare or recorded walkthrough (2–3 min) so I can follow the logic at a glance.

Send any clarifying questions before you dive in, and please mention a rough timeline for the first draft so I can align internal testing.