Automates monitoring of ingredient prices via API, analyzes trends in PostgreSQL, generates smart buying recommendations, and sends alerts via Slack and email to optimize restaurant purchasing.
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.
Platform
n8n
Category
HR & Operations
Price
$24.99
Creator
Fred Garcia
price-analysis
trend-analysis
postgresql
slack
api-integration
buying-recommendations
restaurant-automation
expense-management
business-intelligence
data-analytics
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.