n8n Workflows

Ingredient Price Trend Analysis & Buying Recommendations with PostgreSQL, API & Slack

Preface

This automated n8n workflow tracks ingredient price changes from external APIs or manual inputs, analyzes historical trends, and offers smart buying recommendations. It stores price fluctuations in a PostgreSQL database, generates actionable insights, and sends alerts via email and Slack to assist restaurants in optimizing purchasing decisions.

Positive Impact

Tracks price trends to support cost-effective buying.
Provides actionable insights based on historical data.
Reduces expenses with smart purchasing suggestions.
Keeps teams informed with timely email and Slack alerts.

Process Flow

Daily Trigger: Activates the workflow each day at 12:34 PM IST to check prices.
Fetch Price Data: Pulls current ingredient prices from external APIs or manual input.
Store in PostgreSQL: Saves price data and trends into a PostgreSQL database.
Analyze Trends: Examines historical data for price fluctuation patterns.
Generate Recommendations: Creates buying recommendations based on analysis.
Format Alerts: Prepares alerts with insights for email and Slack.
Send Email Notification: Delivers the alert via email to stakeholders.
Send Slack Notification: Sends the alert to the Slack channel for team updates.