{
  "name": "Extract invoice data from Google Drive to Sheets using PDF.co AI parser",
  "nodes": [
    {
      "id": "ab1b7d2d-7eac-45eb-9e0a-36f14c56df14",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -768,
        1856
      ]
    },
    {
      "id": "869b9f99-2c91-48c8-bb9e-2f449fb8039a",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1344,
        1056
      ],
      "parameters": {
        "width": 400,
        "height": 1472,
        "content": "\n## ⚙️ Setup Instructions\n\n### 1) Connect Google Drive (OAuth2)\n1. In **n8n → Credentials → New → Google Drive (OAuth2)**  \n2. Sign in to the Google account that owns your invoice PDFs and **allow acc"
      }
    },
    {
      "id": "6ec9845b-306b-456a-8831-0142e780db1a",
      "name": "Sticky Note55",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -896,
        1056
      ],
      "parameters": {
        "width": 1744,
        "height": 1472,
        "content": "# 📄 Google Drive → AI Invoice Parser → Google Sheets (Due Log)\n\nThis workflow looks inside a **Google Drive folder**, parses each PDF invoice with **PDF.co’s AI Invoice Parser**, and appends vendor, a"
      }
    },
    {
      "id": "7750adf2-b5bd-4ed0-bf54-06b3b7878f5b",
      "name": "Get Parent Folder ID",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -560,
        1952
      ]
    },
    {
      "id": "5950e187-899f-4cd5-857b-ceb0bd5637f2",
      "name": "Get Invoice ID's",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -336,
        1632
      ]
    },
    {
      "id": "1c9d75d1-84b0-4d78-99d6-c3bc8647405d",
      "name": "Convert to URL",
      "type": "n8n-nodes-base.set",
      "position": [
        -128,
        1824
      ]
    },
    {
      "id": "44cc62d6-1764-4b6c-91c9-c0bd11e4bb37",
      "name": "AI Invoice Parser",
      "type": "n8n-nodes-pdfco.PDFco Api",
      "position": [
        96,
        2128
      ]
    },
    {
      "id": "eeb6adb8-e18e-4589-802b-3545d4e1c845",
      "name": "Set Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        288,
        1632
      ]
    },
    {
      "id": "a40f5ff5-c723-459b-8a4f-0e0affa19204",
      "name": "Store Data in Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        576,
        2160
      ]
    },
    {
      "id": "26a8becd-467b-4fad-9700-296a137f17f0",
      "name": "Sticky Note61",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        496,
        1632
      ],
      "parameters": {
        "width": 224,
        "height": 688,
        "content": "### 3) Connect Google Sheets (OAuth2)\n1. In **n8n → Credentials → New → Google Sheets (OAuth2)**  \n2. Log in with your Google account and **grant access**.  \n3. In the **Store Data in Google Sheets** "
      }
    },
    {
      "id": "e6420fe8-afa6-4861-aa2c-2c471de718e1",
      "name": "Sticky Note62",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -624,
        1552
      ],
      "parameters": {
        "width": 224,
        "height": 544,
        "content": "### 1) Connect Google Drive (OAuth2)\n1. In **n8n → Credentials → New → Google Drive (OAuth2)**  \n2. Sign in to the Google account that owns your invoice PDFs and **allow access**.  \n3. In the **Get Pa"
      }
    },
    {
      "id": "3accccf6-0a7c-44e2-863b-e7a7a61a7115",
      "name": "Sticky Note64",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        32,
        1808
      ],
      "parameters": {
        "width": 224,
        "height": 464,
        "content": "### 2) Connect PDF.co (AI Invoice Parser)\n1. Create a **PDF.co** account and copy your **API Key**.  \n2. In **n8n → Credentials → New → PDF.co API**, paste your key and **Save**.  \n3. In the **AI Invo"
      }
    }
  ],
  "connections": {
    "Set Fields": {
      "main": [
        [
          {
            "node": "Store Data in Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to URL": {
      "main": [
        [
          {
            "node": "AI Invoice Parser",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Invoice ID's": {
      "main": [
        [
          {
            "node": "Convert to URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Invoice Parser": {
      "main": [
        [
          {
            "node": "Set Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Parent Folder ID": {
      "main": [
        [
          {
            "node": "Get Invoice ID's",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Data in Google Sheets": {
      "main": [
        []
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get Parent Folder ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}