PDF & Image to CSV (Vertex AI + OpenRouter)

This workflow automates the process of extracting text from PDF documents and images uploaded to Google Drive, then converting the extracted data into CSV format for easy analysis.

• For PDFs, text is extracted and enriched using OpenRouter AI.
• For images, text recognition is powered by Google Vertex AI (Gemini).
• The resulting CSV file is automatically saved back into a designated Google Drive folder.

This template is especially useful for financial records, invoices, receipts, and any workflow where structured data needs to be pulled out of semi-structured files.

✨ Features

• 📂 Google Drive Trigger – Detects new files in a specified folder.
• 🔀 Smart Routing – Identifies whether the uploaded file is a PDF or an image.
• 📑 PDF Text Extraction – Uses n8n’s extract node + OpenRouter AI for structured CSV output.
• 🖼️ Image OCR via Vertex AI – Extracts transaction details and converts them into CSV format.
• 🤖 AI Categorization – Adds a Category column to classify transactions automatically.
• 📊 CSV Conversion – Converts extracted text into CSV files ready for reporting or analysis.
• ☁️ Auto-Upload – Saves the processed CSV into a chosen Google Drive folder.