Email data extraction and vector embedding storage in PostgreSQL

• Automate email data extraction from Gmail to a database
• Transform email content into vector embeddings for advanced search
• Store structured email metadata for reporting and analysis
• Facilitate bulk email imports for data analysis and processing

Triggers on new emails received in Gmail Extracts relevant fields from the email content Processes email text into vector embeddings using Ollama Stores structured metadata and embeddings in PostgreSQL Handles bulk email imports efficiently

1. 1
   Import the workflow template into n8n
2. 2
   Configure Gmail credentials for email access
3. 3
   Set the Gmail account creation date in the code node
4. 4
   Run the workflow to create the necessary PostgreSQL tables
5. 5
   Activate the workflow to start processing incoming emails