Extract Text from PDFs/Images with Gemini AI to CSV

This n8n workflow streamlines expense tracking by monitoring a Google Drive folder for new PDFs or images, such as bank statements or screenshots. It leverages Google Vertex AI's Gemini model to perform intelligent text extraction and recognition, parsing key data like transactions, dates, and amounts into a structured format.

The workflow then generates a CSV file from the extracted data and automatically saves it to a designated output folder in Google Drive. This eliminates manual data entry, reducing errors and saving hours of tedious work. Ideal for personal finance management or business procurement teams handling digital receipts.

Benefits include seamless integration with Google services, customizable AI prompts for various document types, and scalability for bulk processing. Use cases span expense reporting, invoice processing, and any scenario requiring OCR-like extraction from unstructured documents into actionable CSV data.