YouTube Transcript Summarizer to Airtable

• Automated Airtable Integration: Connects to Airtable to find new YouTube video entries and update them with summarized content.
• YouTube Transcript Extraction: Utilizes a RapidAPI service to fetch transcripts from YouTube video URLs.
• AI-Powered Summarization: Employs a LangChain node (presumably powered by an LLM) to distill the transcript into a concise main idea and a list of key takeaways.
• Customizable Prompting: Allows for fine-tuning the summarization prompt within the LangChain node to match specific output requirements.
• Scheduled Execution: Configurable with a schedule trigger to run periodically (e.g., every 5 minutes) to keep content ideas fresh.
• Error Handling (Implicit): While not explicitly detailed, n8n's design generally supports error handling and retries for robust execution.

1. Clone Workflow: Import this workflow JSON into your n8n instance.
2. Configure Airtable: Set up your Airtable credentials for both reading new video ideas (Airtable node) and updating them (Update Airtable node). Ensure the Content Hub base and Ideas table are correctly configured.
3. RapidAPI Key: In the Get video transcript node, replace {YOUR-API-KEY} with your actual RapidAPI key for the YouTube Video Summarizer service.
4. LangChain Integration: Connect your preferred LLM credentials to the Extract detailed summary node. You may need to configure specific LLM parameters based on your chosen provider.
5. Customize Prompt (Optional): Adjust the text parameter in the Extract detailed summary node to refine the summarization instructions and output format. The provided JSON schema example in the node helps guide its structure.
6. Set Schedule: Configure the Schedule Trigger node to run the workflow at your desired frequency (e.g., every 5 minutes).
7. Activate Workflow: Enable the workflow by setting its status to 'active'.

Node Explanations:

• Schedule Trigger: Initiates the workflow based on a defined schedule.
• Airtable: Searches Airtable for new YouTube video ideas with an empty 'Status' and 'Youtube Video' type.
• Get Video ID: Extracts the unique YouTube video ID from the 'Source' URL.
• Get video transcript: Calls the RapidAPI to fetch the raw transcript of the YouTube video.
• Get All Transcripts: Prepares the transcript data for combining.
• Combine Transcripts: Concatenates all transcript segments into a single text block.
• Get Full Transcript: Sets the combined transcript as a variable.
• Extract detailed summary: Uses a LangChain node to process the transcript and generate a 'Main Idea' and 'Key Takeaways' based on the provided prompt and schema.
• Get Main Idea & Key Takeaways: Extracts the generated 'Main Idea' and 'Key Takeaways' from the LLM output.
• Update Airtable: Updates the original Airtable record with the generated 'Main Idea' and 'Key Takeaways', and sets the 'Status' to true (or a processed state).