Automate video story publishing to Facebook Page using Google Drive and Sheets
Ready for 3.0What this workflow does
This workflow has 14 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Drive and Google Sheets.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Search files and folders (Google Drive): work with file folder
- info (Edit Fields (Set)): sets 2 fields: ID Page, Token
- Append or update row in sheet (Google Sheets): append or update
- Get Row Sheet (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Step 1: Initialize session (HTTP Request): calls an HTTP API (POST)
- Google Drive: download
- Set to the total size in bytes (Code): runs custom JavaScript code
- Step 2: Upload the stored file (HTTP Request): calls an HTTP API (POST)
- Step 3. Post video (HTTP Request): calls an HTTP API (POST)
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Drive
n8n-nodes-base.googleDrive - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code
From the author
Automated Facebook Page Story Video Publisher (Google Drive → Facebook → Google Sheet) > Recommended: Self-hosted via tino.vn/vps-n8n?affid=388 — use code VPSN8N for up to 39% off. This workflow is an automated solution for publishing video content from…