Google Drive → OnlySocial API → YouTube Autoposter
Goal: Build a fully automated, online-only system that:
Realtime mode – Instantly posts any new video that appears in my Google Drive folder(s) to all my connected YouTube channels via the OnlySocial API.
Endless backlog loop – Continuously cycles through hundreds of existing videos in my Drive, posting them to all channels. When it reaches the end, it automatically starts over from the beginning so the feed never stops.
Auto-onboarding – Automatically detects any new YouTube channels I connect to OnlySocial and starts posting to them immediately (if auto-enroll is ON).
Simultaneous posting – When a video is posted, it should publish to all enrolled channels at the same time.
Dashboard – Web dashboard with ON/OFF toggle, recent post history, and channel list.
Per-folder mapping – Assign specific Drive folders to specific YouTube channels or groups.
Playlist assignment – Option to assign uploaded videos to a specific YouTube playlist per channel.
Caption support – If an .srt caption file is in Drive with the same name as a video, it should be uploaded with the video.
Inputs I already have
A Google Drive folder (and possibly multiple folders) that automatically receive finished MP4 videos.
Each video already includes:
Title – use as the YouTube video title.
Hashtags – use as the YouTube video description.
My OnlySocial workspace UUID and API token.
My YouTube channels are already connected to OnlySocial.
What the system must do
1. Detect videos
Realtime mode: Watch the Drive folder(s) for new videos; when a file appears, post it immediately or at the next available slot.
Backlog mode: Index all existing videos in the Drive folder(s) and post them in order across all channels.
2. Endless Cycle Mode
After all videos have been posted to all channels, reset the queue and start posting them again from the beginning.
Continue cycling indefinitely.
Apply a configurable cooldown so the same video isn’t reposted to the same channel until X days have passed (or 0 days for no delay).
3. Post to YouTube via OnlySocial API
Upload the video bytes to OnlySocial.
Create a post with correct YouTube title, description, and visibility.
Approve immediately or schedule according to posting rules.
API docs: https://api.onlysocial.io
4. Simultaneous Posting
When a video is selected (either from realtime or backlog), it must be posted to all enrolled YouTube channels in the same run.
Handle large channel counts (50–200+) by posting in parallel.
Retry failures per channel without delaying others.
Prevent duplicates to the same channel inside the cooldown period.
5. Distribution rules
Daily caps: e.g., max 2 posts per channel/day (0 or high number = publish everything now).
Cooldown: Prevent reposting the same video to the same channel until X days pass.
Optional posting windows (e.g., 11:00, 15:00, 19:00 Pacific).
Posting can be simultaneous — no staggering needed.
6. Auto-onboarding
Poll OnlySocial to find all connected accounts where provider == "youtube".
Any new accounts not in the system:
If Auto-Enroll = ON, add immediately to the posting pool with default caps/windows/visibility.
If Auto-Enroll = OFF, list them as pending until I approve.
7. Dashboard Requirements
ON/OFF master toggle for entire system.
List of all connected channels with current status (active/pending).
Recent post history with video name, channel, publish time, and status.
Manual requeue button for failed posts.
8. Per-folder Mapping
Ability to map specific Google Drive folders to specific YouTube channels or channel groups.
9. Playlist Assignment
Ability to set a default YouTube playlist per channel or per mapped folder.
Any video from that folder automatically gets added to that playlist.
10. Caption Support
If a .srt caption file exists in the same Drive folder with the same base filename as a video, upload it with the video to YouTube.
11. Error handling
Retry failed uploads/posts automatically with backoff.
Email/Slack me if a file repeatedly fails.
Prevent duplicate posting of the same Drive file to the same channel.
Configurable settings
Auto-Enroll new channels: ON/OFF
Per-channel daily posting cap
Posting time windows and quiet hours (optional)
Cooldown period before a video can repeat on the same channel
Default YouTube visibility (public/unlisted/private)
Optional standard CTA text to append to descriptions
Technical requirements
Runs 100% online (Pipedream, Make.com, Zapier, n8n Cloud, or custom serverless on AWS/Vercel).
Stores API credentials securely.
Logs every action: file seen → uploaded to OnlySocial → post created → approved/published.
Maintains a queue of pending posts per channel.
Idempotent – same Drive file is never double-posted to the same channel within the cooldown.
Acceptance criteria
Realtime: Drop a new video in Drive → all enrolled channels publish it via OnlySocial within minutes (or next slot).
Endless loop: With no new videos, the system keeps cycling through backlog videos indefinitely.
Auto-onboarding: Connect a new YouTube channel in OnlySocial → it’s auto-enrolled and posts on the next run (if auto-enroll ON).
Simultaneous: All channels receive the same post in the same run.
Dashboard: Fully functional with ON/OFF toggle, channel list, and post history.
Mapping: Specific Drive folders route to specific channels/groups.
Playlists: Videos are added to correct playlists automatically.
Captions: .srt files are uploaded with their videos when available.
Control: Turning OFF stops all posting but preserves queues.
Safety: No duplicates on the same channel within cooldown.
Logs: Per-channel results for each post.
Deliverables
Fully functional, cloud-hosted automation.
All credentials and settings documented.
Brief screen recording showing all features working end-to-end.
Workflow export or source code.
What to include in your proposal
Platform you recommend (Pipedream, Make, custom, etc.) and why
How you’ll parse title, hashtags, and handle captions from Drive files
Estimated time to deliver (must be 1–2 days max for MVP)
Apply tot his job
Apply To this Job