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

Name: Turn WhatsApp into an AI shopping and price comparison assistant using Wati, OpenAI, Serper, and Google Sheets
Availability: InStock
Author: Jitesh Dugar

Open on n8n.io

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER

Early Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

Overview

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!

Jitesh Dugar

119 workflows

Complexity

advanced

Published 26 Feb 2026

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/13722/13722.json

Share Your Workflow

Have a useful automation to share? Publish it and help the community.

Submit Your Template How to Submit

Related Workflows

Search your travel memories with Gmail, Google Photos, GPT-4 and Claude

**What This Does:** Search your past trips using natural language queries like: - "Show my Goa hotel from last year" - "Where did I stay in Paris?" - "Find my beach trips from 2024" - "Show all Italy restaurants I visited" **How It Works:** 1. User sends natural language query 2. AI extracts search parameters (location, date, type) 3. Searches across multiple data sources 4. AI enriches results with context 5. Returns formatted memories with photos & details **Data Sources:** 📧 Gmail (booking confirmations) 📅 Google Calendar (trip events) 💳 Expense tracking (receipts) 📸 Google Photos (trip images) 🗺️ Google Maps (location history) **Advanced Features:** ⏱️ 3 Strategic wait nodes 🧠 AI-powered query understanding 🔍 Multi-source data fusion 📊 Intelligent ranking & sorting 🎨 Rich response formatting **Use Cases:** - Find old booking confirmations - Remember restaurant names - Retrieve travel documents - Create trip summaries - Share travel memories ### 📊 Monitoring & Analytics **Search Logs:** - All queries saved to Google Drive - Track popular searches - Identify data gaps - Improve AI parsing **Metrics:** - Search success rate - Average response time - Data source coverage - User satisfaction **Performance:** - API call optimization - Cache frequently searched trips - Reduce wait times - Improve relevance **Future Enhancements:** - Voice search support - Multi-language queries - Automatic trip summaries - Share memories feature - Trip comparison tool

View

Auto-respond to job opportunities with Gmail, LinkedIn, GPT-4.1-mini and Google Sheets

Automatically scans incoming job emails and LinkedIn messages, intelligently detects genuine opportunities, and sends personalized, professional replies using your resume and preferences. It extracts job details, crafts human-sounding responses with AI, sends them instantly, and maintains a complete tracking sheet in Google Sheets with status and follow-up dates. Perfect for active job seekers who want to reply faster and smarter without spending hours writing tailored applications. ### Who’s it for • Job seekers applying to 10+ jobs per week • Professionals receiving recruiter inbound messages • Career switchers managing high application volume ### How it works / What it does 1. Captures new job emails or LinkedIn messages 2. Analyzes if it's a relevant job opportunity 3. Loads your resume and preferences 4. AI generates personalized, human reply 5. Sends the tailored response 6. Logs everything with status in Google Sheet ### How to set up 1. Import this workflow 2. Set up credentials (Gmail, Google Sheets, OpenAI/Anthropic) 3. Update your resume text and preferences 4. Activate workflow ### Requirements • Gmail access (or IMAP) • Google Sheets • OpenAI / Anthropic / Grok API • Your latest resume ### How to customize the workflow • Change AI tone in the AI node • Modify Python filter keywords • Update Google Sheet columns • Adjust wait times

View

Track nutrition and fitness via webhook with OpenAI, Google Sheets and Slack alerts

