Robert Breen This workflow corresponds to n8n.io template #6333 — we link there as the canonical source.
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 →
{
"nodes": [
{
"id": "3282f715-dba9-4078-93fd-a168340d2274",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2280,
2560
],
"parameters": {
"width": 1720,
"height": 860,
"content": ""
},
"typeVersion": 1
},
{
"id": "d9e29f8b-982b-4dcb-b4ab-e73d3fdf20aa",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2280,
2420
],
"parameters": {
"color": 5,
"width": 1720,
"height": 120,
"content": "## Email Unsubscribe Handler for Outlook \n\n** Feel free to contact me if you need help implementing (rbreen@ynteractive.com) **"
},
"typeVersion": 1
},
{
"id": "7b151f06-fbe0-4103-a8cd-acd441086ad0",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3100,
2420
],
"parameters": {
"width": 780,
"height": 1000,
"content": "## How to Implement This n8n Workflow\n\nFollow these steps to configure and deploy the workflow:\n\n1. Connect Your Outlook Account\nIn n8n, go to Credentials > Microsoft Outlook OAuth2.\n\nLog in with the Outlook account that receives replies from your leads.\n\nAssign this credential to the Outlook node that fetches emails.\n\n2. Set Up Google BigQuery\nGo to \ud83d\udc49 https://console.cloud.google.com/\n\nCreate or select a project.\n\nSet up two tables in BigQuery:\n\nunsubscribes (should include at minimum: email, timestamp)\n\nleads (ensure it includes email as a field so you can match and delete)\n\nIn n8n, go to Credentials > Google BigQuery OAuth2 and add your credentials.\n\nAssign this credential to all BigQuery nodes in the workflow.\n\n3. Schedule the Workflow\nUse an Interval node or Cron trigger.\n\nSet it to run every 4 hours (or adjust to your preferred frequency).\n\n\u2705 You\u2019re All Set!\nEvery time the workflow runs:\n\nIt pulls the last 7 days of email replies from Outlook.\n\nFilters messages that include \"unsubscribe\" (case-insensitive).\n\nSaves the email address to your BigQuery unsubscribes table.\n\nDeletes that email from your BigQuery leads table.\n\n\n"
},
"typeVersion": 1
},
{
"id": "737b8659-c432-4541-be15-6875136ac804",
"name": "Loop Over Items1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1100,
2900
],
"parameters": {
"options": {},
"batchSize": "=1"
},
"typeVersion": 3
},
{
"id": "e93b95e9-b476-4bc9-af5f-f606b2ec1efa",
"name": "Summarize",
"type": "n8n-nodes-base.summarize",
"position": [
-960,
2640
],
"parameters": {
"options": {},
"fieldsToSummarize": {
"values": [
{
"field": "1"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "746f69f6-1180-4bbc-ada5-5e797ce75527",
"name": "Edit Fields",
"type": "n8n-nodes-base.set",
"position": [
-1580,
2600
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "e67355be-e522-4b1f-948e-0d4a68cc4092",
"name": "email",
"type": "string",
"value": "={{ $('Filter for Unsubscribes').item.json.sender.emailAddress.address }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "29eb258f-2c62-47a8-a79e-17f9c4b02818",
"name": "Edit Fields1",
"type": "n8n-nodes-base.set",
"position": [
-1580,
2920
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "22d29a78-ada2-41c4-915f-ece2da260703",
"name": "queryemail",
"type": "string",
"value": "={{ $json.email }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "6831435f-b8f2-4c09-8d89-e6fca412da83",
"name": "Run Ever 4 Hours",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-2240,
2920
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 4
}
]
}
},
"typeVersion": 1.2
},
{
"id": "0d20cc6c-0a1e-4d1b-aee8-0700fcb8e164",
"name": "Query Bigquery for all Unsubscribes",
"type": "n8n-nodes-base.googleBigQuery",
"position": [
-1960,
3020
],
"parameters": {
"options": {},
"sqlQuery": "SELECT * FROM `n8nautomation-453001.email_leads_schema.Unsubscribes` ",
"projectId": {
"__rl": true,
"mode": "list",
"value": "n8nautomation-453001",
"cachedResultUrl": "https://console.cloud.google.com/bigquery?project=n8nautomation-453001",
"cachedResultName": "n8nAutomation"
}
},
"credentials": {
"googleBigQueryOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 2.1,
"alwaysOutputData": true
},
{
"id": "ad0f0314-caf8-48a6-9854-a537ab929515",
"name": "Today & 7 Days Ago",
"type": "n8n-nodes-base.code",
"position": [
-2020,
2780
],
"parameters": {
"jsCode": "const pad = (n, width = 2) => String(n).padStart(width, '0');\n\nconst formatDate = (date) => {\n const offsetMinutes = date.getTimezoneOffset();\n const sign = offsetMinutes <= 0 ? '+' : '-';\n const absOffset = Math.abs(offsetMinutes);\n const offsetHours = pad(Math.floor(absOffset / 60));\n const offsetMins = pad(absOffset % 60);\n const timezone = `${sign}${offsetHours}:${offsetMins}`;\n\n return `${date.getFullYear()}-${pad(date.getMonth() + 1)}-${pad(date.getDate())}T${pad(date.getHours())}:${pad(date.getMinutes())}:${pad(date.getSeconds())}.0000000${timezone}`;\n};\n\nconst now = new Date();\nconst sevenDaysAgo = new Date(now);\nsevenDaysAgo.setDate(now.getDate() - 5);\n\nreturn [\n {\n json: {\n now: formatDate(now),\n sevenDaysAgo: formatDate(sevenDaysAgo),\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "633e7061-39f9-4b30-95e1-137eb7e9e9ec",
"name": "Get Emails in Past 7 Days",
"type": "n8n-nodes-base.microsoftOutlook",
"position": [
-1840,
2620
],
"parameters": {
"fields": [
"body",
"createdDateTime",
"from",
"sender"
],
"output": "fields",
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "AQMkADZhNTY3Y2E5LTU4NmMtNGMwNy04MTJiLThkNjkyMzJhMmNkNQAuAAADXiC9rHEGmkKKceK-YOUR_AWS_SECRET_KEY_HERE",
"cachedResultUrl": "https://outlook.office365.com/mail/AQMkADZhNTY3Y2E5LTU4NmMtNGMwNy04MTJiLThkNjkyMzJhMmNkNQAuAAADXiC9rHEGmkKKceK%2FQpabwAEAw3C9jVjaFUip7UVu8fMd2gAAAgEMAAAA",
"cachedResultName": "Inbox"
},
"resource": "folderMessage",
"filtersUI": {
"values": {
"filters": {
"receivedAfter": "={{ $json.sevenDaysAgo }}",
"receivedBefore": "={{ $json.now }}"
}
}
},
"returnAll": true
},
"credentials": {
"microsoftOutlookOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 2
},
{
"id": "8af28462-0892-40c4-8cf5-09c1e1fe31d7",
"name": "Filter for Unsubscribes",
"type": "n8n-nodes-base.filter",
"position": [
-1700,
2800
],
"parameters": {
"options": {
"ignoreCase": true
},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "5a99230c-6b9a-499b-8973-62d0c6daea37",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.body.content }}",
"rightValue": "unsubscribe"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "0b2e4262-5718-4c6f-b1a4-6884e385e277",
"name": "Keep Only New Unsubs",
"type": "n8n-nodes-base.merge",
"position": [
-1400,
2700
],
"parameters": {
"mode": "combine",
"options": {},
"advanced": true,
"joinMode": "keepNonMatches",
"mergeByFields": {
"values": [
{
"field1": "=email",
"field2": "queryemail"
}
]
},
"outputDataFrom": "input1"
},
"typeVersion": 3.1
},
{
"id": "8fc0c4ef-6e1b-4626-ae2f-2c6911a30970",
"name": "Aggregate to email level",
"type": "n8n-nodes-base.summarize",
"position": [
-1240,
2580
],
"parameters": {
"options": {},
"fieldsToSplitBy": "email",
"fieldsToSummarize": {
"values": [
{
"field": "1"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "f79c5b11-a65d-4dd6-a07c-7910f03fb6d9",
"name": "Add unsubscribes to Table",
"type": "n8n-nodes-base.googleBigQuery",
"position": [
-800,
3060
],
"parameters": {
"options": {},
"sqlQuery": " MERGE INTO `n8nautomation-453001.email_leads_schema.Unsubscribes` AS target\nUSING (\n SELECT '{{ $json.email }}' AS email\n) AS source\nON target.email = source.email\nWHEN NOT MATCHED THEN\n INSERT(email) VALUES(source.email);",
"projectId": {
"__rl": true,
"mode": "list",
"value": "n8nautomation-453001",
"cachedResultUrl": "https://console.cloud.google.com/bigquery?project=n8nautomation-453001",
"cachedResultName": "n8nAutomation"
}
},
"credentials": {
"googleBigQueryOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 2.1,
"alwaysOutputData": true
}
],
"connections": {
"Summarize": {
"main": [
[]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Keep Only New Unsubs",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Keep Only New Unsubs",
"type": "main",
"index": 1
}
]
]
},
"Loop Over Items1": {
"main": [
[
{
"node": "Summarize",
"type": "main",
"index": 0
}
],
[
{
"node": "Add unsubscribes to Table",
"type": "main",
"index": 0
}
]
]
},
"Run Ever 4 Hours": {
"main": [
[
{
"node": "Today & 7 Days Ago",
"type": "main",
"index": 0
},
{
"node": "Query Bigquery for all Unsubscribes",
"type": "main",
"index": 0
}
]
]
},
"Today & 7 Days Ago": {
"main": [
[
{
"node": "Get Emails in Past 7 Days",
"type": "main",
"index": 0
}
]
]
},
"Keep Only New Unsubs": {
"main": [
[
{
"node": "Aggregate to email level",
"type": "main",
"index": 0
}
]
]
},
"Filter for Unsubscribes": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Aggregate to email level": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Add unsubscribes to Table": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Get Emails in Past 7 Days": {
"main": [
[
{
"node": "Filter for Unsubscribes",
"type": "main",
"index": 0
}
]
]
},
"Query Bigquery for all Unsubscribes": {
"main": [
[
{
"node": "Edit Fields1",
"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.
googleBigQueryOAuth2ApimicrosoftOutlookOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This n8n workflow automatically scans recent email replies from your Outlook inbox and identifies unsubscribe requests. If a contact replies with any variation of "unsubscribe" within the past 7 days, the system performs two key actions:
Source: https://n8n.io/workflows/6333/ — 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 automates the backup of your self-hosted n8n instance by exporting all workflows and saving them as individual files to a designated OneDrive folder. Each file is timestamped for easy ve
n8n, Microsoft One Drive, Microsoft Outlook
Synchronize OKRs (Objectives and Key Results) between Monday.com and Jira to automatically calculate progress variance, update dashboards, and share variance reports via Slack and Outlook. This workfl
Monday.com, Jira, Slack +1
Generate Weekly n8n Execution Report and Email Summary Automatically runs every 7 days to pull all n8n workflow executions from the past week Merges execution data with workflow information to provide
n8n, Gmail, Microsoft Outlook
This workflow automatically connects to the Square API and generates a monthly sales summary report for all your Square locations. The report matches the figures displayed in Square Dashboard > Rep
HTTP Request, Microsoft Outlook
This workflow automatically connects to the Square API and generates a weekly sales summary report for all your Square locations. The report matches the figures displayed in Square Dashboard > Repo
HTTP Request, Microsoft Outlook