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

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.

• Configure live on Google Meet / Zoom
• Free follow-up if workflow has defects
• Platform expert assigned to you