Email to Notion Knowledge Base with IMAP, Postgres Dedup, and Telegram Alert
Please correct the following description: 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 base or inbox triage automation without duplicate noise. **Key Features** - IMAP polling (Only UNSEEN). - Extract & clean HTML to plain text. - Normalization: title, snippet, body text, slug, messageId, sentAt, fromAddress, sourceUrl. - Deduplication via Postgres (SELECT EXISTS). - Create page in Notion database (property mapping). - Telegram success notification. - Tags: email, imap, notion, postgres, deduplication, telegram, automation, knowledge-base **Prerequisites** - IMAP access (Gmail/Outlook/Custom). - Gmail: enable IMAP + App Password if using 2FA. - Notion Integration Token & Database ID (database must be shared with the integration). - PostgreSQL accessible from n8n. - (Optional) Telegram Bot Token & Chat ID.
- Platform
- n8n
- Category
- Communication
- Price
- $14.99
- Creator
- Ariyanto Catur Pamungkas
- if
- code
- notion
- postgres
- telegram
- stickyNote
- emailReadImap
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Communication workflows
- Automate Outbound Calls with Ultravox AI and Twilio$4.99
- Automate Intelligent Email Classification with AI in Gmail$4.99
- Generate AI videos and carousels with Blotato for Instagram and TikTok$9.99
- Automating WhatsApp Replies Using GoHighLevel with Redis and Anthropic$24.99
- Automate Gmail Email Labeling with AI for Enhanced Organization$14.99
- Automate Email Summarization and Logging with AI and Google Sheets$9.99
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.