📁 Download watermark-free TikTok videos to Google Drive with automated sheets logging
⚡ 812 views · 📁 File Management
💡 Pro Tip — Since TikTok doesn’t have a public API, getting data usually means fragile HTTP scraping. ScraperNode is a community node that gives you clean JSON for TikTok profiles, videos, and comments — drop it into your workflow and skip the parsing.
Description
📥 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.
📝 Description
This n8n automation accepts a TikTok video URL via a form, sends it to the TikTok Download Audio Video API, 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 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 Drive_URL = N/A. |
✅ Use Cases
- 📲 Social media managers downloading user-generated content
- 🧠 Educators saving TikTok content for offline lessons
- 💼 Agencies automating short-form video curation
- 🤖 Workflow automation demonstrations with n8n
🎯 Key Benefits
- ✔️ MP4 without watermark via TikTok Download Audio Video API
- ✔️ Automated Google Drive upload & shareable links
- ✔️ Centralized logging in Google Sheets
- ✔️ Error handling and retry-safe structure
- ✔️ Fully customizable and extendable within n8n
💡 Ideal for anyone looking to automate TikTok video archiving with full control over file storage and access.
🔐 How to Get Your API Key for the TikTok Download Audio Video API
- Go to 👉 TikTok Download Audio Video API - RapidAPI
- Click “Subscribe to Test” (you may need to sign up or log in).
- Choose a pricing plan (there’s a free tier for testing).
- After subscribing, click on the “Endpoints” tab.
- Your API Key will be visible in the “x-rapidapi-key” header.
🔑 Copy and paste this key into the httpRequest node in your workflow.
Create your free n8n account and set up the workflow in just a few minutes using the link below:
🔗 Nodes Used
Google Sheets, HTTP Request, Google Drive, n8n Form Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File