Validate n8n JSON workflows with GPT-4 & LangChain: Google Drive to Sheets
Ready for 3.0What this workflow does
This AI workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Drive, Google Sheets and Azure OpenAI Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Search files and folders (Google Drive): uses Google Drive
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Download file (Google Drive): uses Google Drive
- Extract from File: extracts data from a file
- AI Agent: runs an AI agent, with model: Azure OpenAI Chat Model; memory: Simple Memory
- Append or update row in sheet (Google Sheets): uses Google Sheets
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Extract from File
n8n-nodes-base.extractFromFile
From the author
Description: This advanced n8n automation template checks the validity and production-readiness of multiple JSON workflow files using AI-powered analysis. It scans a designated Google Drive folder for uploaded JSON files, downloads them one by one, parses…