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. U
At a glance
Batch archive TikTok videos from links in Google Sheets to Google Drive is a ready-made Make.com workflow you import as a blueprint JSON file — no build required. It connects Google Sheets, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- Make.com
- Connects
- Google Sheets, Google Drive
- Modules
- 22
- Price
- Free
- Version
- v1.0
About this workflow
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.
How to import this Make.com workflow
- 1
Download the blueprint JSON file after purchase.
- 2
Open Make.com → go to Scenarios → click Import Blueprint.
- 3
Select the downloaded JSON file and confirm.
- 4
Connect your app credentials in each module.
- 5
Run once manually to test, then activate the schedule.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related Make workflows
AI content creation and auto WordPress publishing with Pexels API image workflow
Add new Inoreader articles to Google Sheets as rows
Calculate Bonusly monthly points in Google Sheets
Remove XMP tags from files in Google Drive
Generate content in Google Docs using data from Google Sheets range values and ChatGPT
BrowserAct Flipboard News Scraper & Google Sheets Sync
Create opportunities in Salesforce from new Stripe charges
Create JIRA Cloud Platform issues from new Zendesk tickets (with attachments)
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with Make.com
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you