Automated Email Processing, Deduplication, and Notion Storage

This workflow automates the process of reading emails via IMAP, extracting key information, avoiding duplicates, and storing data in Notion with notifications. It is designed to streamline email management for knowledge base or documentation purposes.

The workflow begins with IMAP email triggers that detect new, unseen emails from designated accounts. These emails are then processed through a Code node that normalizes and extracts relevant information such as the email’s subject, body, sender, and date, converting HTML content to plain text and creating clean slugs and snippets.

Next, a PostgreSQL query checks if the email’s message ID already exists in the email index table, preventing duplicate entries. If the email is new, a Notion page is created with the extracted information, and the email’s details are saved into the index table to prevent reprocessing.

Additionally, a notification is sent via Telegram to inform the user that the email has been successfully stored in Notion. Multiple instances of this workflow are configured for different email accounts, ensuring comprehensive email management across various sources.

This automation is practical for teams managing large volumes of email-based information, such as customer support, research, or knowledge management, allowing efficient tracking, organization, and notification of relevant emails in a centralized system.