📊 Description:
Streamline supplier sourcing and decision-making with this AI-powered price comparison automation 🤖. This workflow intelligently researches multiple suppliers in real-time, extracts pricing, delivery timelines, and MOQ data 🔍, and ranks the best options using advanced scoring logic. It also generates ready-to-send negotiation messages 📧 and flags anomalies for smarter procurement decisions. Perfect for teams looking to automate vendor analysis and reduce sourcing time while maximizing cost savings 💳.
What This Template Does:
📋 Triggers when a new product request is added to Google Sheets.
🗺️ Validates input and plans supplier navigation using MCTS logic.
🤖 Scrapes and analyzes data from multiple supplier websites.
📊 Extracts price, MOQ, delivery time, and stock availability.
🧠 Performs AI self-critique to validate and score data quality.
🏆 Ranks suppliers based on price, delivery, and overall score.
✍️ Generates a negotiation email for the best supplier.
📒 Creates a detailed comparison report in Notion.
🔔 Sends a summary and insights to Slack for the team.
⚠️ Detects anomalies and alerts the team if needed.
✅ Updates Google Sheets with final results and status.
Key Benefits:
✅ Fully automated supplier research and comparison
✅ Real-time data extraction with AI validation
✅ Smarter procurement decisions with ranking logic
✅ Built-in anomaly detection for risk reduction
✅ Instant negotiation message generation
✅ Centralized reporting and team collaboration
Features:
- Google Sheets trigger-based workflow
- AI-powered supplier research (Agent Q with GPT-4o)
- HTTP scraping for live supplier data extraction
- MCTS-based navigation planning for accuracy
- Self-critique scoring and anomaly detection
- Automated Notion reporting dashboard
- Slack alerts with rich summaries
- Dynamic negotiation message generation
Requirements:
- Google Sheets account (for request tracking)
- OpenAI API key (for Agent Q intelligence)
- Notion account (for report generation)
- Slack account (for alerts and summaries)
- Internet access for supplier website scraping
Target Audience:
🏢 Procurement and sourcing teams
🛒 E-commerce and wholesale businesses
🚀 Startups optimizing vendor selection
🤖 Automation agencies building AI procurement systems