Automate Facebook Reels Publishing with Google Sheets and Drive

Publish a Reel on a Facebook Page

🧠 Good to Know

This workflow automatically uploads and publishes Facebook Reels using data from Google Sheets and video files stored in Google Drive. It runs on a schedule (every 30 minutes by default) and can be fully customized for your posting routine.

⚙️ How It Works

1. Google Sheets provides the content data — video file ID, caption, and optional links.
2. Google Drive hosts the actual video file (.mp4 format).
3. The workflow initializes an upload session with the Facebook Graph API, uploads the video, and publishes it as a Reel on your Page.
4. Finally, it updates your Google Sheet and adds a comment under the published Reel with your affiliate or product link.

How to Use

1. Open the template Google Sheet or make a copy:
   👉 Template Sheet

2. Fill out each row with:

   • File ID → the ID of your video file from Google Drive
   • File name → optional
   • Caption → your post caption
   • Link Share → optional
   • Link post → leave empty (it will be filled after posting)

3. Ensure your video file:

   • .mp4 format
   • shared folder on Google Drive that’s accessible to your connected account

4. Add your Facebook Page ID and Page Access Token to the “info” node.
   (Learn how to get these here: Facebook Reels Workflow Guide)
   

📋 Requirements

• n8n instance (Self-hosted recommended):

  • Set up a self-hosted instance using https://tino.vn/vps-n8n?affid=388
  • Use the code VPSN8N for up to 39% off.

• Facebook Page with publishing permissions

• Page Access Token (with pages_manage_posts, pages_read_engagement)

• Google Drive and Google Sheets account connected to n8n

• Video files in .mp4 format, under the 1GB upload limit

🎨 Customizing This Workflow

• Change schedule: Adjust the Schedule Trigger node (e.g., every 2 hours or only during business hours).
• Track post links: Add a node to fetch the permalink_url from the Graph API and update it in your sheet.
• Auto-comment control: Modify or remove the “Create comment post” node to suit your campaign style.
• Improve security: Replace hardcoded tokens with n8n credentials, secrets, or a Data Table lookup.

This structure keeps your automation scalable, secure, and easy to adapt for multi-page or multi-brand use.