Web Scraping & Data Extraction

Attachments Gmail to drive and google sheets

Manual

High

Nodes

Manual

Trigger

High

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

sticky Note

Sticky Note, Sticky Note2, Sticky Note6

3 nodes

gmail Trigger

Gmail Trigger1

1 node

set

Setup1, Map Output

2 nodes

http Request

Upload PDF to Drive1

1 node

google Drive

Rename file1, Move to the correct folder1, Google Drive

3 nodes

gmail

Gmail

1 node

extract From File

Extract from File2

1 node

lm Open Ai

OpenAI Model

1 node

output Parser Structured

Structured Output Parser

1 node

google Sheets

Append to Reconciliation Sheet

1 node

chain Llm

Apply Data Extraction Rules

1 node

Only invoice mails with attachments

1 node

Workflow JSON

15.71 KB

{
  "id": "XnGZZfT5u0Cw1X3p",
  "meta": {
    "instanceId": "3378b0d68c3b7ebfc71b79896d94e1a044dec38e99a1160aed4e9c323910fbe2",
    "templateCredsSetupCompleted": true
  },
  "name": "Attachments Gmail to drive and google sheets",
  "tags": [],
  "nodes": [
    {
      "id": "0404ef0a-9750-495a-8798-98d4b059a083",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -580,
        -420
      ],
      "parameters": {
        "height": 440,
        "content": "## Setup\n1. Setup your **Gmail** and **Google Drive** credentials\n2. Setup your **Google Sheets** credentials\n3. Setup your **Openai** api key"
      },
      "typeVersion": 1
    },
    {
      "id": "8751a7f1-aae4-4746-aae7-3d8563845b8c",
      "name": "Gmail Trigger1",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        -640,
        120
      ],
      "parameters": {
        "simple": false,
        "filters": {
          "readStatus": "unread"
        },
   ...

Showing first 1000 characters. Click "Expand" to view the full JSON.