Lead qualification & auto-assignment with GPT-4 Mini: Google Sheets to ClickUp
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Cron. 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs on a schedule (legacy Cron node). Along the way it connects OpenAI Chat Model, ClickUp and Google Sheets.
How it runs
Trigger: On a schedule (legacy Cron node).
- Getting New Tasks (Google Sheets): uses Google Sheets
- Qualifying Leads (If): checks a condition and branches into true / false
- Basic LLM Chain: sends a prompt to an LLM, with model: OpenAI Chat Model
- Restructuring AI Output (Code): runs custom JavaScript code
- Creating and Assigning Tasks (ClickUp): uses ClickUp
- Restructuring ClickUp Output (Code): runs custom JavaScript code
- Updating New Tasks on Sheets (Google Sheets): uses Google Sheets
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Every 5 Minutes: replace with Schedule Trigger.
| Removed in 3.0 | Replace with |
|---|---|
| Cron Every 5 Minutes | Schedule Trigger |
Nodes used (7)
- Cron
n8n-nodes-base.cron - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code
n8n-nodes-base.code - ClickUp
n8n-nodes-base.clickUp - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if
From the author
Description Eliminate confusion in sales hand-offs with this ClickUp Task Assignment & Ownership automation! This workflow automatically creates and assigns ClickUp tasks whenever a lead’s status changes to “Qualified” or “Hot,” ensuring seamless ownership…