Automated Ingredient Price Monitoring & Recommendations

somdn_product_page

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.

Node Count

11 – 20 Nodes

Nodes Used

code, cron, emailSend, httpRequest, postgres, stickyNote

Reviews

There are no reviews yet.

Be the first to review “Automated Ingredient Price Monitoring & Recommendations”

Your email address will not be published. Required fields are marked *