Automate video story publishing to Facebook Page using Google Drive and Sheets

Automated Facebook Page Story Video Publisher (Google Drive → Facebook → Google Sheet) > Recommended: Self-hosted via [tino.vn/vps-n8n?affid=388](https://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 Google Drive to your Facebook Page Stories, while using Google Sheets as a posting queue manager.

---

What This Workflow Does (Workflow Function)

This automation orchestrates a complete multi-step process for uploading and publishing videos to Facebook Stories:

1. Queue Management: Every 2 hours and 30 minutes, the workflow checks a Google Sheet (Get Row Sheet node) to find the first video whose Stories column is empty — meaning it hasn’t been posted yet. 2. Conditional Execution: An If node confirms that the video’s File ID exists before proceeding. 3. Video Retrieval: Using the File ID, the workflow downloads the video from Google Drive (Google Drive node) and calculates its binary size (Set to the total size in bytes node). 4. Facebook 3-Step Upload: It performs the Facebook Graph API’s three-step upload process through HTTP Request nodes:

Step 1 – Initialize Session: Starts an upload session and retrieves the uploadurl and videoid. Step 2 – Upload File: Uploads the binary video data to the provided uploadurl. Step 3 – Publish Video: Finalizes and publishes the uploaded video as a Facebook Story. 5. Status Update: Once completed, the workflow updates the same row in Google Sheets (Update upload status in sheet node) using the rownumber to mark the video as processed.

---