A ready-to-use AI chatbot automation workflow built for Shopify app developers and SaaS founders. It connects your app’s customer queries with an intelligent response pipeline using n8n, Gmail, PostgreSQL, and Tawk escalation — exactly like the Invento setup you built.

It’s designed to reduce support load by 70–80%, auto-handle FAQs, trigger escalation emails, and log transcripts for training your AI later.

Stop handling repetitive support tickets manually!
The AI Support Agent Workflow is a complete automation pipeline that connects your app’s user chats to AI-powered responses — just like the system powering customer support.

This plug-and-play n8n workflow can respond to queries, send escalation emails when needed, and log conversations for human review — all in one place.

This is a fully structured n8n workflow that powers the Invento AI Support Agent.
It’s designed for app builders, Shopify developers, and automation engineers who want to create a Retrieval-Augmented AI chat agent using Google Drive + PostgreSQL + OpenAI.

Gmail Escalation With Chat History

⚙️ STEPS TO USE IT

🪜 1. Import the Workflow

1. Open your n8n instance (Cloud or Self-Hosted).
2. Click “Import Workflow” → “Upload File”.
3. Select AI Agent N8N.json.
4. Save it — the flow will appear in your workspace as Invento AI Support Agent (RAG).

🧠 2. Reconnect Credentials

After import, reconnect these under Credentials Manager:

Service Required For Type Notes OpenAI API Language model + embeddings openAiApi Use your own API key PostgreSQL / Neon DB Chat memory + vector store postgres Connect to your own DB Google Drive API File ingestion trigger googleDriveOAuth2Api Required for folder watch Gmail API Escalation emails gmailOAuth2 Optional if you skip email flow

✅ The workflow won’t run until all four are connected.

📚 3. Set Up Your Environment

• Database:
  Make sure your PostgreSQL has the following tables:
  • documents_pg (for embeddings)
  • n8n_chat_histories (for session chat logs)
• Drive Folder Setup:
  Link your Google Drive folder (your knowledge base) to the “File Created / File Updated” triggers.
• Webhook URL:
  Copy the URL from the “When Chat Message Received” trigger and use it in your frontend, chatbot, or Tawk integration.

💬 4. Test the Flow

1. Add a new file (like a .txt or .docx) to your connected Google Drive folder.
2. The workflow should trigger automatically, process the text, chunk it, and update your vector DB.
3. Send a test chat message through the webhook — your AI agent should respond using RAG logic.

🧾 5. Review Sticky Notes Inside n8n

You’ll find these visual guides in your imported workflow:

• 🟨 Overview: High-level purpose & design
• 🟩 Core Components: Lists all nodes (AI, Gmail, Drive, DB)
• 🟦 Safety Notice: Reminder to reconnect credentials manually

🚀 6. Optional Extensions

You can easily extend this setup:

• Add Telegram / WhatsApp / Slack triggers for multi-channel support
• Connect Whisper or Google Speech for voice-to-text notes
• Replace PostgreSQL with Pinecone, Supabase, or Qdrant if you prefer managed vector DBs

The included RAG prompt already includes privacy and escalation guardrails.