Email to Notion knowledge base with IMAP, Postgres dedup and Telegram alert
Ready for 3.0What this workflow does
This workflow has 24 nodes and runs when a new email arrives over IMAP (plus 3 other triggers). Along the way it connects Postgres, Notion and Telegram.
How it runs
Trigger: When a new email arrives over IMAP (plus 3 other triggers).
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- Execute a SQL query (Postgres): run a query
- Execute a SQL query (Postgres): run a query
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- Create a database page (Notion): work with database page
- Create a database page (Notion): work with database page
- Send a text message (Telegram): uses Telegram
- Send a text message (Telegram): uses Telegram
…plus 10 more steps. 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 (6)
- Email Trigger (IMAP)
n8n-nodes-base.emailReadImap - Code
n8n-nodes-base.code - Postgres
n8n-nodes-base.postgres - If
n8n-nodes-base.if - Notion
n8n-nodes-base.notion - Telegram
n8n-nodes-base.telegram
From the author
Filter incoming emails via IMAP, extract & clean the body into plain text, normalize (title/slug/snippet/date/from/url), check for duplicates in Postgres, store as a row in a Notion database, then send a Telegram notification. Perfect for building a knowledge…