Classify Gmail emails and process data via AI agent wit

This workflow automates the processing of incoming email requests by classifying content, archiving data in Google Drive, and forwarding it to an AI agent for analysis and response generation. Ideal for businesses aiming to systematize information from emails and chats for analytics or automated communication.

## Who it´s for
- Companies needing to automate handling of incoming email data requests
- Sales managers collecting client information via email
- Analysts looking to integrate an AI agent for working with data from spreadsheets and databases
- CRM administrators requiring classification and archiving of information in cloud storage
- Business owners aiming to build an automated response system based on documentation

## What the automation does
- Triggers on new Gmail messages and classifies them as daily sales, addresses, or customer info
- Extracts data and saves files to corresponding Google Drive folders
- Activates an AI agent (MIS Agent1) using Google Sheets, PostgreSQL, and a calculator for analysis and response generation
- Processes chat messages by analyzing context and retrieving up-to-date data from sheets
- Executes SQL queries to Postgres to fetch structured information
- Pre-loads documents from Google Drive, splits and vectorizes them via OpenAI and Pinecone for RAG-powered search

## What´s included
- Ready-to-use n8n workflow with LangChain agent support
- Trigger logic: new emails, scheduled runs, chat messages, manual execution
- Integrations with Gmail, Google Drive, Google Sheets, PostgreSQL, and Pinecone Vector Store
- Basic textual guide for setup and adaptation

## Requirements for setup
- n8n account with external API access
- Gmail account with API enabled
- Google Drive and Google Sheets accounts with edit permissions
- PostgreSQL database with required tables
- Pinecone account and OpenAI API keys for embeddings and vectorization

## Benefits and outcomes
- Reduces time spent on manual email sorting and data processing
- Centralized, structured storage of email-derived information
- Enables fast document search via RAG system
- Automated query analysis and accurate response generation using live data
- Seamless integration between cloud storage, databases, and AI agents
- Supports complex analytical tasks without manual intervention

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.