n8nSupabase (PostgreSQL / ERPNext Data)Google Gemini 2.5 ProNext.jsVercelGmail APIPDFShift API
Built an AI-powered financial intelligence platform that automates business performance reporting for a multi-cost-center organization.
The platform collects raw financial data such as GL entries, budgets, WIP, and employee records from Supabase, processes and structures the data into financial statements, and uses an AI analyst agent to generate complete Profit & Loss reports, department performance insights, and executive recommendations. Reports are automatically generated and delivered through email in HTML and PDF formats.
Transformed raw financial records into structured sections: YTD vs Previous Month Summary, Vertical P&L Report, WIP Analysis, Employee Performance Report.
Combined all sections into a single consolidated financial report.
Report Generation & Delivery
Added validation logic to verify AI-generated reports before processing.
Converted AI-generated HTML reports into PDF using PDFShift API.
Automated report delivery through Gmail API with formatted email content and attachments.
Implemented batching, wait, and loop controls to safely process multiple cost centers without API overload.
Frontend Dashboard
Developed a Next.js dashboard deployed on Vercel.
Created an interface where users select date ranges and trigger report generation.
Connected the frontend with n8n automation workflows through webhooks.
