AutomationFlowsAI & RAG › Lead Qualification & Auto-assignment with Gpt-4 Mini: Google Sheets to Clickup

Lead Qualification & Auto-assignment with Gpt-4 Mini: Google Sheets to Clickup

ByRahul Joshi @rahul08 on n8n.io

Description

Cron / scheduled trigger★★★★☆ complexityAI-powered17 nodesChain LlmOpenAI ChatClickUpGoogle Sheets
AI & RAG Trigger: Cron / scheduled Nodes: 17 Complexity: ★★★★☆ AI nodes: yes Added:

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

This workflow follows the Chainllm → Google Sheets 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": "Pr9N8Qv2r0QN4xNn",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Task Assignment and Ownership in ClickUp",
  "tags": [
    {
      "id": "mcI28lNgyo60M2wb",
      "name": "Lead Automation",
      "createdAt": "2025-09-03T08:08:38.479Z",
      "updatedAt": "2025-09-03T08:08:38.479Z"
    }
  ],
  "nodes": [
    {
      "id": "8c83502f-a29c-4048-a6cc-4d98158a5801",
      "name": "Every 5 Minutes",
      "type": "n8n-nodes-base.cron",
      "position": [
        96,
        352
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "fdd4ac7d-603b-486a-94b7-cbcd02304c45",
      "name": "Basic LLM Chain",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        800,
        336
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "0f73dd56-3892-403d-add1-302b92af9f82",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        752,
        560
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "902b212d-bed6-4448-8bcc-966876cf155a",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        48,
        128
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b4c12526-52df-4ed3-9f69-285cc4b00884",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        144
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d040c008-842d-4d99-b09c-dfc01684c948",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        256,
        544
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e89846e0-2f35-4391-94c1-c777718d62df",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        832,
        96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c0fc238b-0a2a-4789-b09e-2e835da78ea3",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1152,
        512
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9baa1c57-20b4-42ac-807e-61e636ffbed3",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1344,
        96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "791072e2-a9ba-492f-8ec9-f8c14fa7d142",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1600,
        512
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e7803d39-8513-4f2b-9248-e5b425038ddd",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1808,
        96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f7560e2f-62d2-448d-9fc5-dc754c222538",
      "name": "Restructuring AI Output",
      "type": "n8n-nodes-base.code",
      "position": [
        1200,
        336
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "0df28053-2ff9-41f2-8e67-3a18052f6940",
      "name": "Creating and Assigning Tasks",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        1408,
        336
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "bd9a8584-3bb9-4339-932f-fcb62922ec6c",
      "name": "Restructuring ClickUp Output",
      "type": "n8n-nodes-base.code",
      "position": [
        1632,
        336
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "57329d9c-43d5-41f1-b409-b4801cedc63f",
      "name": "Updating New Tasks on Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1856,
        336
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "8f82c52b-13da-4556-aa62-92a2fc668a5f",
      "name": "Qualifying Leads",
      "type": "n8n-nodes-base.if",
      "position": [
        544,
        352
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1cbc990f-2279-4682-a0d8-70405d19eab0",
      "name": "Getting New Tasks",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        320,
        352
      ],
      "parameters": {},
      "typeVersion": 4
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "ffd4e55b-68d1-427b-9c9e-c3910e74cf9f",
  "connections": {
    "Basic LLM Chain": {
      "main": [
        [
          {
            "node": "Restructuring AI Output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Every 5 Minutes": {
      "main": [
        [
          {
            "node": "Getting New Tasks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Qualifying Leads": {
      "main": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Getting New Tasks": {
      "main": [
        [
          {
            "node": "Qualifying Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Restructuring AI Output": {
      "main": [
        [
          {
            "node": "Creating and Assigning Tasks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Creating and Assigning Tasks": {
      "main": [
        [
          {
            "node": "Restructuring ClickUp Output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Restructuring ClickUp Output": {
      "main": [
        [
          {
            "node": "Updating New Tasks on Sheets",
            "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

Description

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

⚠️ DISCLAIMER: This workflow uses the AnySite LinkedIn community node, which is only available on self-hosted n8n instances. It will not work on n8n.cloud.

OpenAI Chat, Output Parser Structured, Google Sheets +6
AI & RAG

This workflow automates the creation, rendering, approval, and posting of TikTok-style POV (Point of View) videos to Instagram, with cross-posting to Facebook and YouTube. It eliminates manual video p

OpenAI Chat, Output Parser Item List, HTTP Request +10
AI & RAG

YOUTUBE GUIDE 📣 This template generates up to 2,000 AI-based stock images per day for under $4. It includes prompt generation, image creation, metadata enrichment, upload to Google Drive, and error lo

Google Sheets, HTTP Request, Google Drive +6
AI & RAG

Viral videos POV By Juan Pe Navarro. Uses googleSheets, outputParserItemList, httpRequest, googleDrive. Scheduled trigger; 48 nodes.

Google Sheets, Output Parser Item List, HTTP Request +4
AI & RAG

Most blogs publish words. This system publishes experiences.

OpenAI Chat, HTTP Request, Output Parser Structured +7