Kandidatenbewertung (eingereicht)

• •Google-Konto + Gmail API-Anmeldedaten
• •Google Sheets API-Anmeldedaten
• •Google Gemini API Key

{
  "id": "P6NgvqQqtFTVhQ09",
  "meta": {
    "instanceId": "7f1a0694161455be3a7e71f1e0dea04908b0376a1a81e3a0c1e5ac879d48f83a",
    "templateCredsSetupCompleted": true
  },
  "name": "Candidates Rate (Submitted)",
  "tags": [],
  "nodes": [
    {
      "id": "24307a82-75e4-4e51-b888-5be1e8dcf576",
      "name": "JotForm Trigger",
      "type": "n8n-nodes-base.jotFormTrigger",
      "position": [
        -1360,
        288
      ],
      "webhookId": "YOUR_GENERIC_WEBHOOK_ID",
      "parameters": {
        "form": "YOUR_JOTFORM_ID_HERE"
      },
      "credentials": {
        "jotFormApi": {
          "id": "lJxjts7RyK804JCB",
          "name": "JotForm account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e970b876-3ba7-4e01-8b24-bec20187e905",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -1088,
        288
      ],
      "parameters": {
        "text": "=You are a UGC candidate evaluator for [Company Name] skincare campaigns.\n\nRead the candidate form data and calculate a score (0–10) based on these rules:\n+3 if has previous UGC/content experience\n+1 if lives in Helwan\n+1 if age 20–25\n+0.5 if 15–20\n+2 if no kids\n+1 if has child 0–2 years\n+1 if mentions liking or using XQ products\n+0.5 if skin is normal/dry/combination\n+0.5 if not sensitive\n\nReturn only the number — no text, no JSON, no explanation.\n\nCandidate data:\n{{ JSON.stringify($json, null, 2) }}\n",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 2.2
    },
    {
      "id": "e48ba0bd-d476-492a-b215-2722997d3f19",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -1136,
        512
      ],
      "parameters": {
        "options": {
          "temperature": 0.2
        },
        "modelName": "models/gemini-2.5-flash-lite"
      },
      "typeVersion": 1
    },
    {
      "id": "7c9cdf5f-0712-4dad-8e87-3f13aefcaae9",
      "name": "Zeile in Tabelle anhängen oder aktualisieren",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -352,
        160
      ],
      "parameters": {
        "columns": {
          "value": {
            "Age ": "={{ $('JotForm Trigger').item.json['Age From'] }}",
            "Kids": "={{ $('JotForm Trigger').item.json['If you a Mother Please choose you child\\'s age '] }}",
            "Email": "={{ $('JotForm Trigger').item.json.Email }}",
            "Links": "={{ $('JotForm Trigger').item.json['Instagram / Tiktok Links'] }}",
            "AI Rate": "={{ $json.output }}",
            "Address": "={{ $('JotForm Trigger').item.json.Address }}",
            "Work Exp": "={{ $('JotForm Trigger').item.json['Do you have previous similar work experience?'][0] }}",
            "Skin Sens": "={{ $('JotForm Trigger').item.json['Is your skin sensitive or not?'] }}",
            "Skin Type": "={{ $('JotForm Trigger').item.json['What is your skin type?'] }}",
            "Phone Number": "={{ $('JotForm Trigger').item.json['Mobile Number '] }}",
            "Candidate Name": "={{ $('JotForm Trigger').item.json['Your Name'] }}",
            "التاريخ": "={{$now}}"
          },
          "schema": [
            {
              "id": "Candidate Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Candidate Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "التاريخ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "التاريخ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone Number",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Phone Number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Address",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Links",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Links",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Skin Type",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Skin Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Skin Sens",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Skin Sens",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Age ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Age ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Kids",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Kids",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "AI Rate",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "AI Rate",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Work Exp",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Work Exp",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_DOCUMENT_ID/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_GOOGLE_SHEET_DOCUMENT_ID",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_DOCUMENT_ID/edit?usp=drivesdk",
          "cachedResultName": "XQ UGC"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "218f82ef-22a9-4b1d-8ddf-d8eceec69f93",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        -656,
        288
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "ef502dfe-2c19-457e-be7e-b61b80d2324e",
              "operator": {
                "type": "number",
                "operation": "gte"
              },
              "leftValue": "={{ $json.output }}",
              "rightValue": 6
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "9f42af24-db42-4a66-8174-5cb3102e0924",
      "name": "E-Mail mit Kandidatenauswahl senden",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -32,
        -64
      ],
      "webhookId": "YOUR_GENERIC_WEBHOOK_ID_2",
      "parameters": {
        "sendTo": "={{ $json.Email }}",
        "options": {}
      },
      "typeVersion": 2.1
    },
    {
      "id": "6abfc3d9-2a0c-495c-b958-b710df7188b8",
      "name": "Personalabteilung über Auswahl benachrichtigen",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -48,
        240
      ],
      "webhookId": "YOUR_GENERIC_WEBHOOK_ID_3",
      "parameters": {
        "sendTo": "Marketing@yourcompany.com",
        "options": {}
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "OVQrwg5oLZomwQcs",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "ad9c4f6f-1072-488e-b534-d634ced1a0e9",
      "name": "Notizzettel",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1456,
        208
      ],
      "parameters": {
        "color": 3,
        "width": 256,
        "height": 208,
        "content": "Starts the workflow upon form submission. It captures all the candidate's qualification and personal data."
      },
      "typeVersion": 1
    },
    {
      "id": "e95fce78-dd45-460b-b03c-b0ed5ea07558",
      "name": "Notizzettel1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1168,
        208
      ],
      "parameters": {
        "color": 6,
        "width": 368,
        "content": "Calculates a numerical UGC candidate score (0-10) based on the predefined rules from the input data. It uses the Gemini Chat Model for the evaluation."
      },
      "typeVersion": 1
    },
    {
      "id": "2d24b424-d383-440f-a870-97ed9ac62a67",
      "name": "Notizzettel2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -784,
        208
      ],
      "parameters": {
        "color": 4,
        "width": 256,
        "content": "A conditional gate that allows only candidates with an AI Rate of 6 or higher to proceed through the rest of the workflow."
      },
      "typeVersion": 1
    },
    {
      "id": "2de88f97-dd75-494c-8358-274566a239a2",
      "name": "Notizzettel3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -432,
        64
      ],
      "parameters": {
        "color": 5,
        "content": "Adds the candidate's full data and their calculated AI Rate to the Google Sheet. It uses the Email to prevent duplicate entries."
      },
      "typeVersion": 1
    },
    {
      "id": "f3af5415-27be-4580-8178-16f5bf12db3c",
      "name": "Notizzettel4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -128,
        -160
      ],
      "parameters": {
        "color": 4,
        "content": "Sends a customized email to the candidate's address, notifying them that they have been shortlisted based on their high score."
      },
      "typeVersion": 1
    },
    {
      "id": "f2b14e62-bf51-4cf6-9a71-22f2278b5456",
      "name": "Notizzettel5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        160
      ],
      "parameters": {
        "color": 4,
        "width": 320,
        "content": "Sends an internal email to the HR contact (Marketingr@yourcompany.com) with the shortlisted candidate's name and score for quick follow-up."
      },
      "typeVersion": 1
    },
    {
      "id": "51d91032-c735-497c-acc9-b393203696c5",
      "name": "Notizzettel12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1552,
        -624
      ],
      "parameters": {
        "width": 1024,
        "height": 736,
        "content": "# JotForm Setup Guide\n\n\n## ⚡ Step 1: Link with the Webhook\n\n\n* **1. Log in to your JotForm account, select your Form, and navigate to Settings.**\n\n* **2. Go to Integrations and search for Webhooks.**\n\n* **3. Paste the JotForm Trigger Webhook URL provided by your n8n workflow into the field.**\n\n* **4. Save and activate! Your form is now live!**\n\n## 🔑 Step 2: Unlock File Access (API Key)\n\n* **1.Generate a JotForm API Key in your JotForm account settings.**\n\n* **2.CRITICAL: Set the key permission level to \"Full Access\" (required for file downloads).**\n\n* **3.Go to your n8n workflow and insert this key into:**\n    * **I.The JotForm Trigger node's credential.**\n    * **II.The Fetch All Receipts node's query parameters.**\n\n## ⚙️ Step 3: Configure Your n8n Nodes\n\n* **In the JotForm Trigger node replace the placeholder with your actual JotForm ID.**\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "63943148-66f8-4b6c-8ad7-13b994ff669d",
  "connections": {
    "218f82ef-22a9-4b1d-8ddf-d8eceec69f93": {
      "main": [
        [
          {
            "node": "7c9cdf5f-0712-4dad-8e87-3f13aefcaae9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e970b876-3ba7-4e01-8b24-bec20187e905": {
      "main": [
        [
          {
            "node": "218f82ef-22a9-4b1d-8ddf-d8eceec69f93",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "24307a82-75e4-4e51-b888-5be1e8dcf576": {
      "main": [
        [
          {
            "node": "e970b876-3ba7-4e01-8b24-bec20187e905",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e48ba0bd-d476-492a-b215-2722997d3f19": {
      "ai_languageModel": [
        [
          {
            "node": "e970b876-3ba7-4e01-8b24-bec20187e905",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "7c9cdf5f-0712-4dad-8e87-3f13aefcaae9": {
      "main": [
        [
          {
            "node": "9f42af24-db42-4a66-8174-5cb3102e0924",
            "type": "main",
            "index": 0
          },
          {
            "node": "6abfc3d9-2a0c-495c-b958-b710df7188b8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}