Batch download Facebook Reels videos from Google Sheets to Google Drive

How it works

Reads rows from the Tasks sheet where status = PENDING and facebook_reels_url is not empty.

Processes each Facebook Reels URL to get video metadata and a downloadable video file.

Downloads the video and uploads it to Google Drive into a daily subfolder named YYYY-MM-DD under your chosen parent folder.

Generates a shareable link for the uploaded file.

Updates the same row in Google Sheets with:

title (video title)

author (creator or page name)

drive_link (Google Drive link)

status (DONE on success / ERROR on failure)

error_message (only when failed)

What you need to set up

Google Drive connection and a parent folder for daily archives

A Google Sheet with these columns (header names must match):

facebook_reels_url, status, title, author, drive_link, error_message

Google Sheets template (recommended)

Preview Link:

https://docs.google.com/spreadsheets/d/1dtnfCFAOzpmcPov4aM8lKJaVnxfLPWtXcac_g67gA_4/edit?usp=sharing

Copy Link:

https://docs.google.com/spreadsheets/d/1dtnfCFAOzpmcPov4aM8lKJaVnxfLPWtXcac_g67gA_4/copy

Please do not rename the column headers.

Notes

If you don’t see updates immediately in Google Sheets, refresh the page.

Only archive content you own or have permission to save.