Dev.to
7/20/2026

Build a WhatsApp Storefront in Google Sheets with OpenAI Function Calling (No Website)
Short summary
A practical tutorial for building a WhatsApp-based storefront using Google Sheets as the database and OpenAI function calling for natural-language product browsing and order logging. Three tools (list products, lookup product, log order) handle the entire flow in ~200 lines of Apps Script, costing under $20/month. The server computes totals and validates orders — the model never touches money directly.
- •Three OpenAI function-calling tools turn WhatsApp + Google Sheets into a full storefront for <$20/month
- •~200 lines of Apps Script; no website, Shopify, or domain needed
- •Server-side price validation and order logging — the model never computes totals
Generated with AI, which can make mistakes.
Is this a good recommendation for you?



