This n8n workflow automates the process of tracking ingredient prices, analyzing trends, and providing actionable buying suggestions. Initiated daily, it fetches current prices from an external API and stores them in a PostgreSQL database. The workflow then computes price trends over the past 30 days to identify increases, decreases, or stability. Based on these insights, it generates tailored purchase recommendations with urgency levels, which are saved in the database. To facilitate decision-making, the workflow creates a comprehensive HTML dashboard visualizing price fluctuations, trends, and suggestions. Finally, it dispatches the report via email and sends real-time alerts to Slack for high-priority items, supporting smarter procurement strategies in the food industry.
Automated Ingredient Price Monitoring & Recommendations
Node Count | 11 – 20 Nodes |
---|---|
Nodes Used | code, cron, emailSend, httpRequest, postgres, stickyNote |
Reviews
There are no reviews yet.