This n8n workflow automates the process of downloading TikTok videos from a list of URLs stored in a Google Sheet, uploading them to Google Drive, setting public access, and updating the sheet with the new shared links. Starting with a manual trigger, it fetches TikTok URLs from Google Sheets, processes each one in batches, and uses an API to retrieve the video downloads. After downloading each video, the workflow uploads it to Google Drive, shares it publicly, and updates the sheet with the corresponding Drive link. This automation streamlines TikTok video archiving, sharing, and project management, saving time and reducing manual effort.
**Step-by-step process:**
1. The process begins when you manually trigger the workflow.
2. The workflow reads TikTok URLs from a specified Google Sheet.
3. It loops over each URL in the list, applying a delay to manage rate limits.
4. It sends each URL to a TikTok downloader API, retrieving a direct download link.
5. It downloads the TikTok video from the obtained link.
6. The video is uploaded to Google Drive in the root folder.
7. The uploaded file’s permissions are set to make it publicly accessible.
8. The Google Sheet is updated with the new Google Drive share link corresponding to each TikTok URL.
9. The workflow pauses briefly before processing the next URL, ensuring stability.
**Use cases:**
This workflow is ideal for content creators, digital marketers, or teams managing a large volume of TikTok videos who want to automate the downloading, hosting, and sharing process—all tracked within a Google Sheet for easy management.
Reviews
There are no reviews yet.