Batch archive TikTok videos from links in Google Sheets to Google Drive
.webp)
About template
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.
Similar templates
Find inspiration by the type of content that fits your goals.
Generate ChatGPT Completions from Google Sheets Rows
Effortlessly enhance your content creation process by integrating ChatGPT with Google Sheets. This powerful template allows you to automatically generate relevant completions, ranging from SEO keywords to custom responses, boosting productivity and content quality with ease. Learn more
Add webhook data to a Google Sheet
Use this automation to instantly capture data from a webhook and automatically add it as a new row in a Google Sheet. This is ideal for real-time data logging, form submissions, or any event-driven updates that must be stored in a spreadsheet. Learn more about webhooks!
Send a Gmail email from a new Google Sheets row
Effortlessly send Gmail messages when a new row is added to your Google Sheets. Just ensure your spreadsheet includes these columns: Email Address Subject Content