Automate Ingredient Price Monitoring and Buying Recommendations with PostgreSQL and Slack
This n8n workflow automates the monitoring of ingredient prices, analyzes trends, and provides buying recommendations. It integrates with PostgreSQL for data storage and Slack for alert notifications, helping restaurants make informed purchasing decisions.
The workflow fetches ingredient prices from an external API daily and stores them in a PostgreSQL database. It analyzes historical price data to identify trends and generates actionable buying recommendations. These insights are visualized in a dashboard and shared via email and Slack alerts, ensuring timely and informed purchasing decisions.
- Platform
- n8n
- Category
- Business Intelligence
- Price
- $9.99
- Creator
- Camila Torres
- code
- cron
- postgres
- emailSend
- stickyNote
- httpRequest
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.
Related Business Intelligence workflows
- Automate Competitor Pricing Monitoring with Bright Data and OpenAI in n8n$14.99
- Automate News Monitoring and Categorization with SerpAPI and OpenAI$9.99
- Automate Daily Stock Market Reports via WhatsApp and Email$9.99
- Analyze traffic sources with Google Analytics reports$2.99
- Automated Investor Intelligence: CrunchBase to Google Sheets Data Harvester$4.99
- Automate Startup Funding Research with AI and Airtable$19.99
More from Camila Torres
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.