AutomationMart
Home/Browse/Batch archive TikTok videos from links in Google Sheets to Google Drive
Make.com

Batch archive TikTok videos from links in Google Sheets to Google Drive

Make.comMake.com22 modulesv1.0
Google SheetsGoogle Drive

This template helps you archive TikTok videos from a Google Sheets list into Google Drive in an organized way. How it works Reads rows from the Tasks sheet where status = PENDING and tiktok_url is not empty. Calls the Apify Actor liul/tiktok-video-audio-downloader to fetch video metadata and a downloadable video URL. Downloads the video and uploads it to Google Drive into a daily subfolder named YYYY-MM-DD under your chosen parent folder. Generates a shareable link for the uploaded file. U

At a glance

Batch archive TikTok videos from links in Google Sheets to Google Drive is a ready-made Make.com workflow you import as a blueprint JSON file — no build required. It connects Google Sheets, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
Make.com
Connects
Google Sheets, Google Drive
Modules
22
Price
Free
Version
v1.0

About this workflow

This template helps you archive TikTok videos from a Google Sheets list into Google Drive in an organized way.

How it works

Reads rows from the Tasks sheet where status = PENDING and tiktok_url is not empty.

Calls the Apify Actor liul/tiktok-video-audio-downloader to fetch video metadata and a downloadable video URL.

Downloads the video and uploads it to Google Drive into a daily subfolder named YYYY-MM-DD under your chosen parent folder.

Generates a shareable link for the uploaded file.

Updates the same row in Google Sheets with:

title (video title)

author (creator nickname)

drive_link (Google Drive link)

status (DONE on success / ERROR on failure)

error_message (only when failed)

What you need to set up

Apify connection (API token)

Google Drive connection and a parent folder for daily archives

A Google Sheet with these columns (header names must match):

tiktok_url, status, title, author, drive_link, error_message

Google Sheets template (recommended)

Make a copy: https://docs.google.com/spreadsheets/d/1gQ7Fi0NC7nHiAnvJt7MSEYSuQ23qih5XmM9VkFcxjlA/copy

Preview (view-only): https://docs.google.com/spreadsheets/d/1gQ7Fi0NC7nHiAnvJt7MSEYSuQ23qih5XmM9VkFcxjlA/edit?usp=sharing

Please do not rename the column headers.

Notes

If you don’t see updates immediately in Google Sheets, refresh the page.

Only archive content you own or have permission to save.

Make.com

How to import this Make.com workflow

  1. 1

    Download the blueprint JSON file after purchase.

  2. 2

    Open Make.com → go to Scenarios → click Import Blueprint.

  3. 3

    Select the downloaded JSON file and confirm.

  4. 4

    Connect your app credentials in each module.

  5. 5

    Run once manually to test, then activate the schedule.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related Make workflows

AI content creation and auto WordPress publishing with Pexels API image workflow

AI powered content creation and WordPress publishing workflow Summary This workflow automates the entire process of blog content creation, from idea generation and article writing using Google Gemini, to sourcing images from Pexels and publishing directly to your WordPress site. It uses Google Sheets as a central hub for managing content ideas and tracking their status, all orchestrated through interactive n8n forms. Key features AI driven content: Leverages Google Gemini

Free

Add new Inoreader articles to Google Sheets as rows

Stay organized and never miss important updates by automatically tracking articles from Inoreader and logging them into Google Sheets. With this template, every time a new article is published in your Inoreader feed, Make will seamlessly add a new row in your Google Sheets, allowing you to maintain a comprehensive archive of articles for easy reference and analysis. Perfect for researchers, content curators, or anyone looking to streamline their reading list!

Free

Calculate Bonusly monthly points in Google Sheets

Make will list all Bonusly users and count their number of bonuses for a given time interval. Then, the result is saved in Google Sheets. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1GaTXiFveA5IwgJfotRKaZkM3fOywYAU4AndzTECZ7ME/edit?usp=sharing).

Free

Remove XMP tags from files in Google Drive

Every time a new file is uploaded to a specific folder in Google Drive, Make automatically removes the specified tag and uploads the file to another folder. The original file will be deleted from the original folder. Files where tags are not available (e.g. DOCX) will be ignored.

Free

Generate content in Google Docs using data from Google Sheets range values and ChatGPT

Get your Google docs generated on autopilot using data from Google Sheets range values and ChatGPT. Streamline document creation by integrating AI-driven insights with spreadsheet data.

Free

BrowserAct Flipboard News Scraper & Google Sheets Sync

This template provides a fully automated workflow for collecting news from Flipboard and saving it into Google Sheets. The process starts with BrowserAct, which opens the Flipboard page, scrolls through the content, and extracts each article’s title, summary, reference link, and image. The raw output is then parsed through a JSON module to convert the data into a clean, structured format. Next, the workflow creates a new sheet named with the completion timestamp, ensuring each run is organized a

Free

Create opportunities in Salesforce from new Stripe charges

This scenario instantly receives new charges from Stripe and creates opportunities in Salesforce automatically.

Free

Create JIRA Cloud Platform issues from new Zendesk tickets (with attachments)

Use this template to automatically create a JIRA Cloud Platform issue when a new Zendesk ticket is created (including attachments). The attachments have to be linked to the first ticket comment. Please note that you have to disable the secure downloads option in the Zendesk tickets settings (section Attachments).

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with Make.com

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free