Batch archive TikTok videos from links in Google Sheets to Google Drive

This template helps you archive TikTok videos from a Google Sheets list into Google Drive in an organized way.

How it works

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

Calls the Apify Actor liul/tiktok-video-audio-downloader to fetch video metadata and a downloadable video URL.

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 nickname)

drive_link (Google Drive link)

status (DONE on success / ERROR on failure)

error_message (only when failed)

What you need to set up

Apify connection (API token)

Google Drive connection and a parent folder for daily archives

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

tiktok_url, status, title, author, drive_link, error_message

Google Sheets template (recommended)

Make a copy: https://docs.google.com/spreadsheets/d/1gQ7Fi0NC7nHiAnvJt7MSEYSuQ23qih5XmM9VkFcxjlA/copy

Preview (view-only): https://docs.google.com/spreadsheets/d/1gQ7Fi0NC7nHiAnvJt7MSEYSuQ23qih5XmM9VkFcxjlA/edit?usp=sharing

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.