AutomationFlowsAI & RAG › Automate Candidate Rejections with Google Sheets, Gpt-4o-mini, Gmail & Clickup

Automate Candidate Rejections with Google Sheets, Gpt-4o-mini, Gmail & Clickup

ByRahul Joshi @rahul08 on n8n.io

This workflow automates the candidate rejection process after interviews. It retrieves interview feedback from Google Sheets, uses AI to structure and score candidate data, applies a scoring threshold, and routes underperforming candidates into a rejection path. The system…

Event trigger★★★★★ complexityAI-powered38 nodesGoogle SheetsClickUpChain LlmLm Chat Azure Open AiGmail
AI & RAG Trigger: Event Nodes: 38 Complexity: ★★★★★ AI nodes: yes Added:

This workflow corresponds to n8n.io template #8525 — we link there as the canonical source.

This workflow follows the Chainllm → Gmail recipe pattern — see all workflows that pair these two integrations.

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
{
  "id": "BykSQdHlk9FP9Bwv",
  "name": "Personalized Rejection/Next-Step Emails",
  "tags": [],
  "nodes": [
    {
      "id": "5e09921b-495b-4051-8e7e-094101b0405b",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -896,
        272
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "5691d2d0-3a2d-4916-956b-0ba7dc7b0b87",
      "name": "When clicking \u2018Execute workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1168,
        272
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "25480bf3-4577-4bca-9a69-af3fe247b6dd",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        -144,
        272
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "ed0faf32-f431-4d7c-812c-eb0d5900dbde",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        384,
        272
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "d7aa7e85-fa0b-4297-a41d-4b5c1782dbe9",
      "name": "Create a task",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        1360,
        384
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0a3a33da-b34f-4a2f-8ebe-5ce83f17a13b",
      "name": "Code1",
      "type": "n8n-nodes-base.code",
      "position": [
        1040,
        384
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "d5f58e01-4ca6-4e7f-8b8b-175f8009f201",
      "name": "Basic LLM Chain",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1008,
        752
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "1d13280a-7c62-4d56-a5c7-60b21f83517a",
      "name": "Azure OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        928,
        992
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f48cab84-dc10-4d40-a1a0-c4f55e1a6d4f",
      "name": "Basic LLM Chain1",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1008,
        -112
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "40437efb-9de9-4f37-a3c8-05129dfc44f0",
      "name": "Azure OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        976,
        80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1c8977ed-9e37-4ec9-a96f-b9c32be4a4dc",
      "name": "email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1696,
        16
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "f774b394-32b9-4a8f-b6ce-c2d39b6da144",
      "name": "Code2",
      "type": "n8n-nodes-base.code",
      "position": [
        1456,
        -112
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "36d19753-aa69-4128-b823-cfa3a805defc",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        1696,
        -288
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "ed6326c6-5a90-4862-b0a8-247997f946e9",
      "name": "Create a task1",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        1952,
        -288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b69b047f-661b-4c2d-9521-024a41a247c4",
      "name": "Code3",
      "type": "n8n-nodes-base.code",
      "position": [
        1456,
        752
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "896b7ce1-dc3d-412b-a102-1a1a6a67a204",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1232,
        32
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1cb85452-3ffe-467f-a22a-3b5d3ad72463",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -960,
        432
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a94b4a1b-9826-4425-b74d-83222509b02c",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -528,
        576
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2144dd60-1439-43cc-ad5f-2c84ad3a78f3",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -592,
        16
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "50700ff2-3f4d-497c-b327-59780c52e734",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -208,
        32
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5fe6a5c0-ca69-4c8f-8237-9679d908cc19",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        64
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "153f6322-a7f4-4372-95fb-238c5f78d21c",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        -368
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "941e7baa-aac9-4d84-8fd9-eb3f5e542d32",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1344,
        -336
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d9f1690f-b845-4331-9cc8-5c134db3d74d",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1632,
        -528
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "77ae501d-d973-48b6-9992-c9769e5a90b6",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2096,
        -464
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9e872177-fbe3-45de-b984-a62890e1465f",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1824,
        128
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ae0c80f9-7de8-4c82-95ae-225d82ee9fa7",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        992,
        512
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b481151c-59fb-4f0a-a345-e594fbe113f1",
      "name": "Sticky Note12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1488,
        480
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5f326d40-38b1-491a-9b7a-58cc8a77374d",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1088,
        896
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "10a811f1-82cf-44af-b91f-76f9e49e3ea9",
      "name": "Sticky Note14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1456,
        928
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f39d6a97-51a9-4789-b8e7-56a105732c75",
      "name": "Sticky Note15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1952,
        768
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a6b0c4d6-5ff9-4b7b-94d2-0e5d62b491bb",
      "name": "Sticky Note16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        768,
        1136
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e5e7f8d3-cbfc-4b62-9271-35a14eda8a26",
      "name": "Basic LLM Chain2",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -592,
        272
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "25d2de23-9b00-4bee-99e3-ea2e72243451",
      "name": "Azure OpenAI Chat Model2",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        -640,
        544
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5927b63e-c1f1-4876-9317-428455239b5a",
      "name": "Code4",
      "type": "n8n-nodes-base.code",
      "position": [
        112,
        272
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "4c314c63-1fec-4d5e-b372-18c55d7c4136",
      "name": "Sticky Note17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        304,
        32
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3fbc3a95-eacc-4775-8c9b-c503621d2667",
      "name": "Sticky Note18",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        48,
        464
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "067dff48-20a6-4463-96b6-2d677bed7e80",
      "name": "Send Rejection Email1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1744,
        752
      ],
      "parameters": {},
      "typeVersion": 2.1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "b0888655-aff8-4cea-9d1b-fa5297ccddc9",
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Basic LLM Chain1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Code1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Basic LLM Chain",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code": {
      "main": [
        [
          {
            "node": "Code4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code1": {
      "main": [
        [
          {
            "node": "Create a task",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code2": {
      "main": [
        [
          {
            "node": "email",
            "type": "main",
            "index": 0
          },
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code3": {
      "main": [
        [
          {
            "node": "Send Rejection Email1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code4": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "email": {
      "main": [
        []
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Create a task1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain": {
      "main": [
        [
          {
            "node": "Code3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain1": {
      "main": [
        [
          {
            "node": "Code2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain2": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Basic LLM Chain2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model2": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain2",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \u2018Execute workflow\u2019": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

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

About this workflow

This workflow automates the candidate rejection process after interviews. It retrieves interview feedback from Google Sheets, uses AI to structure and score candidate data, applies a scoring threshold, and routes underperforming candidates into a rejection path. The system…

Source: https://n8n.io/workflows/8525/ — 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

Streamline interview feedback handling with this rejection-focused workflow. It processes raw interview feedback, applies an AI-powered scoring model, checks against a threshold, and automatically sen

Gmail, Google Sheets, ClickUp +2
AI & RAG

Automatically capture customer onboarding help requests from Typeform, log them in Google Sheets, validate email addresses, and send a professional HTML welcome email via Gmail. Ensures smooth onboard

Typeform Trigger, Google Sheets, Gmail +6
AI & RAG

This workflow automates personalized candidate communication for both shortlisted and rejected applicants. It fetches candidate details, processes resumes, checks for errors, and uses GPT-4o to genera

Google Sheets, Google Drive, Lm Chat Azure Open Ai +2
AI & RAG

This workflow automates Zendesk ticket handling with AI-powered auto-replies. It pulls in new support tickets, checks against a Google Sheets FAQ database, and generates accurate responses using GPT-4

Lm Chat Azure Open Ai, Zendesk, Google Sheets +2
AI & RAG

This workflow automates the entire release note creation and announcement process whenever a task status changes in ClickUp. Using Azure OpenAI GPT-4o, Notion, Slack, Gmail, and Google Sheets, it conv

Lm Chat Azure Open Ai, Google Sheets, ClickUp Trigger +5