video1.0<iframe src="https://www.loom.com/embed/5d5d07df8b1448b29904cd15b839599d" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/5d5d07df8b1448b29904cd15b839599d-b5c5db652829add7.gif533.73I'm excited to share my first project developed in N8N workflow, focusing on supply chain analytics. The workflow automatically triggers when an email with sales data is received, downloading attachments, extracting data, and loading it into PostgreSQL. I've set up a star schema with two fact tables and dimension tables, and the process appends new data seamlessly. Additionally, I've integrated Quadratic AI for advanced analytics and created an exchange rate table using an API for better price analysis across countries. Please take a look at the KPIs generated from this data, as they are crucial for understanding our supply chain performance.