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

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

Every company has documents sitting in Google Drive that nobody reads. HR policies, sales playbooks, product FAQs, financial guidelines — all written once, never found again. This workflow turns all o

Google Sheets, Gmail, Google Drive +5
AI & RAG

Self-Hosted

Google Drive Trigger, Google Drive, N8N Nodes Qdrant +4