Mail-triggered Notion Auto-Importer (Job / Payment / Rule-based Mail To Table

[bedead]

Add a mail-triggered module to Eibox backend that detects certain incoming emails (e.g., job application confirmations, payment receipts), extracts structured fields, and inserts/updates rows in a user-configurable Notion table (or another target). Users must be able to define “rules” (which mails to watch), mapping of extracted fields → table columns, and default status/labels.

Goals / Acceptance Criteria

• 1. When a new email arrives and matches a user rule, the system:
• 2. extracts relevant fields (see examples below),
• 3. creates or updates a row in the user-selected Notion table (or chosen target),
• 4. sets initial metadata (status, source, timestamp) and
• 5. logs the operation (success/failure).
• 6. Users can configure multiple rules with priority order and test them against sample emails.
• 7. The extractor supports both template-based parsing (HTML/text + regex/DOM) and an LLM-assisted fallback for ad-hoc formats.
• 8. All operations respect user privacy — only authorized Notion workspaces are used, tokens stored encrypted, and user can opt-out per rule.
• 9. Provide audit trail and UI list where user can see rule run history and manually re-run extraction.
• 10. Ability to add new rules from app itself.