Batu Öztürk
Workflows by Batu Öztürk
Summarize YouTube videos into structured content ideas with AI and Airtable
# Extract the main idea and key takeaways from YouTube videos and turn them into Airtable content ideas ## 📝 Description Automatically turn YouTube videos into clear, structured content ideas stored in Airtable. This workflow pulls new video links from Airtable, extracts transcripts using a RapidAPI service, summarizes them with your favourite LLM, and logs the main idea and key takeaways—keeping your content pipeline fresh with minimal effort. ## ⚙️ What It Does Scans Airtable for new YouTube video links every 5 minutes. Extracts the transcript of the video using a third-party API via RapidAPI. Summarizes the content to generate a main idea and takeaways. Updates the original Airtable entry with the insights and marks it as completed. ## 🛠 Prerequisites Before using this template, make sure you have: ✅ A RapidAPI account with access to the youtube-video-summarizer-gpt-ai API. ✅ A valid RapidAPI key. ✅ An OpenAI, Claude or Gemini account connected to n8n. ✅ An Airtable account with a base and table ready. ## 🧰 Setup Instructions Clone this template into your n8n workspace. Open the Get YouTube Sources node and configure your Airtable credentials. In the Get video transcript node: Enter your X-RapidAPI-Key under headers. The API endpoint is pre-configured. Connect your LLM credentials to the Extract detailed summary node. (Optional) Adjust the summarization prompt in the LangChain node to better suit your tone. Set your preferred schedule in the Trigger node. ## 📋 Airtable Setup Create a base (e.g., Content Hub) with a table named Ideas and the following columns: | Column Name | Type | Required | Notes | |-------------|------------|----------|----------------------------| | Type | Single select | ✅ | Must be set to Youtube Video | | Source | URL | ✅ | The YouTube video URL | | Status | Checkbox | ✅ | Leave empty initially; updated after processing | | MainIdea | Single line text | ✅ | Summary generated by OpenAI | | Key Takeaways | Long text | ✅ | List of takeaways extracted from the transcript Activate the workflow—and you're done!
📌 Turn your LinkedIn insights into content ideas with Airtable and Real-Time Linkedin Scraper
# 🚀 Transform LinkedIn Post Reactions into Content Ideas with Airtable ## 📝 Description This workflow helps you to turn your LinkedIn activity into a powerful content ideation engine. It captures your most recent post reactions on LinkedIn automatically, filters them based on recency, and structures the content into Airtable—ready for brainstorming, inspiration, or publication planning. ## ⚙️ What It Does - **Fetches** the latest liked posts from LinkedIn via a public API (***rapidapi.com/Real-Time Linkedin Scraper***). - **Filters** posts to include only those marked as your decided reaction and posted in the last 7 days. - **Extracts** the post text, author, links and more. - **Formats** the data into a database-friendly structure. - **Saves** the output in Airtable for easy tracking, tagging, or team collaboration. ## 💡 Use Cases - Build a **content idea vault** from posts you admire. - Capture inspiration from thought leaders. - Identify trends based on what you find insightful. - Supercharge your **personal brand or newsletter** by turning likes into learning. ## 🛠 Prerequisites Before using this template, make sure you have: 1. ✅ A [RapidAPI account](https://rapidapi.com/) and access to the `linkedin-api8` endpoint. 2. ✅ Your **RapidAPI key** and the target **LinkedIn username**. 3. ✅ An [Airtable account](https://airtable.com/) with a base/table set up. ## 🧰 Setup Instructions 1. Clone this template into your n8n instance. 2. Open the `Fetch LinkedIn Likes` node and enter: - Your LinkedIn username. - Your RapidAPI key in the headers. 3. Open the `Save to Airtable` node and: - Connect your Airtable account. - Link the correct base (`Content Hub`) and table (`Ideas`). 4. Set your desired schedule in the `Trigger` node. 5. Activate the workflow and you're done! ## 📋 Airtable Setup Create a base called `Content Hub` and a table named `Ideas` with the following columns: | Column Name | Type | Required | Notes | |-------------|------------|----------|----------------------------| | Title | Single line text | ✅ | Generated from author info | | Description | Long text | ✅ | Contains post content | | Source | URL | ✅ | Link to the original post | | Type | Single select | ✅ | Value: `Linkedin`