Avkash Kakdiya This workflow corresponds to n8n.io template #9096 — we link there as the canonical source.
This workflow follows the Gmail → HTTP Request 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 →
{
"meta": {
"templateCredsSetupCompleted": false
},
"name": "Cold Deal Closure Workflow",
"tags": [],
"nodes": [
{
"id": "99a95283-6245-4d88-ae58-07aaef8ddf14",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-304,
-16
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.1
},
{
"id": "35be2b12-2b12-42ee-aa01-df7c49daf6d4",
"name": "Get HubSpot Deals",
"type": "n8n-nodes-base.hubspot",
"position": [
-80,
-16
],
"parameters": {
"filters": {
"propertiesCollection": {
"propertiesValues": {
"properties": [
"dealname",
"hs_lastmodifieddate",
"notes_last_updated",
"notes_last_contacted"
],
"propertyMode": "valueOnly"
}
}
},
"resource": "deal",
"operation": "getAll",
"returnAll": true,
"authentication": "appToken"
},
"credentials": {
"hubspotAppToken": {
"name": "<your credential>"
}
},
"typeVersion": 2
},
{
"id": "ff92028e-afa9-4ed2-b123-aa2619f612dd",
"name": "Extract Deal Fields",
"type": "n8n-nodes-base.code",
"position": [
144,
-16
],
"parameters": {
"jsCode": "return items.map(item => {\n const props = item.json.properties || {};\n\n return {\n json: {\n dealId: item.json.dealId || '',\n dealname: props.dealname?.value || '',\n lastmodifieddate: props.hs_lastmodifieddate?.value || '',\n notes_last_updated: props.notes_last_updated?.value || '',\n notes_last_contacted: props.notes_last_contacted?.value || ''\n }\n };\n});"
},
"typeVersion": 2
},
{
"id": "5f50f06b-dc6a-45eb-b8b5-17b3f092f7ce",
"name": "Filter Cold Leads (21+ days)",
"type": "n8n-nodes-base.filter",
"position": [
368,
-16
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 1,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1",
"operator": {
"type": "number",
"operation": "lt"
},
"leftValue": "={{ $json.lastmodifieddate.toNumber() }}",
"rightValue": "={{ Date.now() - 21 * 24 * 60 * 60 * 1000 }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "f3e64724-432c-4354-a115-61185fb3d23e",
"name": "Update Deal to Closed Lost",
"type": "n8n-nodes-base.hubspot",
"position": [
592,
-16
],
"parameters": {
"dealId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.dealId }}"
},
"resource": "deal",
"operation": "update",
"updateFields": {
"stage": "closedlost"
},
"authentication": "appToken"
},
"credentials": {
"hubspotAppToken": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "4d51776d-1c40-435a-989f-660f4546b401",
"name": "Fetch Deal Associations",
"type": "n8n-nodes-base.httpRequest",
"position": [
800,
-16
],
"parameters": {
"url": "=https://api.hubapi.com/crm/v3/objects/deals/{{ $json.dealId }}?associations=contacts",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer YOUR_TOKEN_HERE"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "2d48cf93-9066-482b-9c7d-0b317ff99406",
"name": "Extract Contact IDs",
"type": "n8n-nodes-base.code",
"position": [
1008,
-16
],
"parameters": {
"jsCode": "// Extract contact IDs from deals data\nconst dealsData = $input.all();\nconst contactIds = [];\n\ndealsData.forEach(item => {\n const deal = item.json;\n if (deal.associations && deal.associations.contacts && deal.associations.contacts.results) {\n deal.associations.contacts.results.forEach(contact => {\n contactIds.push({\n contactId: contact.id,\n dealId: deal.id,\n dealName: deal.properties.dealname\n });\n });\n }\n});\n\nreturn contactIds;"
},
"typeVersion": 2
},
{
"id": "955cad66-4b5e-45b0-9c82-78f27ed78823",
"name": "Get Contact Details",
"type": "n8n-nodes-base.hubspot",
"position": [
1216,
-16
],
"parameters": {
"contactId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.contactId }}"
},
"operation": "get",
"authentication": "appToken",
"additionalFields": {
"propertiesCollection": {
"propertiesValues": {
"properties": [
"email",
"firstname",
"lastname",
"hs_full_name_or_email"
]
}
}
}
},
"credentials": {
"hubspotAppToken": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "0ef1bd2f-8986-42eb-b09f-3e3c09ed3403",
"name": "Extract Contact Email",
"type": "n8n-nodes-base.code",
"position": [
1424,
-16
],
"parameters": {
"jsCode": "// Code Node (JavaScript)\n\nreturn items.map(item => {\n let email = null;\n\n // try to safely access the email field\n if (item.json?.properties?.email?.value) {\n email = item.json.properties.email.value;\n }\n\n return {\n json: {\n email\n }\n };\n});"
},
"typeVersion": 2
},
{
"id": "ea48344a-33e0-442d-9b15-24708f6376f4",
"name": "Send Gmail Feedback Request",
"type": "n8n-nodes-base.gmail",
"position": [
1648,
-16
],
"parameters": {
"sendTo": "=your-email@example.com",
"message": "=Hi {{ $('Get Contact Details').item.json.properties.firstname.value }},<br><br>\n\nI hope you're doing well.<br><br>\n\nThank you once again for considering [Your Company] for your project. While I understand you've decided to move in a different direction, I truly appreciate the time and effort you spent engaging with us.<br><br>\n\nWe'd Love Your Feedback<br>\nIf you're open to it, I'd be grateful for any thoughts you'd like to share about your decision\u2014anything that could help us improve going forward.<br><br>\n\nOpen Door for the Future<br>\nShould your needs evolve in the future, I'd be happy to reconnect and support you in any way we can.<br><br>\n\nWishing you all the best with your project and continued success ahead.<br><br>\n\nWarm regards,<br><br>\n[Your Company]<br>\n",
"options": {
"appendAttribution": false
},
"subject": "=Thank You \u2014 We'd Value Your Feedback"
},
"credentials": {
"gmailOAuth2": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "da6063b5-6c22-4312-960a-276b9a8a90dd",
"name": "Send Slack Notification",
"type": "n8n-nodes-base.slack",
"position": [
1856,
-16
],
"parameters": {
"text": "=Deals which are moved to Closed Lost: {{ $('Extract Contact IDs').item.json.dealId }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "YOUR_SLACK_CHANNEL_ID",
"cachedResultName": "general"
},
"otherOptions": {},
"authentication": "oAuth2"
},
"credentials": {
"slackOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 2.3
},
{
"id": "00280018-e849-44a3-a90a-e4b41e3d3fb4",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-352,
-336
],
"parameters": {
"color": 4,
"width": 640,
"height": 624,
"content": "## Trigger & Deal Fetching\n\n*Schedule Trigger: Starts the workflow on a defined interval (e.g., daily, weekly).\n\nGet HubSpot Deals: Pulls all deals from HubSpot, retrieving key fields like dealname, hs_lastmodifieddate, notes_last_updated, and notes_last_contacted.\n\nExtract Deal Fields: Cleans up and restructures the deal data into a consistent format (dealId, dealname, timestamps).*"
},
"typeVersion": 1
},
{
"id": "26416831-06bb-45ef-983a-44c74160ae87",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
304,
-336
],
"parameters": {
"color": 2,
"width": 432,
"height": 624,
"content": "## Lead Qualification (Cold Deals)\n\n*Filter Cold Leads (21+ days): Uses lastmodifieddate and compares it against Date.now() - 21 days.\n\nKeeps only deals untouched for 21+ days.\n\nUpdate Deal \u2192 Closed Lost: Automatically updates those stale deals in HubSpot, marking them as Closed Lost.*"
},
"typeVersion": 1
},
{
"id": "9bf5bb30-24d1-4f31-a07b-dd781175e066",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
752,
-336
],
"parameters": {
"color": 6,
"width": 832,
"height": 624,
"content": "## Deal \u2192 Contact Mapping\n\n*Fetch Deal Associations: Calls HubSpot API to get contacts linked to the filtered deals.\n\nExtract Contact IDs: Parses the association response to pull out contactId, dealId, and dealName.\n\nGet Contact Details: Retrieves enriched details of each contact (e.g., email, firstname, lastname).\n\nExtract Contact Email: Simplifies the response, keeping only the email (and ensuring it's safely extracted).*"
},
"typeVersion": 1
},
{
"id": "cedf1213-f134-4ddd-a96c-764d1320193e",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
-336
],
"parameters": {
"color": 3,
"width": 384,
"height": 624,
"content": "## Follow-up & Notifications\n\n*Send Gmail Feedback Request:\n\nSends a polite follow-up email thanking the lead and asking for feedback.\n\nUses personalized fields like firstname in the message.\n\nSend Slack Notification:\n\nPosts a message to a Slack channel (e.g., #general) to alert the team of deals moved to Closed Lost.*"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "TEMPLATE_VERSION_ID",
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Get HubSpot Deals",
"type": "main",
"index": 0
}
]
]
},
"Get HubSpot Deals": {
"main": [
[
{
"node": "Extract Deal Fields",
"type": "main",
"index": 0
}
]
]
},
"Extract Contact IDs": {
"main": [
[
{
"node": "Get Contact Details",
"type": "main",
"index": 0
}
]
]
},
"Extract Deal Fields": {
"main": [
[
{
"node": "Filter Cold Leads (21+ days)",
"type": "main",
"index": 0
}
]
]
},
"Get Contact Details": {
"main": [
[
{
"node": "Extract Contact Email",
"type": "main",
"index": 0
}
]
]
},
"Extract Contact Email": {
"main": [
[
{
"node": "Send Gmail Feedback Request",
"type": "main",
"index": 0
}
]
]
},
"Fetch Deal Associations": {
"main": [
[
{
"node": "Extract Contact IDs",
"type": "main",
"index": 0
}
]
]
},
"Update Deal to Closed Lost": {
"main": [
[
{
"node": "Fetch Deal Associations",
"type": "main",
"index": 0
}
]
]
},
"Send Gmail Feedback Request": {
"main": [
[
{
"node": "Send Slack Notification",
"type": "main",
"index": 0
}
]
]
},
"Filter Cold Leads (21+ days)": {
"main": [
[
{
"node": "Update Deal to Closed Lost",
"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.
gmailOAuth2hubspotAppTokenslackOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow identifies HubSpot deals that have gone untouched for 21+ days and automatically updates their status to Closed Lost. It fetches associated contacts, retrieves their details, and sends personalized follow-up emails requesting feedback. Finally, it notifies your…
Source: https://n8n.io/workflows/9096/ — 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.
This workflow runs on a schedule to monitor HubSpot deals with upcoming contract expiry dates. It filters deals that are 30, 60, or 90 days away from expiration and processes each one individually. Ba
Gmail, HubSpot, HTTP Request +2
This workflow is an automated invoice payment tracking and reminder system for the Polish accounting service iFirma.pl. It monitors unpaid and overdue invoices, then automatically sends escalating rem
HTTP Request, Stop And Error, Slack +1
Following up at the right time is one of the most important parts of sales. This workflow uses Gmail to send outreach emails to Hubspot contacts that have already been contacted only once more than a
Gmail, HubSpot, HTTP Request
This workflow automatically monitors solar energy production every 2 hours by fetching data from the Energidataservice API. If the energy output falls below a predefined threshold, it instantly notifi
HTTP Request, Gmail, Google Sheets +1
Automatically extract structured information from emails using AI-powered document analysis. This workflow processes emails from specified domains, classifies them by type, and extracts structured dat
Gmail, HTTP Request, AWS S3 +1