Validate workflows: GPT-4o with Drive, Slack & Gmail

📘 Description: 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 folder, validates their integrity, analyzes their quality against official n8n Template Publishing Guidelines, generates a structured report, converts it into a formatted .txt file, and archives it with instant notifications sent via Slack and email. It ensures a fully autonomous review cycle for workflow publishing, complete with error tracking, AI-based evaluations, and automated reporting.

⚙️ What This Workflow Does (Step-by-Step)

▶️ When Clicking ‘Execute Workflow’ (Manual Trigger) Initiates the validation pipeline manually, allowing users to start the batch evaluation process on demand.

📂 Fetch Workflow Files from Drive Retrieves all JSON workflow files from the “n8n json checker” Google Drive folder, including their metadata (ID, name, timestamps). Acts as the primary input source for the validation loop.

🔄 Process Files One by One Splits the list of files into individual items to ensure controlled, sequential processing. Prevents API overload and maintains order during AI evaluation.

⬇️ Download Workflow JSON File Fetches each workflow file from Drive using its file ID. Ensures a complete, uncorrupted copy before validation begins.

🔍 Validate File Download Success (IF Node) Checks if the downloaded file includes a valid id and JSON structure. ✅ True Path: Continues to parsing and analysis. ❌ False Path: Logs the failed file to a Google Sheet for audit and debugging.

🧾 Parse JSON Workflow Structure Converts raw JSON files into object data structures readable by AI. Verifies JSON syntax and schema readiness for further evaluation.