YouTube Video Optimization & Cross-Platform Distribution with GPT-4o

This n8n workflow automates the process of optimizing YouTube video metadata and distributing video content across multiple social media platforms, leveraging the power of OpenAI's GPT-4o for content generation. It streamlines the content publishing pipeline, ensuring consistent messaging and maximizing reach.

What it does

This workflow is designed to be triggered manually or on a schedule to process video data from a Google Sheet.

1. Triggers Manually/On Schedule: The workflow starts either manually or based on a pre-defined schedule (e.g., daily, weekly).
2. Fetches Video Data from Google Sheets: It reads video information (e.g., video title, description, keywords, platform-specific content) from a specified Google Sheet.
3. Generates Optimized Content with OpenAI (GPT-4o):
   • For each video, it sends the raw video data to OpenAI (GPT-4o).
   • GPT-4o generates optimized YouTube titles, descriptions, tags, and social media captions tailored for different platforms (Facebook, X/Twitter, LinkedIn, Email).
4. Updates Google Sheet: The generated optimized content is then written back to the Google Sheet, enriching the original video data.
5. Conditional Social Media Posting:
   • It checks for a "Post to Facebook" flag in the Google Sheet. If true, it posts the generated content to Facebook.
   • It checks for a "Post to X" flag. If true, it posts the generated content to X (formerly Twitter).
   • It checks for a "Post to LinkedIn" flag. If true, it posts the generated content to LinkedIn.
6. Sends Email Notification: It checks for an "Email Notification" flag. If true, it sends a personalized email via SendGrid with the video details and optimized content.
7. Posts to YouTube: It posts the video to YouTube using the generated optimized title, description, and tags.
8. Sends Slack Notification: Finally, it sends a Slack notification with a summary of the distributed content and any relevant links.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: Configured credentials for Google Sheets to read and write video data.
• OpenAI API Key: An API key for OpenAI (specifically for GPT-4o) to generate optimized content.
• Facebook Account: Configured credentials for Facebook Graph API to post content.
• X (formerly Twitter) Account: Configured credentials for X to post tweets.
• LinkedIn Account: Configured credentials for LinkedIn to post updates.
• SendGrid Account: Configured credentials for SendGrid to send email notifications.
• YouTube Account: Configured credentials for YouTube to upload or update videos.
• Slack Account: Configured credentials for Slack to send notifications.
• Pre-configured Google Sheet: A Google Sheet with columns for video details and flags for cross-platform distribution.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Go to the "Credentials" section in n8n.
   • Add or update credentials for Google Sheets, OpenAI, Facebook Graph API, X, LinkedIn, SendGrid, YouTube, and Slack.
3. Configure Nodes:
   • Schedule Trigger (ID: 839): Adjust the schedule as needed (e.g., daily, weekly, or set to "Manual" for manual execution).
   • Google Sheets (ID: 18):
     • Select your Google Sheets credential.
     • Specify the "Spreadsheet ID" and "Sheet Name" where your video data is stored.
     • Ensure the "Operation" is set to "Read Data" initially, and then "Update Row" for writing back.
   • OpenAI (ID: 1250):
     • Select your OpenAI credential.
     • Configure the prompt to instruct GPT-4o on how to generate optimized titles, descriptions, tags, and social media captions based on your Google Sheet data.
   • Edit Fields (Set) (ID: 38): Map the output from OpenAI to new or existing fields in your Google Sheet structure.
   • HTTP Request (ID: 19): This node might be used for custom API calls if needed (e.g., to a custom video hosting platform or another service not directly supported by an n8n node). Ensure its configuration matches the intended API.
   • If (ID: 20): Configure the conditions for each "If" node to check the boolean flags (e.g., {{ $json.postToFacebook }} for the Facebook branch).
   • Facebook Graph API (ID: 314):
     • Select your Facebook credential.
     • Configure the "Operation" (e.g., "Post") and map the generated content to the message/caption fields.
   • X (ID: 325):
     • Select your X credential.
     • Configure the "Operation" (e.g., "Tweet") and map the generated content to the tweet text.
   • LinkedIn (ID: 367):
     • Select your LinkedIn credential.
     • Configure the "Operation" (e.g., "Share Update") and map the generated content to the post text.
   • SendGrid (ID: 439):
     • Select your SendGrid credential.
     • Configure the sender, recipient, subject, and email body using the generated content.
   • YouTube (ID: 357):
     • Select your YouTube credential.
     • Configure the "Operation" (e.g., "Upload Video" or "Update Video") and map the optimized title, description, and tags.
   • Slack (ID: 40):
     • Select your Slack credential.
     • Configure the channel and message to send a summary notification.
   • Code (ID: 834): This node likely contains custom JavaScript logic for data manipulation or specific API interactions. Review and adjust the code if necessary.
   • Merge (ID: 24): This node combines the different branches after conditional processing. Ensure it's configured to merge data correctly.
4. Activate the Workflow: Once all credentials and nodes are configured, activate the workflow.
5. Run the Workflow:
   • If scheduled, it will run automatically.
   • For manual runs, click "Execute Workflow" in the n8n UI.

This workflow provides a robust solution for content creators and marketers to efficiently manage their YouTube presence and expand their reach across various platforms with AI-powered content optimization.