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.
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.
New buyers can create an account from the cart to unlock a controlled $10 first-purchase credit on eligible orders of $25+.
Related bundle
Customer Support Automation Suite
8 hand-picked workflows for $39.00.
That is $4.88 each, vs $14.99 for this one alone.
View bundleSecure checkout powered by Stripe
Support
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.