Extract Text from PDF and Image to CSV

Name: Extract Text from PDF and Image to CSV
Rating: 4.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

31 views

0 downloads

Data Extractionaiautomationcsvgeminigoogle driveimageocrpdftext extraction

Automates the extraction of text from PDF and image files and converts it into a CSV format.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of extracting textual data from both PDF documents and image files. It utilizes Google Drive to monitor for new files, processes them to extract text, and then converts the extracted information into a CSV file, which is subsequently uploaded back to Google Drive. This eliminates the need for manual data entry from documents and images.

Key Features

Monitors a specified Google Drive folder for new PDF or image files.
Supports extraction of text from both PDF documents and image files.
Leverages AI models (Vertex AI Gemini or other specified models) for advanced text extraction and categorization.
Automatically converts the extracted data into CSV format.
Uploads the generated CSV files to a designated Google Drive folder.

How To Use

Set up Google Drive Folder: Create a dedicated folder in your Google Drive to store the PDF and image files you want to process. Ensure the n8n service account has appropriate permissions to access and upload files to this folder.
Configure Google Drive Trigger: Set up the Get PDF or Images node to watch the specified Google Drive folder for new file creations.
Configure AI Model: Choose and configure your preferred AI model (e.g., Vertex AI Gemini) in the Google Gemini Chat Model or Send data to A.I. nodes. Ensure your API credentials are correctly set up.
Define Output Folder: Specify the Google Drive folder where the generated CSV files should be uploaded (e.g., 'CSV Exports').

Apps Used

automation

csv

gemini

google drive

image

ocr

pdf

text extraction

Workflow JSON

{
  "id": "68a15b3e-990a-4776-b175-3190a7d09ccf",
  "name": "Extract Text from PDF and Image to CSV",
  "nodes": 0,
  "category": "Data Extraction",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.