AI-Powered Document Processing and Smart Email Automation
detail.loadingPreview
Automate your document processing and email communication with this powerful n8n workflow. It monitors Google Drive for new files, extracts key information using local LLMs, updates your Google Sheets database, and then intelligently crafts and sends personalized emails via Gmail.
About This Workflow
Streamline your document-heavy workflows with this sophisticated n8n automation. Triggered by new file uploads in Google Drive, this workflow intelligently downloads and extracts critical data from documents, leveraging the power of local Large Language Models (LLMs) like Ollama for precise information extraction. The extracted insights are automatically recorded in a Google Sheet, ensuring your data is always up-to-date. Further enhancing efficiency, an advanced OpenAI-powered agent, supported by a Postgres PGVector store for contextual memory, generates and dispatches highly personalized emails via Gmail, turning raw data into actionable communication effortlessly.
Key Features
- Google Drive Integration: Automatically detects and processes new files uploaded to your specified Google Drive folders.
- Intelligent PDF Data Extraction: Utilizes an
Extract from PDFnode combined with a LangChainInformation Extractorand local Ollama LLM to accurately pull relevant data from documents. - Dynamic Database Updates: Seamlessly populates and updates your Google Sheets with the extracted information, providing a centralized data repository.
- AI-Powered Email Generation: Employs an OpenAI agent, enhanced with a Postgres PGVector store for RAG capabilities, to create highly personalized and contextually relevant emails.
- Automated Email Dispatch: Sends out the AI-generated emails directly through Gmail, ensuring timely and consistent communication.
How To Use
- Configure Google Drive Trigger: Set up the
Google Drive Triggernode to monitor your desired folder for new file uploads. - Set up Google Drive Download: Connect the
Download Binary - filenode and configure it to download the newly created file from the trigger. - Configure PDF Extraction: Ensure the
Extract from PDFnode is connected to process the downloaded binary file. - Integrate Ollama and Information Extractor: Connect the
Ollama Modelas the language model for theInformation Extractorand configure the extractor with the specific information schema you wish to extract. - Connect Google Sheets: Configure the
Update DB - spreadsheetnode to map the extracted data to the correct columns in your Google Sheet. - Set up OpenAI Agent and PGVector: Configure the
Create Email Agentwith your OpenAI credentials. If using, connect and configure thePostgres PGVector Storeas a tool for the agent, defining your vector database connection details. - Configure Gmail Send Email: Set up the
Send Emailnode with your Gmail credentials and define the email template, using expressions to inject AI-generated content and extracted recipient details.
Apps Used
Workflow JSON
{
"id": "72dc0230-c891-40bc-a073-b7f00d870ac3",
"name": "AI-Powered Document Processing and Smart Email Automation",
"nodes": 27,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 72dc0230-c891...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.