
Longview App
AI Powered Blog Writer Platform

Overview
Andy McClure (Longview Marketing Agency)
August 2025
7-30 days
Industries
The Challenge
The project required strict tenant isolation, custom brand configurations, secure Supabase authentication, and Google Drive integration for exporting AI-generated drafts — all while keeping performance and usability top-tier.
Our Solution
Engineered the Longview AI Blog Writer Tool from scratch using Next.js, Supabase, and OpenAI's GPT-4 API. The app features complete role-based access control (admin/client roles), structured AI generation pipelines (validated via JSON schema), and Google Workspace integration for automatic document export. Each tenant's Brand Pack (tone, SEO, and compliance rules) directly influences AI behavior. Implemented RLS (row-level security), dynamic prompt injection, and full audit logging for transparency.
Technologies Used
Results & Outcome
Delivered a production-grade, scalable app with real-time draft generation, seamless Google Docs export, and per-tenant token usage tracking. The client praised the clean UX, strong architecture, and reliable data isolation.
Gallery
Project Screenshots

