Quick overview
Quick overview This scheduled workflow benchmarks internal procurement prices from Google Sheets against historical averages, enriches each item with Google News RSS trend signals, and uses Groq (Llama 3.3) to assess pricing risk, recommend target ranges and negotiation tactics, alerting high-risk items in Slack and logging results back to Google Sheets. How it works Runs daily at 09:00 on a schedule. Reads procurement purchase records from a Google Sheets worksheet and groups them by item to identify the latest purchase and prior history. Calculates benchmark metrics per item (weighted average price, variance percentage, and simple internal price trend) from the historical purchases. For each item, pulls recent Google News RSS headlines for “item price + region” and classifies a market trend signal from the top headlines. Merges the internal benchmark metrics with the market trend and sends the combined context to Groq for a structured JSON risk assessment, target price range, timing advice, and negotiation strategy. Flags items where variance exceeds 5% or Groq returns a High risk level, sends a formatted Slack alert for those items, and appends every item’s report to a Google Sheets reporting tab. Setup Connect Google Sheets OAuth and set the correct spreadsheet and worksheet for input (Procurement_Data) and output (Benchmark_Reports), ensuring the input columns include item, last_purchase_date, price_internal, quantity, category, supplier, contract_type, region, and target_price_last. Add a Groq API credential and confirm the selected model is available in your Groq account. Connect Slack OAuth and choose the user or channel that should receive overpricing alerts. Adjust the schedule time and the overpricing threshold logic (variance_pct > 5% or High risk) to match your procurement policy. If needed, tune the Google News RSS query format (keywords and region) to better fit your item naming conventions. Additional info How To Customize Nodes Schedule Node → Change frequency Google Sheets Nodes → Update sheet IDs and schema AI Node → Modify prompt and rules RSS Node → Adjust search keywords IF Node → Change risk thresholds Slack Node → Replace with Email, Teams, etc. Add-ons You can Add Email alerts BI dashboards (Power BI / Looker Studio) ERP integrations Supplier scoring Contract renewal automation Multi-region benchmarking Use Case Examples Detect overpriced procurement items Improve supplier negotiations Monitor regional price trends Optimize procurement cost efficiency Support budgeting decisions There can be many more use cases depending on business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|--------------|---------| | No data fetched | Incorrect Google Sheet ID | Verify sheet and permissions | | Workflow not triggering | Schedule issue | Check trigger timing | | AI parsing fails | Invalid JSON | Enforce strict JSON output | | No Slack alerts | Credentials issue | Reconnect Slack | | No market news | Weak query | Improve keywords | | Wrong calculations | Data format issue | Ensure numeric fields | Need Help? If you need help setting up or customizing this workflow, our n8n workflow development team can assist you with: Workflow customization AI-powered procurement automation System integrations Advanced dashboards Reach out WeblineIndia to build scalable, intelligent automation tailored to your business needs. An n8n automation workflow template by WeblineIndia.
WeblineIndia
web
free
Others in the same category, ranked by how often they are opened.
