Create daily outdoor booking call-sheet videos with Open-Meteo and Zvid
UnknownWhat this workflow does
This workflow has 51 nodes and runs on a schedule (every day at 06:00) (plus 1 other trigger). Along the way it connects Google Sheets and Zvid (community). It also calls geocoding-api.open-meteo.com and api.open-meteo.com over HTTP.
How it runs
Trigger: On a schedule (every day at 06:00) (plus 1 other trigger).
- Set the location date and booking thresholds (Edit Fields (Set)): sets or maps fields
- Read Weather Briefings recovery log (Google Sheets): read (sheet)
- Recover accepted work before reading new sources (Code): runs custom JavaScript code
- A saved render needs recovery? (If): checks a condition and branches into true / false
- Eligible source content or saved render exists? (If): checks a condition and branches into true / false
- Read requested sessions and confirmed bookings (Google Sheets): read (sheet)
- Resume the accepted render job? (If): checks a condition and branches into true / false
- Explain skipped content or recovery needs (Code): runs custom JavaScript code
- Validate the dated booking brief (Code): runs custom JavaScript code
- Restore the saved result and handoff context (Code): runs custom JavaScript code
…plus 39 more steps. See the full node list below.
Services it uses
HTTP calls to: geocoding-api.open-meteo.com, api.open-meteo.com
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 @zvid/n8n-nodes-zvid is verified or supports 3.0 (used in Validate the video and request its credit quote, Submit this approved video to Zvid, Wait for this accepted Zvid render).
Nodes used (9)
- Edit Fields (Set)
n8n-nodes-base.set - Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Zvid
@zvid/n8n-nodes-zvid.zvid - Wait
n8n-nodes-base.wait
From the author
Quick overview Create local forecast videos with a useful planning decision. Resolve one city, check fresh Open-Meteo data, rank remaining three-hour daylight windows by rain and wind, and show either a qualifying window or a no-window notice with the…