Property Portal Development

I have a working property investment platform built in HTML/JavaScript with a Supabase backend. The app is live at https://glittery-gelato-5542af.netlify.app and includes: Public property listings portal Referral partner portal with commission dashboard Partner registration with legal agreement Client registration system Admin panel with full CRUD PDF generation with partner branding Supabase PostgreSQL database What I Need Added 1. Email Forwarding Parser (Priority) Set up an inbound email address (e.g. using Mailgun or similar) When I forward a builder email to that address, AI extracts property details automatically Property gets added to Supabase database with X amount extra margin Builder/developer name is stored internally but never shown publicly I get a notification when a property is imported 2. Smartsheets Sync I provide a Smartsheets public share URL in the admin panel App reads the sheet data on a schedule (every 6 hours) Extracts all property listings and adds to Supabase Avoids duplicates on each sync margin applied automatically Builder name hidden from public view 3. Portal Scraping I provide login credentials for builder portals (standard websites) App logs in using browser automation (Puppeteer or Playwright) Scrapes property listings on a schedule Adds new listings to Supabase margin applied automatically Builder name stored internally only 4. Fix AI Property Extraction Currently failing due to CORS issues with Netlify Functions Need a proper Node.js backend to handle: PDF file uploads → AI extracts properties Excel/CSV uploads → AI extracts properties Pasted text/email → AI extracts properties Uses Anthropic Claude API (key provided) Tech Stack Frontend: HTML/JavaScript (single page app) — must be preserved as-is Database: Supabase (PostgreSQL) — credentials provided Hosting: Netlify (can move if needed) AI: Anthropic Claude API — key provided Email parsing: Mailgun or equivalent inbound email service Scraping: Puppeteer or Playwright What's Already Built (Do Not Change- Unless you have a better idea) Full partner registration and agreement flow Commission dashboard with fixed amounts per property type Client registration system Login activity tracking and suspicious login detection PDF generation with partner logo branding Resources section (admin adds, partners view) Property filters (type, state, price, ROI, status) Card and list view toggle Shareable partner links with no iInvest branding Business Rules (Must Be Respected) Builder/developer names never shown publicly or to partners — internal admin only All imported prices must have X margin added automatically Property types: Land, House & Land, Dual Key, Duplex, Unit, Townhouse, Co-Living Commission rates: House & Land/Land/Townhouse =X— Dual Key/Duplex/Co-Living = $X Default inclusions on every property: Site works, Fixed price contract, Fencing, Landscaping, Move in ready Deliverables Working email forwarding inbox that auto-imports properties Smartsheets auto-sync running on schedule Portal scraping for at least 3 builder portals I specify Fixed AI extraction for PDF, Excel, and text paste All features tested and working on live site v I will provide: GitHub repository access Supabase project URL and API keys Anthropic API key Builder portal login credentials (under NDA) Smartsheets public links Live site URL for testing So the idea is to get all the properties from all the developers from smart sheets, portals, excel or any other means (pdf) and we need to make sure it get added to the database automatically. Auto-sync is the key here.