Rahul Joshi This workflow corresponds to n8n.io template #9228 — we link there as the canonical source.
This workflow follows the Gmail → 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 →
{
"id": "AjxolVhM49WYCeRP",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Payment Pending Automation - ClickUp Integration",
"tags": [],
"nodes": [
{
"id": "236c90c5-3595-47b5-9bf2-7e7766676448",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1456,
176
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8e57d952-3ec9-4057-8483-a428df6598d2",
"name": "Fetch Lead Data from Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1232,
176
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1810805257,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19Uq4JB_oKG1s-0S6kKNwJtGWBRXVtpwo9DDCM0Hlg5I/edit#gid=1810805257",
"cachedResultName": "Sheet2"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "19Uq4JB_oKG1s-0S6kKNwJtGWBRXVtpwo9DDCM0Hlg5I",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/19Uq4JB_oKG1s-0S6kKNwJtGWBRXVtpwo9DDCM0Hlg5I/edit?usp=drivesdk",
"cachedResultName": "GHL form submission (Responses)"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.7
},
{
"id": "0f136a95-2d90-403b-bd4a-841ba94e1428",
"name": "Check if Status is Open",
"type": "n8n-nodes-base.if",
"position": [
-1008,
176
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "5e5dda7c-e7e5-45bd-8ef9-cb5715ba23f2",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json[\"Status \"] }}",
"rightValue": "Open"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "d99cde05-65db-4582-a8ea-f5aa83843c2d",
"name": "Send Slack Notification (Status Not Open)",
"type": "n8n-nodes-base.slack",
"position": [
-784,
272
],
"parameters": {
"text": "=Lead: {{ $json[\"Lead Name\"] }}'s Payment Verfication is :{{ $json[\"Payement verification\"] }}",
"user": {
"__rl": true,
"mode": "list",
"value": "U09E375JZPA",
"cachedResultName": "n8n_workspace"
},
"select": "user",
"otherOptions": {}
},
"credentials": {
"slackApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.3
},
{
"id": "8cc8639f-3d31-4694-be81-b8ddc2812304",
"name": "Create ClickUp Task for Payment Verification",
"type": "n8n-nodes-base.clickUp",
"position": [
-784,
80
],
"parameters": {
"list": "901611225386",
"name": "={{ $json[\"Lead Name\"] }} {{ $json[\"Company Name\"] }} Payment verfication is {{ $json[\"Payement verification\"] }}",
"team": "90161261705",
"space": "90165174252",
"folderless": true,
"additionalFields": {}
},
"credentials": {
"clickUpApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "0f880546-766b-4e42-9e50-dba597a6196b",
"name": "Send Email Confirmation to Task Watcher",
"type": "n8n-nodes-base.gmail",
"position": [
-560,
80
],
"parameters": {
"sendTo": "={{ $json.watchers[0].email }}",
"message": "=Clickup Task is created with id:{{ $json.id }}. Please check",
"options": {},
"subject": "={{ $json.name }}",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "c54a5c22-56a7-4c97-97df-773990617a5d",
"name": "Sticky Note - Workflow Start",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1648,
-80
],
"parameters": {
"color": 4,
"width": 293.0894308943089,
"height": 229.73441734417344,
"content": "## \ud83d\ude80 Workflow Start\n\nThis workflow is triggered manually by clicking the 'Execute Workflow' button.\n\nUse this when you want to process payment verification data from the Google Sheet."
},
"typeVersion": 1
},
{
"id": "ba1c9640-f01f-4536-910b-f96b32369bdf",
"name": "Sticky Note - Google Sheets",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
336
],
"parameters": {
"color": 5,
"width": 322.734375,
"height": 368.6718750000001,
"content": "## \ud83d\udcca Fetch Lead Data\n\n**Purpose:** Retrieves all rows from Google Sheets containing lead information\n\n**Sheet:** GHL form submission (Responses)\n\n**Data Retrieved:**\n- Lead Name\n- Company Name\n- Payment Verification Status\n- Status (Open/Closed)\n\nThis node pulls all pending payment verifications that need to be processed."
},
"typeVersion": 1
},
{
"id": "798c619c-b3ef-4567-ac2f-7f81deb6615a",
"name": "Sticky Note - Condition Check",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1232,
-224
],
"parameters": {
"color": 6,
"width": 322.734375,
"height": 380.02343750000006,
"content": "## \u2705 Status Filter\n\n**Condition:** Checks if Status = \"Open\"\n\n**True Path (Status = Open):**\n\u2192 Creates ClickUp task\n\u2192 Sends email confirmation\n\n**False Path (Status \u2260 Open):**\n\u2192 Sends Slack notification only\n\nThis ensures we only create tasks for active/open payment verifications."
},
"typeVersion": 1
},
{
"id": "38bdcc63-85a3-4e36-a3c3-0cb91b4b6987",
"name": "Sticky Note - Email",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
48
],
"parameters": {
"color": 5,
"width": 293.0894308943089,
"height": 335.00000000000006,
"content": "## \u2709\ufe0f Email Notification\n\n**Purpose:** Sends confirmation email after task creation\n\n**Recipient:** First watcher of the ClickUp task\n\n**Content:**\n- Task name\n- Task ID\n- Link to verify the task\n\nThis keeps stakeholders informed about new payment verification tasks."
},
"typeVersion": 1
},
{
"id": "8bdefd3a-4a00-4807-8812-18998de3f710",
"name": "Sticky Note - ClickUp",
"type": "n8n-nodes-base.stickyNote",
"position": [
-816,
-352
],
"parameters": {
"color": 7,
"width": 293.0894308943089,
"height": 403.75,
"content": "## \ud83d\udccb Create ClickUp Task\n\n**Purpose:** Creates a task in ClickUp for payment verification follow-up\n\n**Task Details:**\n- Team: Payment Team\n- Space: Payment Processing\n- List: Payment Verifications\n\n**Task Name Format:**\n[Lead Name] [Company Name] Payment verification is [Status]\n\nThis centralizes all payment verification tasks in one place for the team."
},
"typeVersion": 1
},
{
"id": "7963a0c9-b2f0-4364-a7d1-81f0530f4e39",
"name": "Sticky Note - Slack",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
448
],
"parameters": {
"color": 3,
"width": 293.0894308943089,
"height": 335.00000000000006,
"content": "## \ud83d\udcac Slack Alert\n\n**Purpose:** Notifies team via Slack when status is NOT open\n\n**Channel:** n8n_workspace\n\n**Message Format:**\nLead: [Lead Name]'s Payment Verification is: [Status]\n\nThis is a fallback notification for non-open statuses that don't require task creation."
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "0d6c906d-0058-4452-9ce6-1bacd6724f60",
"connections": {
"Check if Status is Open": {
"main": [
[
{
"node": "Create ClickUp Task for Payment Verification",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Slack Notification (Status Not Open)",
"type": "main",
"index": 0
}
]
]
},
"Fetch Lead Data from Google Sheets": {
"main": [
[
{
"node": "Check if Status is Open",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Fetch Lead Data from Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Create ClickUp Task for Payment Verification": {
"main": [
[
{
"node": "Send Email Confirmation to Task Watcher",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
clickUpApigmailOAuth2googleSheetsOAuth2ApislackApi
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 tracking and follow-up process for pending payments. It pulls lead payment data from Google Sheets, checks whether the status is “Open,” and then routes actions accordingly. For open payment cases, it creates a dedicated ClickUp task and sends an…
Source: https://n8n.io/workflows/9228/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
📘 Description
HTTP Request, Gmail Trigger, ClickUp +3
This workflow automatically detects bounced or invalid email addresses from your Gmail inbox and updates their status in Google Sheets. It fetches bounce notifications, extracts failed email addresses
Google Sheets, Slack, Gmail
This n8n workflow automates the candidate shortlisting process by integrating Google Sheets, Gmail, ClickUp, and Calendly. It fetches candidate records, filters high-scoring profiles, sends personaliz
Google Sheets, Gmail, ClickUp
How it works Receives form submissions via a webhook endpoint. Extracts the name, email, and message from each submission. Logs every submission to a Google Sheets spreadsheet with a timestamp. Sends
Typeform Trigger, Google Sheets, Gmail +1
This workflow automatically detects when a new product is created in WooCommerce and instantly notifies internal teams through Slack and email. At the same time, it logs all product details into Googl
Woo Commerce Trigger, Slack, Gmail +1