Automatic email unsubscribe handler: Outlook to BigQuery integration
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 workflow has 12 nodes and runs on a schedule (every 4 hours). Along the way it connects Google BigQuery and Microsoft Outlook.
How it runs
Trigger: On a schedule (every 4 hours).
- Today & 7 Days Ago (Code): runs custom JavaScript code
- Query Bigquery for all Unsubscribes (Google BigQuery): uses Google BigQuery
- Get Emails in Past 7 Days (Microsoft Outlook): work with folder message
- Edit Fields (Edit Fields (Set)): sets 1 field: queryemail
- Filter: keeps only the items that match a condition
- Keep Only New Unsubs (Merge): merges the data from its input branches
- Edit Fields (Edit Fields (Set)): sets 1 field: email
- Aggregate to email level (Summarize): summarizes / groups the items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Summarize: summarizes / groups the items
…plus 1 more step. 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 (9)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Summarize
n8n-nodes-base.summarize - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google BigQuery
n8n-nodes-base.googleBigQuery - Code
n8n-nodes-base.code - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Filter
n8n-nodes-base.filter - Merge
n8n-nodes-base.merge
From the author
🚫 Email Unsubscribe Handler for Outlook Description 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…