Publish YouTube videos to Twitter with database logging
Loading workflow…
Workflow Description
Automation that extracts video data from YouTube and posts them to Twitter in batches, while storing complete details in PostgreSQL for tracking, analytics, and campaign management across both platforms.
How it works
- 1.Trigger workflow manually or on schedule
- 2.Fetch video metadata from YouTube channel
- 3.Process and batch the video information
- 4.Post updates to Twitter account
- 5.Log transaction details in PostgreSQL database
Use cases
- Automatically share new YouTube videos with Twitter followers
- Track video performance metrics and social engagement
- Manage multi-platform content distribution efficiently
- Generate automated reports linking YouTube uploads to Twitter reach
Requirements
- Active YouTube channel with API access
- Verified Twitter/X account with app credentials
- PostgreSQL database configured and accessible
- API keys securely stored in n8n credentials
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (16)
Loop Over Items
Split In Batches
find_video_data1
HTTP Request
When clicking ‘Test workflow’
Manual Trigger
Execute Workflow Trigger
Execute Workflow Trigger
fetch_last_registered
Postgres
get_videos
You Tube
if_is_empty
If
Postgres
Postgres
insert_items
Postgres
remove_shorts
Code
create_query
Code
structure_data
Code
if_empty
If
already_populated
Set
map_data
Set
sanitize_data
Code
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Fresh workflows, straight to your inbox
Get newly published DROPIDEA workflows, a clear overview of what they do, and a link to explore them.
- New workflows
- Clear overviews
- Setup guides