Dev.to
7/14/2026

The original title is "Build a WhatsApp Sales Inbox in Google Sheets (Apps Script + GPT-4o-mini)"
Original: Build a WhatsApp Sales Inbox in Google Sheets (Apps Script + GPT-4o-mini)
Short summary
A practical tutorial for building a WhatsApp sales inbox in Google Sheets using Apps Script and GPT-4o-mini. Messages are captured via webhook, scored for buying intent by an LLM, and locked to a single rep for 15 minutes to prevent duplicate outreach. Includes ~80 lines of copy-paste Apps Script code covering webhook handling, deduplication, scoring, and lead assignment.
- •Webhook captures WhatsApp messages and logs them to a Google Sheet
- •GPT-4o-mini scores each message for buying intent (Hot/Warm/Cold)
- •15-minute lock prevents two reps from chasing the same lead
Generated with AI, which can make mistakes.
Is this a good recommendation for you?



