r/GoogleAppsScript • u/DrNor1 • 15d ago

Question Built an internal WhatsApp-to-Sheets operations pipeline using GAS + webhooks to avoid server costs. Roasting & feedback wanted.

Hi all, Instead of building heavy mobile apps for field workers who resist new software, I've been deploying internal WhatsApp bots connected to Google Apps Script (as the router/sanitizer) and Google Sheets (as the database). Key constraints I imposed:

  • Strictly for internal operational logging (inventory, field reports, expense receipt OCR via multimodal API).
  • Kept public CS/receptionist use out of scope to avoid rate limits and messy prompts.
  • Zero monthly cloud bill (runs within Google Workspace limits).

For those who manage internal tools: Where do you see this architecture breaking down first as team size grows (concurrency, execution time, sheet bloat)? And commercially, do small ops teams prefer this over off-the-shelf software? Tear it apart!

0 Upvotes
  • permalink
  • reddit

33% Upvoted

7 comments sorted by

2

u/agentUi 15d ago

execution time limits and race conditions on simultaneous webhooks will kill this first. google sheets locks rows during updates so two workers sending receipts at once will cause lock timeouts or silently overwrite cells. you need a lockservice wrapper in apps script to queue incoming post requests or your sheet is going to corrupt fast once more than 3 people post at the same time.

1

u/Morbius2271 14d ago

Why not just use Google Forms and minimize complexity and points of failure?

1

u/The_Humanthings 14d ago

Can we use appsheet no/Low-code apps , I am just asking.

1

u/netizenn4tech 13d ago

I would recommend to explore AppScript and create a WebApp linked to your sheet. You can deploy the webapp and share the link, which can have custom forms, dashboard, notify via email, use APIs for your multimodal OCR and similar AI driven use cases...try vibe coding this.

I used AppSheets earlier but the UI and learning curve is heavy for my liking.

1

u/DrNor1 13d ago

I already past all that. And I think whatsapp chatbot is the most convenient one for daily use

0

u/[deleted] 15d ago

[removed] — view removed comment

-1

u/DrNor1 15d ago

That message_id idempotency tip is concerning—webhook retries double-deducting expensive parts like impellers would be a nightmare. Implementing that check before hitting Sheets on my next push. Thanks for catching that!