Create personalized videos from Google Sheets with iLoveVideoEditor and Gmail
UnknownWhat this workflow does
This workflow has 14 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets, Google Drive, Gmail and Ilovevideoeditor (community).
How it runs
Trigger: On Google Sheets events (row added).
- If: checks a condition and branches into true / false
- Render Personalized Video (Ilove Video Editor): create from template (render)
- Wait: waits 60 seconds
- Send Failure Alert Email (Gmail): send (message)
- Check Video Render Status (Ilove Video Editor): get (render)
- If: checks a condition and branches into true / false
- Download Video File (HTTP Request): calls an HTTP API (GET)
- If: checks a condition and branches into true / false
- Upload Video to Drive (Google Drive): upload (file)
- Increment Attempt Count (Edit Fields (Set)): sets 1 field: attempts
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-ilovevideoeditor is verified or supports 3.0 (used in Render Personalized Video, Check Video Render Status).
Nodes used (9)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - If
n8n-nodes-base.if - Ilove Video Editor
n8n-nodes-ilovevideoeditor.iloveVideoEditor - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview This workflow watches Google Sheets for new rows, renders a personalized video with iLoveVideoEditor using the row data, uploads the finished MP4 to Google Drive, writes the Drive link back to the same sheet row, and emails the link to the…