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

by Rahul Joshi ✓ · 84 views · created 2025-12-29 · Document Extraction, AI Summarization

What this workflow does

This AI workflow has 14 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets, Azure OpenAI Chat Model and Gmail.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. Extract & Normalize Registration Payload (Code): runs custom JavaScript code
2. Validate Registration Payload Structure (If): checks a condition and branches into true / false
3. AI Eligibility Evaluator (DPDP Compliance) (AI Agent): runs an AI agent, with model: Configure GPT-4o — Eligibility Evaluation Model
4. Write Initial Registration Entry to Sheet (Google Sheets): append
5. Log Invalid Registration Requests to Sheet (Google Sheets): append
6. Parse AI Eligibility JSON Output (Code): runs custom JavaScript code
7. Validate Eligibility Status (If): checks a condition and branches into true / false
8. Merge Registration + Eligibility Summary (Code): runs custom JavaScript code
9. Send Rejection Email to Applicant (Gmail): uses Gmail
10. Send Approval Email to Compliance Team (Gmail): uses Gmail

…plus 2 more steps. See the full node list below.

Services it uses

Google SheetsAzure OpenAI Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (8)

• Webhookn8n-nodes-base.webhook
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Google Sheetsn8n-nodes-base.googleSheets
• Azure OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatAzureOpenAi
• AI Agent@n8n/n8n-nodes-langchain.agent
• Gmailn8n-nodes-base.gmail
• Edit Fields (Set)n8n-nodes-base.set

From the author

📘 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,…

View the original on n8n.io → Check your own copy