Curated

(5/5)

Extract text from PDF and image using Vertex AI (Gemini) into CSV

How to extract PDF and image text into CSV using n8n (without manual data entry) This workflow will extract text data from PDF and images, then store it as CSV. [💡 You can read more about this workflow here](https://rumjahn.com/how-to-create-an-a-i-agent-to-analyze-matomo-analytics-using-n8n-for-free/)

Integrations Used (4)

Workflow Structure (12 nodes)

100%

Google Drive Trigger

Get PDF or Images

Switch

Route based on PDF or Image

Google Drive

Download PDF

Extract From File

Extract data from PDF

Http Request

Send data to A.I.

Convert To File

Convert to CSV

Google Drive

Upload to Google Drive

Google Drive

Download Image

Langchain.lm Chat Google Gemini

Google Gemini Chat Model

Langchain.chain Llm

Vertex A.I. extract text

Convert To File

Convert to CSV2

Google Drive

Upload to Google Drive1

Node Types:

action

trigger

logic

default

http

transform

Requires credentials

Prerequisites

Required Credentials (3)

Google

Used by: Get PDF or Images, Download PDF +3 more

Docs

Google Palm

Used by: Google Gemini Chat Model

Docs

HTTP Header Auth

Used by: Send data to A.I.

Docs

Multiple services required

This workflow needs 3 different credentials. Make sure you have accounts for all services before importing.

Complexity

Complex

Advanced features used. Requires n8n experience.

Setup time: ~40 min

Score: 57/100

Conditional Logic

5 Integrations

When to Use This Workflow

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Time Savings

Replace repetitive manual tasks with reliable automation.

Reclaim hours every week for higher-value work.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "id": "sUIPemKdKqmUQFt6",
  "meta": {
    "instanceId": "558d88703fb65b2d0e44613bc35916258b0f0bf983c5d4730c00c424b77ca36a",
    "templateCredsSetupCompleted": true
  },
  "name": "Extract text from PDF and image using Vertex AI (Gemini) into CSV",
  "tags": [],
  "nodes": [
    {
      "id": "f60ef5f9-bc08-4cc9-804e-697ae6f88b9b",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        980,
        920
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-1.5-pro-latest"
...