INSPARISK SYSTEM ARCHITECTURE

20 Netlify Functions • Supabase PostgreSQL • Claude AI • 6 External Services
Network
Propply AI
Pipeline
Other
External
8
Network APIs
4
Propply AI APIs
4
Pipeline APIs
4
Other APIs
6
External Services
25+
DB Tables
All Systems
Network
Propply AI
Pipeline
Other
The Insparisk Network — 8 Functions
📋
Application Submit
network-apply.js
Full member application: validates data, creates records, sends emails
POST Public
📝
Partial Application
network-apply-partial.js
Saves abandoned app contact info for follow-up outreach
POST Public
🏢
Admin API (IO)
network-admin.js
IO dashboard backend: members, notes, status, suggestions, pulse stats
GET PATCH JWT / Key
🔍
Status Check
network-status.js
Applicants check their application status by email
GET Public
📁
File Upload
network-upload.js
Members upload insurance certs, W9, licenses to Supabase Storage
POST Member ID
📍
Location Services
network-location-services.js
Returns required compliance services per state for the application form
POST Public
💡
Suggest Compliance
network-suggest-compliance.js
Users report missing requirements; AI validates and routes
POST Public + AI
⏰
Abandoned Follow-up
network-abandoned-followup.js
Daily 9AM ET: emails applicants who started but didn't finish
CRON Daily
Propply AI Compliance Engine — 4 Functions
🤖
Compliance Research
compliance-research.js
Claude Haiku researches state compliance requirements; caches via Blobs; backfills Supabase
POST Public
🔐
API Compliance
api-compliance.js
Protected Propply AI endpoint with rate limiting for external consumers
POST API Key
👍
Compliance Vote
compliance-vote.js
Vote on AI-generated compliance requirements (Netlify Blobs storage)
POST GET Public
🗳️
Suggestion Votes
network-compliance-vote.js
Upvote/downvote user-submitted compliance suggestions
POST Public
Insparisk Pipeline (Gov Opportunities) — 4 Functions
🔄
Pipeline Ingest
pipeline-ingest.js
Daily 9PM ET: fetches SAM.gov + Grants.gov, classifies with Claude AI, stores results
CRON Configurable
📊
Pipeline API
pipeline-api.js
Full CRUD: opportunities, stats, sources, logs, settings, feedback voting
GET POST PATCH JWT / Key
📧
Pipeline Digest
pipeline-digest.js
Daily 7AM ET: emails summary of new/urgent opportunities to team
CRON Configurable
🚀
Pipeline Match
pipeline-match.js
Phase 2: Auto-match opportunities to Network members by territory + services
FUTURE
Other Services — 4 Functions
🔧
Schedule Inspection
schedule-inspection.js
Inspection scheduling form; emails team + logs to Google Sheets
POST Public
💰
Submit Quote
submit-quote.js
Quote request form with reCAPTCHA; sends customer + sales emails
POST Public
💳
Process Payment
process-payment.js
ACH + credit card via Authorize.net; sends confirmations
POST Public
💬
Iris Chatbot
chat.js
Claude Haiku chatbot for NYC compliance Q&A (LL84, LL87, LL97)
POST Public
External Services & Infrastructure
🐘
Supabase / PostgreSQL
Primary database, Auth, Storage
25+ tables, 4 views
🧠
Claude Haiku API
AI classification, research,
validation, chatbot
✉️
Resend
Transactional email
noreply@insparisk.com
🏛️
SAM.gov API
Federal contracts
NAICS-based search
🏛️
Grants.gov API
Federal grants
Keyword-based search
💳
Authorize.net
Payment processing
ACH + Credit Card

Key Data Flows

How the three systems connect and share data

APPLY
Applicant → network-apply.js → Supabase (network_members) → Resend (confirmation email)
TERRITORY
Step 3 (Map) → location-services.js → compliance_service_map → Step 4 (Service Badges)
BACKFILL
compliance-research.js → Claude Haiku → compliance_service_map + compliance_suggestions
INGEST
SAM.gov + Grants.gov → pipeline-ingest.js → Claude Haiku (classify) → pipeline_opportunities
DIGEST
pipeline_opportunities → pipeline-digest.js → Resend (daily email) → Team Inbox
FEEDBACK
Admin (IO Panel) → pipeline-api.js (vote) → pipeline_feedback → AI Agent (learns)
FUTURE
pipeline_opportunities → pipeline-match.js → pipeline_matches → Member Portal
LEARN
Users / AI → suggest + vote → compliance_suggestions → Admin merges → compliance_service_map