Email to Notion KB: IMAP, Postgres Dedup & Telegram Alert

This workflow triggers on unseen emails using IMAP (e.g., Gmail, Outlook), extracts and cleans HTML bodies into plain text, and normalizes key fields like title, slug, snippet, date, sender, and URL. It then checks for duplicates in a Postgres database using message ID, preventing redundant entries.

If unique, it creates a new page in your Notion database with mapped properties for seamless knowledge base growth. Finally, a Telegram notification confirms successful processing, keeping you informed without manual checks.

Benefits include effortless inbox triage, duplicate-free archiving, and centralized knowledge management. Perfect for e-commerce order processing, customer support logs, or any email-heavy workflow. Saves hours on manual data entry and organization.

Prerequisites: IMAP credentials, Notion integration token & database ID, Postgres connection, Telegram bot token & chat ID. Highly customizable for various email providers and Notion schemas.