Back to Templates
This workflow automates the process of downloading TikTok videos and uploading them to Google Drive. It reads TikTok URLs from a Google Sheet, downloads the video using the TikTok Video Downloader โ a tool for downloading TikTok videos without watermark in HD quality โ uploads it to Drive, makes it public, and updates the same sheet with the Drive link.
Make sure your sheet has at least these columns:
url | drive_link (to be auto-filled) |
---|---|
https://www.tiktok.com/@user1... | (blank initially) |
https://www.tiktok.com/@user2... | (blank initially) |
The workflow reads from
url
and fills indrive_link
after upload.
Node Name | Type | Purpose |
---|---|---|
When clicking โExecuteโ | Manual Trigger | Starts the workflow manually |
Get Data From Google Sheets | Google Sheets | Fetches rows (TikTok URLs) |
Loop Over Items | Split In Batches | Iterates over each row |
Call TikTok Downloader | HTTP Request | Gets video download link from TikTok Video Downloader |
Wait | Wait | Optional delay to prevent overload |
Download File | HTTP Request | Downloads HD video using media link |
Upload File In Google Drive | Google Drive | Uploads the video to Google Drive |
Set Public Permission | Google Drive | Makes the uploaded file publicly accessible |
Update Row In Google Sheet | Google Sheets | Adds Drive link to the same row |
Sleep | Wait | Small delay between each iteration |
url
column containing TikTok video URLsโ Challenge | โ Solution |
---|---|
TikTok video URLs often have watermarks and low quality | Used TikTok Video Downloader API for HD + no watermark download links |
No easy way to bulk download and organize TikToks | Automated fetching, downloading, and uploading using n8n + Google Drive |
Manual video saving and re-uploading to Drive is time-consuming | Eliminated all manual steps with a fully automated workflow |
Tracking which videos are already processed | Automatically updates the Google Sheet row with the final Drive link |
Drive files are private by default | Automatically sets public sharing permission on uploaded videos |
Risk of API rate limits or throttling | Added Wait nodes and batch processing to avoid overload |
๐ Benefit | ๐ฌ Description |
---|---|
๐ Saves Time | Fully automates a previously manual workflow |
๐ฅ High Quality Content | Videos downloaded are HD + watermark-free โ ready for reuse or archives |
๐ Reusable Setup | Can process unlimited TikTok URLs via the Google Sheet |
๐ Organized Output | Keeps track of source URL and uploaded Drive link in a single sheet |
๐ Secure but Shareable | Drive links are auto-shared publicly while remaining under your control |
๐ Scalable | Can be run daily, weekly, or triggered by new rows โ completely scalable |
๐ธ Cost-Effective | No need for paid tools or manual freelancers โ runs on n8n + free APIs |