Back to Templates

Generate Template Descriptions from Google Drive with Azure GPT-4

Created by

Created by: Rahul Joshi || rahul08

Rahul Joshi

Last update

Last update 12 hours ago

Share


Description

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 delivers Markdown and HTML outputs directly to your inbox. 🚀💌📊💬

What This Template Does

  • Manually triggers the workflow to start processing.
  • Searches a specified Google Drive folder for JSON workflow files.
  • Iterates through each JSON file found in that folder.
  • Downloads each file and prepares it for data extraction.
  • Parses workflow data from the downloaded JSON content.
  • Uses Azure OpenAI GPT-4 to generate concise titles and detailed descriptions.
  • Converts the AI output into structured Markdown for n8n template publishing.
  • Creates an HTML version of the description for email delivery.
  • Logs generated details into a Google Sheet for record-keeping.
  • Sends an email containing the Markdown and HTML descriptions to the target recipient.

Key Benefits

✅ Fully automates n8n template description creation.
✅ Ensures consistency with official n8n publishing guidelines.
✅ Saves time while eliminating human writing errors.
✅ Provides dual Markdown + HTML outputs for flexibility.
✅ Centralizes workflow metadata in Google Sheets.
✅ Simplifies collaboration and version tracking via email delivery.

Features

  • Manual workflow trigger for controlled execution.
  • Integration with Google Drive for locating and downloading JSON files.
  • Intelligent parsing of workflow data from JSON structure.
  • GPT-4-powered AI for title and description generation.
  • Automatic Markdown + HTML formatting for n8n publishing.
  • Google Sheets integration for persistent record-keeping.
  • Automated Gmail delivery of generated documentation.

Requirements

  • n8n instance (cloud or self-hosted).
  • Google Drive OAuth2 credentials with file read permissions.
  • Google Sheets OAuth2 credentials with edit permissions.
  • Azure OpenAI GPT-4 API key for AI text generation.
  • Gmail OAuth2 credentials for email sending.

Target Audience

  • n8n content creators documenting workflows. 👩‍💼
  • Automation teams handling multiple template deployments. 🔄
  • Agencies and freelancers managing workflow documentation. 🏢
  • Developers leveraging AI for faster template creation. 🌐
  • Technical writers ensuring polished, standardized outputs. 📊

Step-by-Step Setup Instructions

  • Connect your Google Drive account and specify the folder containing JSON workflows. 🔑
  • Authorize Google Sheets and confirm access to the tracking spreadsheet. ⚙️
  • Add Azure OpenAI GPT-4 API credentials for AI-powered text generation. 🧠
  • Connect Gmail credentials for automated email delivery. 📧
  • Run the workflow manually using a test JSON file to validate all nodes. ✅
  • Enable the workflow to automatically generate and send descriptions as needed. 🚀