AutomationFlowsAI & RAG › Extract Invoice Data From Pdfs with AI - Google Sheets Email Alerts

Extract Invoice Data From Pdfs with AI - Google Sheets Email Alerts

ByAashit Sharma @aashitsharma on n8n.io

Built by Setidure Technologies This smart n8n automation extracts invoice details from PDF files uploaded to Google Drive using AI, logs them to a Google Sheet, and notifies the billing team via email — all without manual intervention.

Event trigger★★★★☆ complexityAI-powered11 nodesInformation ExtractorGmailLm OllamaVector Store PgvectorGoogle Drive TriggerGoogle DriveOpenAIGoogle Sheets
AI & RAG Trigger: Event Nodes: 11 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #4763 — we link there as the canonical source.

This workflow follows the Gmail → Google Drive recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "nodes": [
    {
      "id": "76600f2a-f77c-4c95-8df6-e4d44a2d9e9e",
      "name": "Information Extractor",
      "type": "@n8n/n8n-nodes-langchain.informationExtractor",
      "position": [
        1420,
        40
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c96acdd1-a755-4700-86b5-c29e8cb5d32d",
      "name": "Send Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1360,
        420
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "ef869446-c764-4957-8c27-4f51410c80c9",
      "name": "No Operation, do nothing",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1580,
        440
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8e257d7c-bd82-44c4-901f-1b35d6ed1033",
      "name": "Ollama Model",
      "type": "@n8n/n8n-nodes-langchain.lmOllama",
      "position": [
        1440,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2e5babac-d216-48d5-97c5-7b528078a52a",
      "name": "Postgres PGVector Store",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePGVector",
      "position": [
        1380,
        680
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "0348c94a-d362-4c1f-8679-3d4e0a42ddfb",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -60,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fc19ba2d-a2ee-424b-a2f8-49690f1a2f74",
      "name": "Google Drive Trigger - file creation",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "f081fb04-9a51-42f5-8664-9fd866de9cf1",
      "name": "Download Binary - file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        220,
        0
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "470c9772-00cf-420e-876f-7efad7274ca9",
      "name": "Extract from PDF",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        800,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1cc7eae0-ccab-4c8a-a469-b27a7057d22a",
      "name": "Create Email Agent",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1020,
        420
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "42588358-40ba-46f7-bb97-38c67c676901",
      "name": "Update DB - spreadsheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1100,
        600
      ],
      "parameters": {},
      "typeVersion": 4.5
    }
  ],
  "connections": {
    "Send Email": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Ollama Model": {
      "ai_languageModel": [
        [
          {
            "node": "Information Extractor",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Extract from PDF": {
      "main": [
        [
          {
            "node": "Information Extractor",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Email Agent": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Information Extractor": {
      "main": [
        [
          {
            "node": "Update DB - spreadsheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download Binary - file": {
      "main": [
        [
          {
            "node": "Extract from PDF",
            "type": "main",
            "index": 0
          },
          {
            "node": "Update DB - spreadsheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Postgres PGVector Store": {
      "ai_tool": [
        [
          {
            "node": "Create Email Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Update DB - spreadsheet": {
      "main": [
        [
          {
            "node": "Create Email Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Drive Trigger - file creation": {
      "main": [
        [
          {
            "node": "Download Binary - file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Built by Setidure Technologies This smart n8n automation extracts invoice details from PDF files uploaded to Google Drive using AI, logs them to a Google Sheet, and notifies the billing team via email — all without manual intervention.

Source: https://n8n.io/workflows/4763/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

This n8n template automatically classifies incoming emails (Sales, Support, Internal, Finance, Promotions) and routes them to a dedicated OpenAI LLM Agent for processing. Depending on the category, th

OpenAI, Gmail, Text Classifier +16
AI & RAG

Carga Documentos. Uses googleDrive, openAi, googleDriveTrigger, embeddingsOpenAi. Event-driven trigger; 20 nodes.

Google Drive, OpenAI, Google Drive Trigger +8
AI & RAG

Agent IA Projet Client. Uses executeWorkflowTrigger, lmChatOpenAi, toolWorkflow, vectorStoreQdrant. Event-driven trigger; 79 nodes.

Execute Workflow Trigger, OpenAI Chat, Tool Workflow +16
AI & RAG

This advanced n8n workflow automates the full lead enrichment, qualification, and personalized outreach process tailored specifically for the B2B real estate sector. Integrating top platforms like Api

N8N Nodes Fillout, OpenAI Chat, Pinecone Vector Store +11
AI & RAG

This workflow builds a WhatsApp business assistant that uses OpenAI to classify incoming messages and route them to FAQ answers via Pinecone RAG, order placement and inventory updates in Google Sheets

WhatsApp Trigger, OpenAI, Agent +12