← Back to Work
2026 Featured

Heirloom Licenses Platform

Centralized licensing backend powering multiple Google Workspace add-ons with Stripe integration and usage analytics.

Technologies

Next.js Vercel Stripe Supabase TypeScript

Key Outcomes

  • Single backend serving 3+ Google Workspace products
  • Automated license provisioning on payment
  • Real-time validation API for add-ons
  • Comprehensive usage logging

Unified Licensing Infrastructure

When building multiple Google Workspace add-ons, I needed a single source of truth for licensing, payments, and user management. Heirloom Licenses is that backbone.

Why Build It?

Each add-on needs:

  • License key validation
  • Stripe checkout integration
  • Usage tracking
  • Support for free tiers vs paid tiers

Rather than duplicate this across every product, I built a shared backend that all my add-ons call into.

Architecture

API Endpoints

  • GET /api/validate - Check if a license is valid
  • POST /api/checkout - Create Stripe checkout session
  • POST /api/webhook - Handle Stripe payment events
  • GET /api/licenses - Admin dashboard

Database (Supabase)

  • licenses - Active licenses with product mapping
  • validation_logs - Every validation request (analytics)
  • stripe_events - Payment event history

Products Supported

  1. Groups Manager Pro - Google Groups bulk management
  2. Email Attachment Importer - Gmail to Sheets automation
  3. FormVue - Form response analytics (in development)

Key Decisions

Supabase over Firebase

  • SQL queries for complex analytics
  • Row-level security for multi-tenant safety
  • Generous free tier for indie projects

Vercel for hosting

  • Zero-config deployment
  • Edge functions for low latency
  • Easy preview deployments for testing

Results

A single fetch() call from any Google Apps Script validates licenses in real-time. New products take minutes to add, not days.