Back to Portfolio
2023
Google Apps ScriptCleverTap APIAutomation

14x Efficiency Automation Engine

"Engineered a custom Google Apps Script solution that interfaced with CleverTap APIs to automate complex campaign deployments — one person now manages what previously required a 14-member team, across 100+ cities from a single sheet."

14x Efficiency Automation Engine

Executive Summary

A one-click campaign deployment system built on Google Apps Script and the CleverTap API. From a single Google Sheet, campaigns for 100+ cities are configured, validated, and pushed live — with dynamic discounts, creatives, and reach estimates calculated before launch.

Key Outcomes

  • Workload that needed a 14-member team is now handled by one person.
  • Campaigns for 100+ cities deployed simultaneously from a single sheet.
  • Human error in campaign setup nearly eliminated via validation rules.
  • Pre-launch reach estimates made every deployment predictable.

Next Case Study

IPL SUPER40/60 Live-Match Engine

A fully automated campaign machine for IPL: scraped live Cricbuzz scores (saving ₹5L+ in API costs), auto-executed every match roster, live trigger, and offer across two seasons with zero failures — including IND vs PAK — plus a server-driven UI banner shipped in the AbhiBus app.