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

Import Template – Copy the JSON and import it into your n8n instance. Set Credentials – Connect your WATI, OpenAI, Serper, and Google Sheets accounts. 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

Test the Flow – Send list: 1kg rice, milk 2L to your WATI number. 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!