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

Name: Download watermark-free TikTok videos to Google Drive with automated sheets logging
Availability: InStock
Rating: 4.5 (64 reviews)
Author: Evoort Solutions

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

📥 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:

👉 Start Automating with n8n

Evoort Solutions

0 workflows

Nodes

set gmail telegram agent google-gemini

Complexity

advanced

Published 05 Sept 2025

Likes 0

View on n8n.io Download Workflow

✨

Share Your Workflow

Have a great workflow to share? Join the n8n Creator Hub and help the community!

Submit Your Template How to Submit

Related Workflows

Publish Zoom class recordings to Google Classroom automatically

## About This flow is ideal for online schools that use Zoom to teach classes and Google Classroom for storing materials and homework. It listens for Zoom webhooks that come after each recorded call is uploaded to Zoom Cloud (you'll need Zoom paid plan). When new meeting comes, it filters out calls that last less than 30 mins. After duration check, it checks if there is a Google Class that matches the call name. Your call must be named exactly as the Google Class you want the call to be uploaded to. If the class is found, it will extract the Class ID. This flow assumes that you have a specific topic used for storing class recordings and materials, so it will look for this topic and upload the material. If topic is not found, you'll get an email. ## Requirements You'll need a: - Zoom paid plan that supports Zoom Cloud - Google cloud console to set up Classroom API and Gmail API - OpenAI API key or any other provider

View

Template-based Google Drive folder generation with Forms and Apps Script

### Overview Stop manually creating folder structures for every new client or project. This workflow provides a simple form where users enter a name, and automatically duplicates your template folder structure in Google Drive—replacing all placeholders with the submitted name. ### What This Workflow Does 1. Displays a form where users enter a name (client, project, event, etc.) 2. Creates a new main folder in Google Drive 3. Calls Google Apps Script to duplicate your entire template structure 4. Replaces all `{{NAME}}` placeholders in files and folder names ### Key Features - **Simple form interface** — No technical knowledge required to use - **Recursive duplication** — Copies all subfolders and files - **Smart placeholders** — Automatically replaces `{{NAME}}` everywhere - **Production-ready** — Works immediately after setup ### Prerequisites - Google Drive account with OAuth2 credentials in n8n - Google Apps Script deployment (code below) - Template folder in Drive using `{{NAME}}` as placeholder ### Setup **Step 1: Create your template folder** ``` 📁 {{NAME}} - Project Files ├── 📁 01. {{NAME}} - Documents ├── 📁 02. {{NAME}} - Assets ├── 📁 03. Deliverables └── 📄 {{NAME}} - Brief.gdoc ``` **Step 2: Deploy Apps Script** 1. Go to [script.google.com](https://script.google.com) 2. Create new project → Paste code below 3. Deploy → New deployment → Web app 4. Execute as: `Me` | Access: `Anyone` 5. Copy the deployment URL **Step 3: Configure workflow** Replace these placeholders: - `DESTINATION_PARENT_FOLDER_ID` — Where new folders are created - `YOUR_APPS_SCRIPT_URL` — URL from Step 2 - `YOUR_TEMPLATE_FOLDER_ID` — Folder to duplicate **Step 4: Test** Activate workflow → Open form URL → Submit a name → Check Drive! --- ### Apps Script Code ```javascript function doPost(e) { try { var params = e.parameter; var templateFolderId = params.templateFolderId; var name = params.name; var destinationFolderId = params.destinationFolderId; if (!templateFolderId || !name) { return jsonResponse({ success: false, error: 'Missing required parameters: templateFolderId and name are required' }); } var templateFolder = DriveApp.getFolderById(templateFolderId); if (destinationFolderId) { var destinationFolder = DriveApp.getFolderById(destinationFolderId); copyContentsRecursively(templateFolder, destinationFolder, name); return jsonResponse({ success: true, id: destinationFolder.getId(), url: destinationFolder.getUrl(), name: destinationFolder.getName(), mode: 'copied_to_existing', timestamp: new Date().toISOString() }); } else { var parentFolder = templateFolder.getParents().next(); var newFolderName = replacePlaceholders(templateFolder.getName(), name); var newFolder = parentFolder.createFolder(newFolderName); copyContentsRecursively(templateFolder, newFolder, name); return jsonResponse({ success: true, id: newFolder.getId(), url: newFolder.getUrl(), name: newFolder.getName(), mode: 'created_new', timestamp: new Date().toISOString() }); } } catch (error) { return jsonResponse({ success: false, error: error.toString() }); } } function replacePlaceholders(text, name) { var result = text; result = result.replace(/\{\{NAME\}\}/g, name); result = result.replace(/\{\{name\}\}/g, name.toLowerCase()); result = result.replace(/\{\{Name\}\}/g, name); return result; } function copyContentsRecursively(sourceFolder, destinationFolder, name) { var files = sourceFolder.getFiles(); while (files.hasNext()) { try { var file = files.next(); var newFileName = replacePlaceholders(file.getName(), name); file.makeCopy(newFileName, destinationFolder); Utilities.sleep(150); } catch (error) { Logger.log('Error copying file: ' + error.toString()); } } var subfolders = sourceFolder.getFolders(); while (subfolders.hasNext()) { try { var subfolder = subfolders.next(); var newSubfolderName = replacePlaceholders(subfolder.getName(), name); var newSubfolder = destinationFolder.createFolder(newSubfolderName); Utilities.sleep(200); copyContentsRecursively(subfolder, newSubfolder, name); } catch (error) { Logger.log('Error copying subfolder: ' + error.toString()); } } } function jsonResponse(data) { return ContentService .createTextOutput(JSON.stringify(data)) .setMimeType(ContentService.MimeType.JSON); } ``` --- ### Use Cases - **Agencies** — Client folder structure on new signup - **Freelancers** — Project folders from intake form - **HR Teams** — Employee onboarding folders - **Schools** — Student portfolio folders - **Event Planners** — Event documentation folders ### Notes - Apps Script may take +60 seconds for large structures - Timeout is set to 5 minutes for complex templates - Your Google account needs edit access to template and destination folders

View

Learn how to use binary data in n8n (video included)

This template and YouTube video goes over 8 different examples of how we can utilize Binary data within n8n. We start with brining in Binary data with Google Drive, FTP, or Form submission. After we jump into how to extract Binary Data, Analyze an image, convert files, and use base64. This lesson also covers the recent update with grabbing binary data in later nodes. YouTube video: https://youtu.be/0Vefm8vXFxE

View

👨‍💻

Need Custom Automation?

N8N Automation Expert

Specialized in N8N automation, I design custom workflows that connect your tools and automate your processes.