Screen DPDP consent manager registrations with GPT-4o, Google Sheets and Gmail

📘 Description

This workflow automates the complete DPDP-aligned Consent Manager Registration screening pipeline — from intake to eligibility evaluation and final compliance routing. Every incoming registration request is normalized, validated, logged, evaluated by an AI compliance engine (GPT-4o), and then routed into either approval or rejection flows. It intelligently handles missing documentation (treated as a minor issue), evaluates financial/technical/operational capacity, generates structured eligibility JSON, updates registration records in Google Sheets, and sends outcome-specific emails to applicants and compliance teams. The workflow creates a full audit trail while reducing manual screening workload and ensuring consistent eligibility decisions.

⚙️ What This Workflow Does (Step-by-Step)

▶️ Receive Consent Registration Event (Webhook) Collects incoming Consent Manager registration applications and triggers the processing pipeline. 🧹 Extract & Normalize Registration Payload (Code Node) Cleans the body payload and extracts key fields: action, organizationName, applicationType, contactEmail, netWorth, technicalCapacity, operationalCapacity, documentAttached, submittedAt. 🔍 Validate Registration Payload Structure (IF Node) Checks the presence of mandatory fields. Valid → continue to eligibility evaluation Invalid → log in the audit sheet. 📄 Log Invalid Registration Requests to Sheet (Google Sheets) Stores malformed or incomplete submissions for audit, follow-up, and retry handling. 📝 Write Initial Registration Entry to Sheet (Google Sheets) Creates the initial intake row in the master registration sheet before applying eligibility logic. 🧠 Configure GPT-4o — Eligibility Evaluation Model (Azure OpenAI) Prepares the AI model used to determine whether the applicant meets DPDP’s eligibility criteria. 🤖 AI Eligibility Evaluator (DPDP Compliance) Analyzes applicant data and evaluates their eligibility based on: financial capacity, technical capability, operational readiness, and documentation status. Missing documents → NOT a rejection condition. Returns strictly formatted JSON with: eligible, riskLevel, decisionReason, missingItems, recommendedNextSteps. 🧼 Parse AI Eligibility JSON Output (Code Node) Converts AI output into valid JSON by removing markdown artifacts and ensuring safe parsing. 🔎 Validate Eligibility Status (IF Node) Routes the outcome: Eligible → approval workflow Ineligible → rejection email. 📧 Send Rejection Email to Applicant (Gmail) Sends a structured rejection email listing issues and re-submission instructions. 🔗 Merge Registration + Eligibility Summary (Code Node) Combines raw registration data with AI eligibility results into one unified JSON package. 📬 Send Approval Email to Compliance Team (Gmail) Notifies compliance officers that an applicant passed eligibility and is ready for verification. 🧩 Prepare Status Update Fields (Set Node) Constructs the final status value (e.g., “passed”) for updating the database. 📘 Update Registration Status in Sheet (Google Sheets) Updates the applicant’s record using contactEmail as the key, marking the final eligibility status.

🧩 Prerequisites

Azure OpenAI (GPT-4o) credentials Gmail OAuth connection Google Sheets OAuth connection Valid webhook endpoint for intake

💡 Key Benefits

✔ Fully automates DPDP Consent Manager registration screening ✔ AI-driven eligibility evaluation with standardized JSON output ✔ Smart handling of missing documents without unnecessary rejections ✔ Automatic routing to approval or rejection flows ✔ Complete audit logs for all submissions ✔ Reduces manual review time and improves consistency

👥 Perfect For

• DPDP compliance teams
• Regulatory operations units
• SaaS platforms handling consent manager onboarding
• Organizations managing structured eligibility workflows