Download watermark-free TikTok videos to Google Drive with automated sheets logging

📥 TikTok to MP4 Converter with Google Drive & Sheets

Convert TikTok videos to MP4 , MP3 (without watermark), upload to Google Drive, and log conversion attempts into Google Sheets automatically — powered by [TikTok Download Audio Video API](https://rapidapi.com/PrineshPatel/api/tiktok-download-audio-video).

---

📝 Description

This n8n automation accepts a TikTok video URL via a form, sends it to the [TikTok Download Audio Video API](https://rapidapi.com/PrineshPatel/api/tiktok-download-audio-video), downloads the watermark-free MP4, uploads it to Google Drive, and logs the result (success/failure) into Google Sheets.

---

🧩 Node-by-Node Overview

| | Node | Functionality | |---|-------------------------------|-------------------------------------------------------------------------------| | 1 | 🟢 Form Trigger | Displays a form for user input of TikTok video URL. | | 2 | 🌐 TikTok RapidAPI Request | Calls the [TikTok Downloader API](https://rapidapi.com/PrineshPatel/api/tiktok-download-audio-video) to get the MP4 link. | | 3 | 🔍 If Condition | Checks if the API response status is "success". | | 4 | ⬇️ MP4 Downloader | Downloads the video file using the returned "no watermark" MP4 URL. | | 5 | ☁️ Upload to Google Drive | Uploads the video file to Google Drive root folder. | | 6 | 🔑 Set Google Drive Permission | Makes the file publicly shareable via link. | | 7 | 📄 Google Sheets (Success) | Logs TikTok URL + public Drive link into a Google Sheet. | | 8 | ⏱️ Wait Node | Delays to prevent rapid write operations on error. | | 9 | 📑 Google Sheets (Failure) | Logs failed attempts with DriveURL = N/A. |