Auto-Summarize YouTube Videos and Update Airtable

Who It's For Content creators, marketers, and researchers who watch YouTube videos and need quick summaries stored in a database. What It Does This workflow checks Airtable for new YouTube video links every few minutes. It grabs the video's transcript using a RapidAPI service. Then, AI summarizes the transcript into a main idea and key takeaways. Finally, it updates the Airtable record with this info and marks it as done. It automates turning videos into organized content ideas. How to Set It Up 1. Copy this workflow into your n8n instance. 2. Add your Airtable token in the Airtable nodes. 3. Put your RapidAPI key in the transcript fetch node. 4. Link your OpenRouter API to the AI summary node. 5. Set the schedule trigger to your preferred interval, like every 5 minutes. 6. Test the workflow with a sample video link in Airtable. Requirements - n8n account with LangChain nodes enabled. - Airtable base with 'Ideas' table including fields: Status (checkbox), Type (single select), Source (URL), Main Idea (long text), Takeaways (long text). - RapidAPI key for YouTube transcript API. - OpenRouter credentials for AI summarization. Customization Change the summarization prompt in the AI node to match your style. Add more fields to update in Airtable. Adjust the Airtable filter for other content types. Modify the code nodes to handle different transcript formats. Key Technologies: n8n,Airtable,RapidAPI (YouTube Transcript API),LangChain Information Extractor,OpenRouter Chat Model (LLM) Automation Value: Saves hours of manual note-taking from videos. Keeps your content ideas auto-organized in Airtable without extra work. Uses AI to create high-quality summaries, so you focus on creating instead of watching. Processes multiple videos on a schedule, building a steady content pipeline. Best Practices: Filter Airtable queries tightly to process one item at a time and avoid rate limits. Test API keys and credentials before full runs to prevent failures. Customize the AI prompt for your niche to get better summaries. Add error handling in code nodes for bad video IDs or empty transcripts. Monitor schedule intervals to balance speed and API costs.