🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home n8n Workflow
January 22, 2026

TikTok to Google Drive, trend videos ready to review

Lisa Granqvist Partner Workflow Automation Expert

You find a trend, bookmark it, forget why it mattered, then scramble the day you need to post. Meanwhile your “ideas” live across likes, notes, DMs, and half-finished docs.

This TikTok Drive automation hits social media managers first, but marketers building content engines feel it too. A busy creator trying to post consistently? Same pain, just louder. The outcome is simple: a steady stream of fresh, review-ready short videos organized in Google Drive.

You will see how this n8n workflow takes trend research, turns it into AI video prompts, generates new vertical videos, and files everything neatly for approval and posting.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: TikTok to Google Drive, trend videos ready to review

The Problem: Trend Research Doesn’t Turn Into Postable Assets

Trend research is easy. Turning it into something your brand can actually publish is the grind. You end up jumping between TikTok, spreadsheets, a prompt doc, an AI tool, downloads, uploads, and a “final-final-v3” folder structure that nobody trusts. A single missed copy-paste can break the chain, so you double-check everything, which takes even longer. And if you work in recruiting or job-change content, trends move fast, so “I’ll get back to it later” quietly becomes “missed it.”

It adds up fast. Here’s where it usually breaks down.

  • Trend ideas get saved without context, so you cannot reuse them a week later.
  • Manual logging into a sheet takes about 10 minutes per batch, and it’s easy to skip when you’re busy.
  • AI prompts end up inconsistent, which means more edits and weaker hooks.
  • Even after a video is generated, someone still has to download it, rename it, and upload it to Drive for review.

The Solution: Auto-Scrape TikTok Trends, Generate New Videos, File to Drive

This workflow builds a clean pipeline from “what’s trending” to “what can we post next.” You manually kick it off in n8n, and it starts a TikTok scrape using Apify, focused on job-change and employment keywords (転職/就職). When the scrape finishes, the workflow pulls the results and writes the raw metadata into Google Sheets, so you have a searchable record of what was found. Then an AI Agent (via OpenRouter) reads the content and produces a detailed video prompt that’s actually usable, including visual cues and vertical formatting. Finally, the prompt is sent to Fal AI (Veo3) to generate a new 8-second 9:16 video with audio, and the finished file is uploaded straight into your chosen Google Drive folder for review.

It starts with TikTok trend discovery through Apify, then moves into prompt creation and logging in Google Sheets. After that, Fal AI renders the new short video, and Google Drive becomes the single place your team reviews and approves what gets posted.

What You Get: Automation vs. Results

Example: What This Looks Like

Say you review 10 trend clips each morning and typically turn 2 of them into draft videos. Manually, that’s roughly 10 minutes to log sources, about 15 minutes to write prompts, then another 10 minutes per video to download and upload files, so you’re spending around an hour before you’ve made anything “reviewable.” With this workflow, you trigger one run, wait for the scrape and render, and end up with new 8-second vertical videos already sitting in Google Drive. Most teams get close to an hour back per batch, and the folder becomes your daily approval queue.

What You’ll Need

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • Apify to scrape TikTok search results
  • Google Sheets to store raw data and prompts
  • OpenRouter API key (get it from your OpenRouter dashboard)
  • Fal AI API key (get it from your fal.ai account settings)
  • Google Drive to store generated videos for review

Skill level: Intermediate. You’ll connect a few accounts, paste API keys, and update a spreadsheet ID and Drive folder ID.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

You start the run in n8n. The workflow begins with a manual trigger, which is useful when you want to “pull trends now” before planning content for the day.

TikTok trend data gets scraped and logged. n8n starts an Apify TikTok scraper run, waits, then fetches the results and writes the raw metadata into Google Sheets so nothing is lost.

AI turns raw clips into a usable video prompt. The OpenRouter-powered AI Agent analyzes the scraped text and context, then outputs a structured prompt (concept, visual cues, aspect ratio) and saves it into a separate tab in the same Google Sheet.

Fal AI generates the new short video and Drive becomes the review hub. The prompt is submitted to Fal AI (Veo3) to render an 8-second vertical video with audio, the workflow waits for completion, retrieves the file, and uploads it into a specific Google Drive folder.

You can easily modify the search queries to match your niche based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

Start the workflow manually so you can validate the scrape and generation flow end-to-end.

  1. Add and open Manual Execution Start.
  2. Leave all settings as default—this node simply starts the run when you click Execute Workflow.
  3. Confirm it connects directly to Start Scrape Run.

Step 2: Launch the scrape and fetch results

Trigger the Apify TikTok scraper, wait for the run to complete, then retrieve the dataset items.

  1. Open Start Scrape Run and set URL to https://api.apify.com/v2/acts/clockworks~tiktok-scraper/runs?token=[CONFIGURE_YOUR_TOKEN].
  2. Set Method to POST and enable Send Body.
  3. Set Specify Body to JSON and keep the provided JSON (including "searchQueries": ["転職","就職"]).
  4. Open Delay Execution and set Amount to 10 (seconds) to allow the scrape to finish.
  5. Open Fetch Scrape Results and set URL to https://api.apify.com/v2/acts/clockworks~tiktok-scraper/runs/last/dataset/items?token=[CONFIGURE_YOUR_TOKEN].

⚠️ Common Pitfall: Replace [CONFIGURE_YOUR_TOKEN] in both HTTP URLs with your Apify API token or the request will fail.

