Ingredient Price Trend Analysis & Buying Recommendations

This n8n workflow provides comprehensive price trend analysis for ingredients used in restaurants and food businesses. It runs daily to fetch the latest prices from external APIs, stores historical data in a PostgreSQL database, and performs advanced trend calculations to identify patterns like rising, falling, or stable prices. Based on these insights, it generates actionable recommendations such as 'buy now', 'wait', or 'stock up', helping businesses time purchases optimally and reduce costs.

Key benefits include real-time alerts via Slack and email to capture buying opportunities, improved accuracy with accumulating historical data (best after 30+ days), and a dashboard for visualizing trends. The workflow ensures database readiness, handles data insertion securely, and maintains recommendation history for reporting and auditing.

Ideal use cases: Restaurant chains tracking produce and meat prices, catering services managing supplier costs, or any food business aiming to cut expenses through data-driven decisions. It integrates seamlessly with PostgreSQL for robust analytics, external pricing APIs for fresh data, and Slack for instant notifications, saving hours of manual tracking and analysis weekly.