On a schedule
Publish one video a day from a Drive folder
One video from your Drive queue folder is published at the same time every day, and you get an email confirming it.
- Runs
- On a schedule
- Apps
- Google Drive, YouTube
- AI
- Not needed
- Access
- Drive read+write; YouTube youtube.upload
Send this to your assistant
Create a ClickRuntime automation: every day at 5pm, take the oldest video in my Queue folder in Drive, upload it to YouTube using the file name as the title, move it to my Done folder and email me the link.
First time? Adding ClickRuntime to your assistant takes about two minutes.
Why use it
Why teams use this automation
A creator batch-records a month of videos in one weekend. Publishing them on a steady schedule means remembering to upload one every day for four weeks, which falls apart the first time they travel.
A Drive folder that releases one video a day keeps the schedule going for as long as the queue lasts, with nothing to remember.
What you get out of it
Batch-record, release steadily
Film everything in one go and let the queue release a video a day.
A consistent time slot
Videos go out at the same hour, when your audience is most active.
Easy to see what is left
The queue folder shows how many days of videos you have in hand.
A confirmation every day
An email with the link confirms each release, so a missed day never goes unnoticed.
How it works
What happens, step by step
Every day at the time you set, ClickRuntime takes the oldest video in your Drive queue folder.
It uploads the video to YouTube, using the file name as the title.
The file is moved to your Done folder so it is not used again.
You get an email with the video link and how many videos are left in the queue.
Before it runs live
- Connect Google Drive
- Connect YouTube
What you get
Build your own
Need it to work differently?
Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.
Changes you can ask for
- Run it at a different time, more or less often, or only on weekdays
- Add an AI step, for example to summarize, sort or draft a reply
- Add another app, for example also send it to Slack
- Combine it with other Google Drive and YouTube steps into one automation
Under the hood
The code that runs this automation
import io
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from googleapiclient.http import MediaIoBaseUpload
import os
from clickruntime import on_trigger, credentials, notify
def api(name, version):
return build(name, version, credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
QUEUE, DONE = "queue-folder-id", "done-folder-id"
@on_trigger
def run(event):
drive = api("drive", "v3").files()
files = drive.list(q=f"'{QUEUE}' in parents and mimeType contains 'video/' and trashed=false",
orderBy="createdTime", fields="files(id,name)").execute()["files"]
if not files:
notify.email_me("YouTube queue is empty", "Add more videos to the Queue folder in Drive.")
return {"uploaded": False}
f = files[0]
title = os.path.splitext(f["name"])[0][:100]
media = MediaIoBaseUpload(io.BytesIO(drive.get_media(fileId=f["id"]).execute()), mimetype="video/mp4", resumable=True)
video = api("youtube", "v3").videos().insert(part="snippet,status", media_body=media,
body={"snippet": {"title": title}, "status": {"privacyStatus": "public"}}).execute()
drive.update(fileId=f["id"], addParents=DONE, removeParents=QUEUE).execute()
notify.email_me(f"Published: {title}", f"https://youtu.be/{video['id']}\n{len(files) - 1} videos left in the queue.")
return {"uploaded": video["id"], "left": len(files) - 1}FAQ
Common questions
In what order are videos released?
What happens when the queue is empty?
Can it schedule videos in YouTube instead?
What permissions does it need?
Does it need AI?
How many runs does it use?
Can I change how it works?
Related
You might also like
Rotate your YouTube channel banner from a Drive folder
Your channel banner changes on the schedule you set, using the next image in a Drive folder.
See how it worksPublish rendered videos from Drive to YouTube
Videos your editing or AI video tool saves to Drive are uploaded to YouTube with a title and description, then moved to a Published folder.
See how it worksUpload Drive videos to YouTube with AI titles, descriptions and tags
Drop a video into a Drive folder and it goes to YouTube with a search-friendly title, description and tags, and you get the link by email.
See how it worksKeep exploring
Set up “Publish one video a day from a Drive folder” from your assistant
Copy the prompt above, or connect your assistant first. Free plan, no credit card.