Step 3: Connect Google Sheets and limit records

Store raw scrape data and cap how many records are passed to the AI prompt stage.

  1. Open Update Raw Sheet and set Operation to appendOrUpdate.
  2. Set Document to your spreadsheet (replace [YOUR_ID]), and set Sheet to シート1 (replace [YOUR_ID] if needed).
  3. Credential Required: Connect your Google Sheets credentials.
  4. Open Record Limit and set the record limit as needed (this node caps how many rows proceed to AI).

Tip: If you want more AI prompts per run, increase the limit in Record Limit.

Step 4: Set up the AI prompt generation

Generate video prompts using a language model and write them to the prompt sheet.

  1. Open AI Prompt Builder and keep Prompt Type set to define.
  2. Set Text to the provided Japanese prompt, including the dynamic fields {{ $json.text }} and {{ $json.authorMeta.id }}.
  3. Ensure OpenRouter Chat Engine is connected as the language model for AI Prompt Builder.
  4. Credential Required: Connect your OpenRouter credentials on OpenRouter Chat Engine (AI credentials are added to the model node, not the agent).
  5. Open Update Prompt Sheet and set Operation to appendOrUpdate.
  6. Set Document to your spreadsheet (replace [YOUR_ID]) and Sheet to 生成済み.
  7. Credential Required: Connect your Google Sheets credentials.

Step 5: Submit video generation and upload results

Send prompts to Fal, pause while video renders, then upload the output to Google Drive.

  1. Open Fal Video Submission and set URL to https://queue.fal.run/fal-ai/veo3.
  2. Set Method to POST and enable Send Body.
  3. Add body parameters: prompt = {{$json["output"]}}, aspect_ratio = 9:16, duration = 8s, generate_audio = true.
  4. Credential Required: Connect your HTTP Header Auth credentials (required for Fal Video Submission).
  5. Open Generation Pause and set Unit to minutes (adjust delay as needed for render time).
  6. Open Retrieve Render Output and set URL to ={{ $node["Fal Video Submission"].json["response_url"] }}.
  7. Credential Required: Connect your HTTP Header Auth credentials (required for Retrieve Render Output).
  8. Open Drive File Upload and set Name to 生成済み, then select your target Folder (replace [YOUR_ID]).
  9. Credential Required: Connect your Google Drive credentials.

⚠️ Common Pitfall: If the Fal render takes longer than the pause, Retrieve Render Output may return incomplete data. Increase the Generation Pause duration for long renders.

Step 6: Test and Activate Your Workflow

Run a manual test to verify each stage before using the pipeline in production.

  1. Click Execute Workflow on Manual Execution Start to run the full pipeline.
  2. Confirm Update Raw Sheet writes TikTok scrape data into your Google Sheet.
  3. Check Update Prompt Sheet for newly generated prompts from AI Prompt Builder.
  4. Verify Drive File Upload creates a file named 生成済み in the selected Drive folder.
  5. When satisfied, switch the workflow to Active to use it in production (keep the manual trigger for on-demand runs).
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

  • Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials page and confirm the connected Google account can edit the target spreadsheet first.
  • If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
  • Apify tokens passed in URL query parameters are easy to rotate and forget. If the scrape suddenly returns nothing, confirm your Apify token is still valid and consider switching to header auth.

Frequently Asked Questions

How long does it take to set up this TikTok Drive automation?

About 45 minutes once you have your API keys ready.

Do I need coding skills to automate TikTok trend videos to Google Drive?

No. You will connect accounts, paste a few API keys, and update the Sheet ID and Drive folder ID.

Is n8n free to use for this TikTok Drive automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Apify credits, OpenRouter LLM costs, and Fal AI video generation credits.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this TikTok Drive automation workflow for a different niche?

Yes, and it’s one of the best parts. You change the searchQueries JSON in the first Apify HTTP Request node to target a new topic (like cooking, fitness, or real estate). Then tweak the AI Agent system prompt to match your brand voice and the kind of hooks you want. If you want different outputs, adjust the Fal Submit node to change duration, aspect ratio, or audio settings.

Why is my Google Drive connection failing in this workflow?

Usually it’s an expired or wrong Google OAuth connection in n8n. Reconnect the Google Drive credential and confirm the account has access to the destination folderId you set in the Upload file node. Also check if your Google Workspace has Drive restrictions, which can block file uploads from third-party apps. If the file is empty, look upstream at the Retrieve Render Output request because Drive will happily upload “something,” even if it’s not your video.

How many videos can this TikTok Drive automation handle?

If you self-host, there’s no execution cap from n8n itself, but you’ll be limited by your server and your Apify/OpenRouter/Fal AI credits.

Is this TikTok Drive automation better than using Zapier or Make?

Often, yes, because this flow mixes scraping, AI prompting, wait-and-retry timing, and file handling in one place. n8n is also easier to extend when you want branching logic (for example, “only generate videos when stats hit a threshold”), and self-hosting keeps execution volume from getting expensive. Zapier or Make can be quicker for simple two-app zaps, but video generation workflows get messy there. If approvals, prompts, and storage have to be reliable, n8n tends to feel sturdier. Talk to an automation expert if you want help choosing.

Once this is running, your trend research stops being a pile of tabs and becomes a real content pipeline. The workflow handles the repetitive parts so you can focus on what actually makes the video perform.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Launch login modal Launch register modal