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.
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.
New buyers can create an account from the cart to unlock a controlled $10 first-purchase credit on eligible orders of $25+.
Secure checkout powered by Stripe
Support
How to import this workflow into Make
- 1Purchase or download the workflow to get the Make blueprint JSON file.
- 2In Make, create a new scenario, click the three-dots menu, and choose "Import Blueprint".
- 3Reconnect each module to your own app connections when prompted.
- 4Run the scenario once to verify it, then set your schedule and turn it on.
Related Video & Audio workflows
More from Leandro Rossi
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.