{"product_id":"n8n-workflow-clip-short-videos-from-transcripts-google-drive-openai","title":"n8n Workflow: Clip Short Videos from Transcripts (Google Drive + OpenAI)","description":"\u003ch3\u003eTurn Google Drive transcripts into ready-to-render short video clips—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors a Google Drive folder for new transcript JSON files, asks OpenAI to find the best standalone short-clip time ranges with hooks and captions, runs a strict quality gate, and then calls your render (and optional publish) HTTP endpoints—logging every result to n8n Data Tables.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects new transcript files in Google Drive\u003c\/strong\u003e and triggers immediately when a file is added to your selected folder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDownloads and parses transcript JSON\u003c\/strong\u003e that includes \u003cem\u003eword-level timestamps\u003c\/em\u003e. Invalid\/unparsable files are recorded in a \u003cstrong\u003edead-letter\u003c\/strong\u003e Data Table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI (Chat)\u003c\/strong\u003e to generate a structured list of candidate clips (start\/end times, hook, caption, and a standalone score).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits candidates into individual clips\u003c\/strong\u003e, then skips any clip whose start time is already stored for the same source video in an n8n Data Table (prevents duplicates).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies a quality gate per clip\u003c\/strong\u003e, enforcing duration bounds, non-empty\/non-truncated text, banned phrases\/placeholders, clean word-boundary start, and a minimum standalone score. Failures go to a \u003cstrong\u003ereview queue\u003c\/strong\u003e table with reasons.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls your render endpoint\u003c\/strong\u003e for passing clips and validates the response includes a usable asset URL, file size, and duration before saving to a \u003cstrong\u003edrafts\u003c\/strong\u003e queue table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptionally publishes\u003c\/strong\u003e by calling your publish HTTP endpoint when automatic publishing is enabled.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs a per-run summary\u003c\/strong\u003e (including zero-candidate runs and reason tallies) to an n8n Data Table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRepurpose long-form video transcripts from Google Drive into short clips for social publishing.\u003c\/li\u003e\n  \u003cli\u003eMaintain a review and drafts queue for content teams using automated quality checks.\u003c\/li\u003e\n  \u003cli\u003eAutomate “clip selection → render → (optional) publish” for SaaS operators managing high-volume video workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/inputs:\u003c\/strong\u003e Google Drive (new file trigger, download), OpenAI (Chat).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore workflow logic:\u003c\/strong\u003e if, set, code, split out, aggregate, data table.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExternal outputs:\u003c\/strong\u003e HTTP render endpoint (validated asset URL\/file size\/duration) and optional HTTP publish endpoint.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eCategory:\u003c\/strong\u003e n8n automation workflow\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46008724488371,"sku":"N8N-19506","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Tiyz1s6LvsRBNC4vEHu5k_52XXb44v.png?v=1789203968","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-clip-short-videos-from-transcripts-google-drive-openai","provider":"N8N Commerce","version":"1.0","type":"link"}