Triage and route tasks with Google Sheets, GPT-4o-mini, Gmail, Slack, and Google Tasks
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 18 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Google Sheets, Google Tasks, Slack and OpenAI and 1 more.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Validate and Format Task Data (Code): runs custom JavaScript code
- Fetch Pending Tasks from Sheet (Google Sheets): uses Google Sheets
- Is Task Valid? (If): checks a condition and branches into true / false
- Prepare Task Data for Prioritization (Code): runs custom JavaScript code
- Edit The data For Sheet (Edit Fields (Set)): sets 4 fields: category, dueDate, status…
- Reject Invalid Task (Stop and Error): stops the run with an error
- Sort: sorts the items
- Save Task to Google Sheets (Google Sheets): append
- Is Task High Priority? (If): checks a condition and branches into true / false
- Send Success Response (Respond to Webhook): sends the response back to the webhook caller
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Respond to Webhook
n8n-nodes-base.respondToWebhook - Stop and Error
n8n-nodes-base.stopAndError - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Sort
n8n-nodes-base.sort - Google Tasks
n8n-nodes-base.googleTasks - Slack
n8n-nodes-base.slack - OpenAI
@n8n/n8n-nodes-langchain.openAi - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick Overview This workflow collects tasks via a webhook, stores validated tasks in Google Sheets, and runs a daily prioritization routine that creates urgent items in Google Tasks with Slack alerts while summarizing medium/low tasks with OpenAI and emailing…