n8n Data Collection Automation

I have several APIs and an internal database that need to work together inside a single n8n instance. The goal is simple: collect fresh data on a schedule, run a few in-line transformations, then store the cleaned results back into my database (and optionally push certain fields to a separate reporting table).

Here is what I need you to deliver:
• A fully configured n8n workflow that pulls records from the specified REST endpoints and our SQL database, merges or filters them where necessary, and writes the transformed payloads to the target tables.
• Clear node-by-node comments or short inline descriptions so I can maintain the workflow later.
• Robust error-handling with notifications inside n8n (Webhook, Slack or Email—whichever is fastest for you to set up).
• A quick hand-off document showing the environment variables and credentials I need to update when moving from staging to production.

I already have the API docs, database schema, and sample transformation rules prepared; you just need to wire everything up in n8n, test the run, and show me that the data lands exactly where it should.