Process PDFs from Google Drive: extract data, save to S

This automation workflow processes incoming PDF documents—such as invoices, applications, or contracts—using AI. When a file is added to Google Drive, the system triggers a sequence: text extraction, key data analysis, structured storage, and automated email generation. It saves time for professionals, reduces manual entry errors, and integrates file storage with databases and email systems.

## Who it´s for
- Document management specialists automating incoming PDF processing
- Sales managers handling document-based leads
- Lawyers extracting data from contracts
- Administrators integrating file systems with databases and email

## What the automation does
- Triggers when a new PDF file is added to a specified Google Drive folder
- Downloads the document and extracts text using n8n and PDF parsers
- Analyzes content using LangChain with a local Ollama AI model (e.g., Llama 3)
- Extracts structured data: details, amounts, dates, contract parties, etc.
- Saves data to Google Sheets for operational access
- Stores vector embeddings in PGVector (PostgreSQL) for search and analysis
- Generates personalized emails based on extracted data using an AI agent
- Sends emails via Gmail account

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on google_drive_file_created event
- Integrations with Google Drive, Google Sheets, Gmail, PostgreSQL, and Ollama via LangChain
- Basic textual guide for setup and adaptation

## Requirements for setup
- n8n instance (self-hosted or cloud)
- Google Drive, Google Sheets, and Gmail accounts with API enabled
- Ollama server running with a selected model (e.g., llama3)
- PostgreSQL database with PGVector extension enabled
- Basic familiarity with n8n and environment variables

## Benefits and outcomes
- Fully automated document processing without manual input
- Centralized data storage in spreadsheets and vector database
- Fast response to incoming documents—notifications and replies within minutes
- Scalable to hundreds of documents per day
- Enables AI-powered search and analytics via vector storage
- Reduces employee workload and error risk

## 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.