# AI Nutrition Tracker with Webhook, OpenAI, Google Sheets & Slack Alerts This workflow is an AI-powered nutrition and fitness tracking system built in **n8n**. It receives user input via webhook, analyzes food or activity using AI, updates daily calorie and protein intake in Google Sheets and sends alerts via Slack when limits or risks are detected. It also resets daily metrics automatically using a scheduled trigger. ### Quick Start Guide (Fast Implementation) 1. **Connect** your Google Sheets account with required columns. 2. **Configure** OpenAI API credentials. 3. **Set up** Slack integration for alerts. 4. **Deploy** the Webhook node for receiving user input. 5. **Enable** the Schedule Trigger for daily reset. 6. **Test** by sending a sample message (food/activity) to the webhook. ## What It Does This workflow automates real-time nutrition tracking by processing user input such as food consumption or physical activities. When a user sends a message through a webhook, the system fetches their profile data from Google Sheets and validates their existence before continuing. The input is then analyzed using an **AI model** that classifies it as food or activity. Based on this classification, it estimates calories, protein intake, calories burned and identifies potential health risks. The processed data is combined with existing user metrics to maintain an updated daily summary. Additionally, the workflow monitors calorie thresholds and risk patterns. If a user exceeds their daily calorie target or shows unhealthy behavior patterns, alerts are sent to **Slack**. A scheduled process resets all users’ daily metrics, ensuring accurate tracking for each new day. ## Who’s It For * Fitness app developers * Health and wellness platforms * Personal trainers and nutritionists * Automation engineers building health tracking systems * Businesses managing user diet and activity tracking ## Requirements to Use This Workflow * **n8n instance** (self-hosted or cloud) * **Google Sheets account** with a structured sheet * **OpenAI API credentials** * **Slack workspace** with API access * Basic understanding of webhook usage ### Required Google Sheets Columns: * `Name` * `Phone` (used as unique identifier) * `Goal` * `Daily_Calorie_Target` * `Consumed_Calories` * `Protein` * `Last_Meal` * `Status` * `Risk_Count` ## How It Works & How To Set Up ### Step 1: Configure Webhook * **Node:** Receive User Input * Set webhook path (e.g., `/diet-input`) * This endpoint will receive user messages (food/activity input). ### Step 2: Connect Google Sheets * **Node:** Fetch User Data * Map `Phone` column with incoming webhook data (`body.phone`). * Ensure correct **Sheet ID** and **Sheet Name**. ### Step 3: Validate User * **Node:** Validate User Exists * Ensures only valid users are processed. ### Step 4: Configure AI Analysis * **Node:** AI Nutrition Analyzer Uses OpenAI model to: * Detect input type (**FOOD / ACTIVITY**) * Estimate calories & protein * Detect risks * Generate suggestions and replies * **Node:** AI Model (GPT) * Ensure OpenAI credentials are properly connected. ### Step 5: Process Data * **Node:** Process Nutrition Data Updates: **Total calories**, **Protein intake** and **Risk count**. * Handles both food intake and activity adjustments. ### Step 6: Monitor Thresholds * **Node:** Check Calorie Threshold * Sends Slack alert if calorie limit is exceeded. ### Step 7: Risk Detection * **Node:** Check Health Risk: Sends alert if any risk is detected. * **Node:** Check Critical Risk: Sends critical alert if risk count >= 3. ### Step 8: Respond to User * **Node:** Send API Response Returns: AI-generated reply, calories consumed and daily total. ### Step 9: Update User Data * **Node:** Update User Data * Writes updated metrics back to Google Sheets. ### Step 10: Daily Reset Automation * **Node:** Daily Reset Trigger * **Node:** Fetch All Users → Reset Daily Stats Resets: Calories = 0, Protein = 0, Risk Count = 0, Status = `NEW_DAY`. ## How To Customize Nodes * **AI Prompt (AI Nutrition Analyzer):** Modify calorie logic, risk definitions or add new dietary rules. * **Calorie Threshold:** Change comparison logic based on different fitness goals. * **Slack Messages:** Customize alert messages and formatting. * **Google Sheets Mapping:** Add more fields like carbs, fats or water intake. * **Webhook Input Structure:** Adjust input format if integrating with mobile apps or chatbots. ## Add-ons (Extend Functionality) * Add **WhatsApp/SMS** notifications for user alerts. * Integrate with mobile apps for real-time tracking. * Add **meal history logging**. * Include weekly/monthly analytics dashboards. * Add AI meal recommendations based on user goals. * Integrate **wearable data** (steps, workouts). ## Use Case Examples * **Fitness App Backend:** Automatically track user diet and activity in real time. * **Personal Trainer Dashboard:** Monitor client calorie intake and risks. * **Corporate Wellness Programs:** Track employee health metrics and send alerts. * **Diet Coaching Automation:** Provide AI-based suggestions and feedback. * **Health Monitoring Systems:** Detect unhealthy patterns and escalate alerts. ## Troubleshooting Guide | Issue | Possible Cause | Solution | | :--- | :--- | :--- | | **Webhook not receiving data** | Incorrect webhook URL | Verify webhook path and method | | **User not found** | Phone mismatch in Sheets | Ensure phone format matches input | | **AI response parsing fails** | Invalid JSON from AI | Adjust prompt to enforce strict JSON | | **Slack alerts not sent** | Incorrect Slack credentials | Reconnect Slack API | | **Data not updating in Sheets** | Column mapping issue | Verify matching column (Phone) | | **Calories not updating** | Parsing or logic issue | Check code node calculations | | **Daily reset not working** | Schedule trigger configuration | Verify interval settings | ## Need Help? If you need assistance setting up this workflow, customizing AI logic or building advanced automation features, our [n8n development team](https://www.weblineindia.com/hire-n8n-developers/) at **WeblineIndia** is here to help. **We specialize in:** * n8n workflow automation * AI-powered business solutions * Custom integrations and scaling systems 📩 [**Reach out to WeblineIndia**](https://www.weblineindia.com/contact-us.html) to accelerate your automation journey and build powerful, production-ready workflows tailored to your needs.

View

Need Custom Automation?

Get help designing a custom n8n workflow that connects your stack and fits your process.

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

Workflow preview

Overview

🎯 What This Workflow Does

📥 Pipeline A: Intelligent Intake

🔍 Pipeline B: Live Price Engine

📬 Pipeline C: Proactive Deal Alerts

✨ Key Features

💼 Perfect For

🔧 What You'll Need

Required Integrations

🚀 Quick Start

📈 Expected Results