Projects using Google Sheets in IkejaProjects using Google Sheets in IkejaAutomated Omni-Channel Content Repurposing Engine (n8n + AI)
Developed a production-grade, self-hosted content repurposing pipeline using n8n and high-speed LLM architectures. The system ingests a single source document (article, transcript, or video script) and produces seven platform-calibrated deliverables in under four seconds.
The Problem:
Marketing teams spend 10 to 15 hours per week manually adapting high-performing long-form assets for secondary social channels. Existing SaaS repurposing tools lock users into expensive monthly subscriptions, restrict prompt customizability, and lack custom distribution endpoints.
Technical Architecture:
Intake Layer: Standardized web form trigger with parameter validation for brand voice, audience profile, and raw content.
Analysis & Core Extraction: Automated information extraction isolating key thesis statements, audience pain points, and viral angles.
Multi-Model Sequential Drafting: Seven dedicated LLM chain nodes executing custom prompts for LinkedIn, Twitter/X, Instagram, Email Newsletters, 60-second video scripts, Telegram announcements, and SEO metadata.
Mobile Dispatch Integration: Dual-part Telegram API dispatch delivering 1-tap copyable monospace blocks directly to mobile devices without hitting API character thresholds.
Database Archival: Automated record creation in Google Sheets across 11 synchronized columns for long-term content asset indexing.
Deliverables & Results:
Fully functional n8n workflow JSON with zero external SaaS dependencies.
90% reduction in multi-channel adaptation turnaround time.
Direct operational cost reduced to under $0.01 per omni-channel package.
Complete documentation and credential onboarding guide. I created this Excel-based property management system to efficiently track tenants, rent payments, maintenance requests, and rental enquiries in one place.
The system is designed for rooming house/property managers to stay organized, monitor payment status (paid, pending, overdue), manage tenant records, and coordinate maintenance tasks with ease.
It helps streamline daily operations, improve communication, and ensure nothing falls through the cracks. Project Title: Production-Grade n8n Lead Capture & Routing Engine
Project Overview:
Most marketing campaigns bleed high-ticket leads due to silent automation failures—unformatted phone numbers, API rate limits, or network timeouts. I engineered this fault-tolerant lead capture pipeline in n8n to guarantee 100% data integrity for incoming web and ad traffic.
The Architecture & Data Flow:
Production Ingress & Handshake: A custom webhook instantly catches payload submissions and holds the HTTP connection open until processing finishes, returning explicit 200 OK or 400 Bad Request signals directly to the frontend form.
Automated Data Sanitation: A javascript logic layer intercepts raw data, strips whitespace, standardizes casing, and normalizes regional phone numbers into strict E.164 international formats before it ever touches a database.
Smart Deduplication Engine: The system queries existing database records in real-time. If a match is found, it updates the engagement timestamp and routes the duplicate to an isolated audit log, preventing CRM pollution without ignoring the prospect.
Multi-Tab Database Sync: Clean traffic is routed into segmented Google Sheets or database tables (Valid Leads, Invalid Leads, Duplicates), ensuring sales reps only see verified data.
Speed-to-Lead Dispatch: Instantly triggers an internal email/Slack alert to the sales team while simultaneously firing a contextual, personalized auto-reply to the prospect.
Decoupled Error Recovery: If any external node fails, an isolated global error-trigger captures the exact n8n execution URL and stack trace, alerting the administrator instantly so no lead is ever silently dropped.
Tech Stack: n8n, JavaScript, REST APIs, Google Sheets API, Postman (for payload stress testing). 
