π± Automatic email unsubscribe handler: Outlook to BigQuery integration
β‘ 793 views Β· π± Social Media & Email Marketing
Description
π« 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 system performs two key actions:
Saves the contactβs email address in a BigQuery unsubscribes table (for compliance and tracking).
Deletes that contact from the active leads table in BigQuery (to stop future outreach).
This flow can be triggered on a schedule (e.g. every 4 hours) or run manually as needed.
Key Features
π₯ Email Parsing from Outlook: Automatically monitors for replies that contain unsubscribe language.
π§ Smart Filtering: Captures unsubscribes based on message content, not just subject lines.
π BigQuery Integration: Logs unsubscribed emails and removes them from your leads dataset.
π€ Connect with Me
Description
Iβm Robert Breen, founder of Ynteractive β a consulting firm that helps businesses automate operations using n8n, AI agents, and custom workflows. Iβve helped clients build everything from intelligent chatbots to complex sales automations, and Iβm always excited to collaborate or support new projects.
If you found this workflow helpful or want to talk through an idea, Iβd love to hear from you.
Links
π Website: https://www.ynteractive.com
πΊ YouTube: @ynteractivetraining
πΌ LinkedIn: https://www.linkedin.com/in/robert-breen
π¬ Email: rbreen@ynteractive.com
π Nodes Used
Microsoft Outlook, Google BigQuery, Schedule Trigger, Filter, Summarize
π₯ Import
Download workflow.json and import into n8n:
Workflow menu β Import from File