Routine emails answered automatically from your own answer base
The scenario reads incoming mail, filters out spam, pulls up the conversation history, and replies from your templates and answer base — forwarding everything else to a human.
It answers only what's actually in your base — no inventing
Spam is filtered out before anything gets replied to
The thread history is pulled up, so the reply accounts for earlier emails
Anything the assistant doesn't know goes to a human — nothing is dropped
MailjetPostgresWebflowEmbeddings OpenAISupabase Vector StoreDefault Data LoaderForward
Automating Mailjet and Postgres takes no code: a ready-made scenario does the routine for you.
Starts when: Microsoft Outlook Trigger
Check: Loop Over Items1
Then: Clean HTML
Then: Retrieve Categories
Then: Aggregate1
Then: Categorize
Check: Spam Filter
If yes: Conversation Retrieval
Then: Format
Then: Email Manager
Check: Forward?
If yes: Reply1
Then: Outlook Forward
Then: Execute Workflow
If no: Reply
Then: Embeddings OpenAI1
Then: Embeddings OpenAI2
Then: JSON
Then: 4o
Then: Email Template DB
Then: FAQ DB
Starts when: When Executed by Another Workflow
Then: Supabase Vector Store4
Then: Update a row2
Then: Embeddings OpenAI6
Then: Default Data Loader3
Then: Recursive Character Text Splitter3
You can launch this Mailjet + Postgres integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.