AutomationFlowsAI & RAG › Portal Access Orchestrator (workflow 132)

Portal Access Orchestrator (workflow 132)

Portal Access Orchestrator (Workflow 132). Uses googleGeminiChat, emailSend, airtable. Webhook trigger; 5 nodes.

Webhook trigger★★★★☆ complexityAI-powered5 nodesGoogle Gemini ChatEmail SendAirtable
AI & RAG Trigger: Webhook Nodes: 5 Complexity: ★★★★☆ AI nodes: yes Added:

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "name": "Portal Access Orchestrator (Workflow 132)",
  "nodes": [
    {
      "parameters": {
        "httpMethod": "POST",
        "path": "trigger-portal-access",
        "options": {}
      },
      "name": "Webhook Trigger",
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 1,
      "position": [
        250,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "const crypto = require('crypto');\nconst token = crypto.randomBytes(24).toString('hex');\nreturn { magicLink: `https://nexus-os.com/login?token=${token}`, token };"
      },
      "name": "Generate Magic Link",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        450,
        300
      ]
    },
    {
      "parameters": {
        "modelId": {
          "__rl": true,
          "value": "gemini-1.5-flash",
          "mode": "list"
        },
        "prompt": "=Write a 2-sentence welcome email for a {{$node[\"Webhook Trigger\"].json.body.role}} named {{$node[\"Webhook Trigger\"].json.body.name}} regarding property {{$node[\"Webhook Trigger\"].json.body.address || 'their upcoming transaction'}}. Tone: Professional and warm. Mention they can see their transaction timeline and active playbook steps inside.",
        "options": {}
      },
      "name": "Gemini: Personal Onboarding",
      "type": "n8n-nodes-base.googleGeminiChat",
      "typeVersion": 1,
      "position": [
        650,
        300
      ],
      "credentials": {
        "googlePalmApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "fromEmail": "onboarding@nexus-os.com",
        "toEmail": "={{$node[\"Webhook Trigger\"].json.body.email}}",
        "subject": "Welcome to your Transaction Portal",
        "text": "=Welcome to your Transaction Portal.\n\n{{$json.output}}\n\nClick here to enter securely: {{$node[\"Generate Magic Link\"].json.magicLink}}"
      },
      "name": "SendGrid: Dispatch Invite",
      "type": "n8n-nodes-base.emailSend",
      "typeVersion": 2,
      "position": [
        850,
        300
      ],
      "credentials": {
        "smtp": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "operation": "upsert",
        "baseId": "appYOURBASEID",
        "table": "Portal_Users",
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "Email": "={{$node[\"Webhook Trigger\"].json.body.email}}",
            "Role": "={{$node[\"Webhook Trigger\"].json.body.role}}",
            "Onboarding_Status": "Invited",
            "Magic_Link_Token": "={{$node[\"Generate Magic Link\"].json.token}}",
            "Linked_Deal_ID": "={{$node[\"Webhook Trigger\"].json.body.dealId}}"
          }
        },
        "options": {
          "externalIdColumn": "Email"
        }
      },
      "name": "Airtable: Identity Store",
      "type": "n8n-nodes-base.airtable",
      "typeVersion": 1,
      "position": [
        1050,
        300
      ],
      "credentials": {
        "airtableApi": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "Webhook Trigger": {
      "main": [
        [
          {
            "node": "Generate Magic Link",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Magic Link": {
      "main": [
        [
          {
            "node": "Gemini: Personal Onboarding",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gemini: Personal Onboarding": {
      "main": [
        [
          {
            "node": "SendGrid: Dispatch Invite",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SendGrid: Dispatch Invite": {
      "main": [
        [
          {
            "node": "Airtable: Identity Store",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Portal Access Orchestrator (Workflow 132). Uses googleGeminiChat, emailSend, airtable. Webhook trigger; 5 nodes.

Source: https://github.com/YHSG-Kling/Smart-Engine--VIP-Agents/blob/39a4392cd3e306846338d3870d4add1e5c4c0d54/workflows/portal-access.json — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

This workflow continuously monitors CVE databases, threat intelligence feeds, and public security advisories to surface emerging zero-day threats, correlates them against your registered infrastructur

Airtable, HTTP Request, Agent +3
AI & RAG

This workflow monitors active construction projects in real time, ingests weather forecasts, supplier delivery statuses, and crew/resource availability, then uses Claude AI to predict delay risk, esti

Airtable, HTTP Request, Agent +3
AI & RAG

fireflies. Uses openAi, httpRequest, emailSend, chainLlm. Webhook trigger; 25 nodes.

OpenAI, HTTP Request, Email Send +3
AI & RAG

Automate candidate evaluation from CV submission to interview booking. Perfect for HR teams and recruiters.

Airtable, HTTP Request, Information Extractor +6
AI & RAG

This workflow ingests student profiles from a form submission or CRM, loads the active scholarship catalogue, uses Claude AI to score each student's eligibility against every available scholarship, fi

Airtable, Agent, Anthropic Chat +3