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

Description

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!