Turn WhatsApp into an AI shopping and price comparison assistant using Wati, OpenAI, Serper, and Google Sheets

Elevate your shopping experience with an AI-driven personal assistant that lives right in your WhatsApp. This template automates the entire lifecycle of a shopping list—from intelligent intake and live web price comparisons to proactive daily deal alerts—by combining WATI, OpenAI, Serper (Google Search), and Google Sheets. --- 🎯 What This Workflow Does Turns WhatsApp into a high-powered price engine across three independent pipelines: 📥 Pipeline A: Intelligent Intake When a user sends a list (e.g., list: milk 2L, eggs 12), OpenAI parses every item into structured categories, quantities, and units before saving them to the Google Sheets master list. 🔍 Pipeline B: Live Price Engine When a user types compare, the bot triggers a real-time web search via Serper. OpenAI then analyzes the search results to pick the absolute best deal and alternative stores, sending back a formatted "Comparison Card" with links. 📬 Pipeline C: Proactive Deal Alerts A scheduled trigger runs daily at 8 AM, scanning your saved items for price drops. If it finds a saving of ≥ 10%, it automatically pings the user with a personalized deal alert. --- ✨ Key Features - Semantic Parsing: OpenAI understands natural language lists, so you don't have to follow strict formatting. - Live Search Integration: Uses the Serper API to fetch actual live prices from major Indian retailers in seconds. - Automated UI: Uses custom emojis and visual bar charts to group items by category (e.g., 🥦 Produce, 🥛 Dairy) for easy mobile viewing. - Duplicate Prevention: The "Savings Tracker" logic de-duplicates items so you only ever see the latest, most relevant price for any product. - Maintenance Commands: Simple keywords like clear allow users to reset their list and start fresh. --- 💼 Perfect For - Savvy Shoppers: Finding the lowest prices on groceries and electronics without manual searching. - Budget-Conscious Households: Tracking long-term price trends for recurring household purchases. - E-commerce Researchers: Monitoring competitor pricing and deals automatically. - Teams: Sharing a centralized shopping list that updates with live market data. --- 🔧 What You'll Need Required Integrations - WATI – To handle all WhatsApp triggers and message delivery. - OpenAI API – For item classification and deal extraction. - Serper.dev – To perform high-speed Google Shopping searches. - Google Sheets – As your primary database for lists and deals. --- 🚀 Quick Start 1. Import Template – Copy the JSON and import it into your n8n instance. 2. Set Credentials – Connect your WATI, OpenAI, Serper, and Google Sheets accounts. 3. Configure Sheets – Ensure your Google Sheet has two tabs: Shopping List: phone, item, qty, unit, category, addedAt, listid, username, Status Deals: listid, phone, item, price, originalPrice, storeName, savingPct, Currency, url, summary, confidence, alternatives, foundAt, alertSent 4. Test the Flow – Send list: 1kg rice, milk 2L to your WATI number. 5. Run Comparison – Reply compare to see the AI find the best deals live! --- 📈 Expected Results - 15–25% savings on monthly groceries by consistently identifying the cheapest reputable retailer. - Zero search time: The AI searches the entire web for you in the background. - Automated alerts: Never miss a price drop on items you actually need. - Centralized organization: A tidy, categorized list that replaces messy paper notes or fragmented chat messages. --- Ready to shop smarter? Import this template and connect your Serper account to start saving today!