Email to Notion knowledge base with IMAP, Postgres dedup and Telegram alert
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 noti...
Template notes
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 → plain text.
Normalization: title, snippet, bodyText, slug, messageId, sentAt, fromAddress, sourceUrl.
Deduplication via Postgres (SELECT EXISTS).
Create page in Notion database (property mapping).
Telegram success notification.