n8n Workflow: AI-Powered Video Social Media Content Generation and Client Approval

This n8n workflow automates the process of generating social media copy for videos using AI, obtaining client approval, and preparing the content for publishing. It streamlines content creation, ensuring brand consistency and efficient review cycles.

What it does

This workflow performs the following key steps:

1. Triggers Manually (or via Schedule/Form): The workflow can be initiated manually, on a schedule (e.g., daily, weekly), or upon a form submission.
2. Reads Video Data from Google Sheets: It fetches video details (likely including video URLs, topics, or other relevant information) from a specified Google Sheet.
3. Filters for Approved/Pending Videos: It checks a condition (presumably a status field like "Approved" or "Pending" in the Google Sheet) to determine which videos need processing.
4. Loops Through Videos: For each video item, it processes them in batches.
5. Generates Social Media Copy with AI: It uses an AI Agent (likely powered by Google Gemini) to generate social media copy based on the video data. This involves:
   • AI Agent: Orchestrates the AI content generation process.
   • Google Gemini Chat Model: The core AI model used for generating conversational and creative copy.
   • Structured Output Parser: Ensures the AI output is formatted correctly (e.g., JSON) for easy parsing and use in subsequent steps.
6. Prepares Data for Approval: It likely formats the generated AI copy and video details into a structured format suitable for client review.
7. Saves Generated Content to Google Drive: Stores the generated social media copy or related assets in Google Drive.
8. Updates Google Sheet: Updates the Google Sheet with the generated copy, status, or other relevant information.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance (cloud or self-hosted).
• Google Sheets Account: Configured credentials for Google Sheets to read and write video data.
• Google Drive Account: Configured credentials for Google Drive to store generated content.
• Google Gemini API Key/Access: Credentials or access to the Google Gemini AI model for content generation.
• Basic understanding of n8n: Familiarity with connecting nodes and configuring credentials.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credentials.
   • Set up your Google Drive credentials.
   • Configure your Google Gemini credentials.
3. Configure Nodes:
   • Google Sheets (Read): Specify the spreadsheet ID and sheet name where your video data is located. Ensure your sheet has columns for video URLs, topics, and a status field (e.g., "Status").
   • If: Adjust the condition to match your status field (e.g., {{ $json.status === 'Pending' }}).
   • AI Agent & Google Gemini Chat Model: Review the prompts and configurations to ensure the AI generates the desired social media copy. The "Structured Output Parser" should be configured to parse the AI's output into a usable format.
   • Edit Fields (Set): Adjust this node to format the data as needed before saving or updating.
   • Google Drive: Configure the folder where you want to save the generated content.
   • Google Sheets (Write): Update this node to write the generated social media copy and potentially update the video's status (e.g., to "Ready for Review") back to your Google Sheet.
4. Activate the Workflow: Once configured, activate the workflow. You can run it manually, set up a schedule using the "Schedule Trigger" node, or integrate it with a form using the "n8n Form Trigger" node.

This workflow provides a robust foundation for automating your video social media content pipeline, leveraging AI for efficient copy generation and integrating client approval steps.