AutomationFlowsAI & RAG › Validate N8n JSON Workflows with Gpt-4 & Langchain: Google Drive to Sheets

Validate N8n JSON Workflows with Gpt-4 & Langchain: Google Drive to Sheets

ByRahul Joshi @rahul08 on n8n.io

Description:

Event trigger★★★★☆ complexityAI-powered16 nodesGoogle DriveGoogle SheetsAgentLm Chat Azure Open AiMemory Buffer Window
AI & RAG Trigger: Event Nodes: 16 Complexity: ★★★★☆ AI nodes: yes Added:

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

This workflow follows the Agent → 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
{
  "id": "Nhz3FZFOC8cVSIgl",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Json check automation",
  "tags": [],
  "nodes": [
    {
      "id": "32a806b9-15a0-4b98-aef8-a0ec3d768ce5",
      "name": "When clicking \u2018Execute workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1184,
        -128
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "99cbfdf5-5621-4979-acca-58c14f1efde1",
      "name": "Search files and folders",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -960,
        -128
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "308b5705-010c-4244-82f5-a0617d75d8ac",
      "name": "Download file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -512,
        -256
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "3c126eb6-b17f-411a-afb0-ac74c4f8a30d",
      "name": "Append or update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        336,
        -128
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "1bc40e03-eb40-47ff-925c-48077321fe1e",
      "name": "Loop Over Items1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -736,
        -128
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "c6c78342-c519-4e31-acf7-3e075a132be2",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -64,
        -256
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "fd8aed3f-d298-4b31-89f0-9a1f0a5b12ba",
      "name": "Azure OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        -32,
        -32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c82ab676-4ec7-429d-b661-d3b4a349f59a",
      "name": "Simple Memory",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        96,
        -32
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "66b12c5f-34ad-4047-bceb-1d30acae61ff",
      "name": "Extract from File",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        -288,
        -256
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a8d71076-a070-4929-9b22-52700b17582a",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1072,
        32
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "349d8da5-fb3d-4cdc-b8ad-351336f505fa",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1488,
        -384
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0551b0be-fdae-4997-82c3-562a70e6c536",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -912,
        -640
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0134bd47-ba61-4b9d-8fa1-5ea5d43b5555",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -496,
        -656
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1a01740b-afb9-4ecd-bbd9-e6de203b0174",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -352,
        80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "96a5132e-0d73-4ef4-8f1c-15a3e1af78a5",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -864
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ce9b62ca-8f73-4ee7-8177-949a049acc67",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        512,
        -208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d04c1b12-e1ff-4454-b8ab-ea0b44263455",
  "connections": {
    "AI Agent": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download file": {
      "main": [
        [
          {
            "node": "Extract from File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Simple Memory": {
      "ai_memory": [
        [
          {
            "node": "AI Agent",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items1": {
      "main": [
        [],
        [
          {
            "node": "Download file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract from File": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Search files and folders": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append or update row in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \u2018Execute workflow\u2019": {
      "main": [
        [
          {
            "node": "Search files and folders",
            "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

Description:

Source: https://n8n.io/workflows/6368/ — 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 workflow automates end-to-end validation, assessment, and reporting of n8n workflow JSON templates using Google Drive, Azure OpenAI GPT-4o, Gmail, and Slack. It retrieves workflows from a Drive f

Memory Buffer Window, Lm Chat Azure Open Ai, Output Parser Structured +5
AI & RAG

Automatically generate polished, n8n-ready template descriptions from your saved JSON workflows in Google Drive. This AI-powered automation processes workflow files, drafts compliant descriptions, and

Google Drive, Agent, Google Sheets +4
AI & RAG

This automation is designed to help you generate AI-powered music tracks, cover art, and fully rendered music videos — all triggered from a simple Telegram chat and managed via Google Sheets.

OpenAI Chat, Memory Buffer Window, Output Parser Structured +11
AI & RAG

This workflow is designed for marketers, content creators, agencies, and solo founders who want to publish long‑form posts with visuals on autopilot using n8n and AI agents. ​

Tool Http Request, Agent, HTTP Request +27
AI & RAG

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

Output Parser Structured, Telegram, N8N Nodes Tesseractjs +14