Workflows / AI Assistants & Agents / Knowledge-base chatbots (RAG)
Gmail to searchable vector database (PGVector)
Starts when a new email arrives and works with Gmail, PostgreSQL, PGVector.
Main steps
- Recursive Character Text Splitter
- Gmail Trigger
- Was manually triggered?
- Set before and after dates
- Extract email fields
- Store structured
What you get
workflow.json– import into n8n (16 steps, starts from a new email)- README setup guide and an in-workflow setup note
You need
- n8n (Cloud or self-hosted)
- Gmail account
- PostgreSQL account
- PGVector account