See llms.txt for all machine-readable content.

Back to Templates

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

Created by

Created by: Jitesh Dugar || jiteshdugar
Jitesh Dugar

Last update

Last update 8 months ago

Categories

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!