Taiki
Workflows by Taiki
Create YouTube shorts scripts from video links with Gemini AI and Telegram
 *disclaimer: This workflow contains community nodes that are only compatible with the self-hosted version of n8n.* ## Quick Summary This template automates the creation of YouTube Shorts scripts. Simply send a YouTube video URL to a Telegram bot, and this workflow will use AI (Google Gemini) to generate a script optimized for Shorts and send it back to you. It streamlines your content creation process by eliminating the manual work of transcribing and scriptwriting. ## Target Audience & Problem Solved This template is ideal for: - YouTube Content Creators - Social Media Marketers - Anyone looking to efficiently repurpose - - video content It solves the following problems: - Quickly creating engaging short-form video content from existing long-form videos. - Drastically reducing the time spent on video transcription, summarization, and scriptwriting. - Enabling content idea generation on the go, even from a smartphone without access to a PC. ## **Workflow Overview** This workflow automatically generates a script for YouTube Shorts using AI (Google Gemini) from a YouTube video URL received via Telegram, and then sends the result back to Telegram. The process is as follows: 1. **Receive URL**: A Telegram bot receives a YouTube video URL from a user. 2. **Get Transcript**: It uses the community node **`n8n-nodes-supadata`** to retrieve the video's transcript via the Supadata service. 3. **Generate Script**: Based on the retrieved transcript, Google Gemini creates a script (title and body) optimized for a YouTube Shorts video. 4. **Send Result**: The generated script is sent back to the user who sent the original URL via Telegram. ## **How to Use** 1. **Prerequisites**: * Install the `n8n-nodes-supadata` community node as described below. * Register your API keys for Telegram, Supadata, and Google Gemini as credentials in n8n. * Set the appropriate credentials in each node within the workflow. * For Telegram, create your bot with BotFarther. 2. **Execution**: * Activate the workflow. * Send a YouTube video URL to your configured Telegram bot. 3. **Confirmation**: * After a short while, the workflow will run automatically, and you will receive the completed script from the Telegram bot. ## Customization Guide You can tailor this template to your specific needs: - Modify the Prompt: Edit the prompt in the Google Gemini node to change the style of the generated script (e.g., make it more casual, use a specific tone, include emojis). - Change the AI Model: You can switch to other AI models like OpenAI. Simply add or replace the corresponding n8n node. - Change the Notification Channel: Replace the Telegram node with a Discord or Slack node to send the results to a different platform. ## **Community Node Installation** This workflow requires the **`n8n-nodes-supadata`** community node. Please install it using the following steps. ## **Installation from the n8n UI (Recommended)** 1. Navigate to `Settings` > `Community Nodes` in your n8n interface. 2. Click on `Install`. 3. Enter `n8n-nodes-supadata` in the input field and click the `Install` button.
Track top YouTube videos by view count with Google Sheets
## Workflow Setup Guide This workflow collects the most-viewed videos from specified YouTube channels and saves the data to a Google Sheet. Follow these steps to set it up: ## 1. Credentials Setup * **Google Sheets:** You need to have a Google Sheets credential configured in your n8n instance. If you don't have one, go to the 'Credentials' section in n8n and add a new credential for Google Sheets. * **YouTube API Key:** You need a YouTube Data API v3 key. 1. Go to the [Google Cloud Console](https://console.cloud.google.com/). 2. Create a new project or select an existing one. 3. Go to 'APIs & Services' > 'Library' and enable the **YouTube Data API v3**. 4. Go to 'APIs & Services' > 'Credentials', click 'Create Credentials', and choose 'API key'. 5. Copy the generated API key. ## 2. Google Sheet Setup You will need one Google Sheet with two separate sheets (tabs) inside it. ### Input Sheet Use [Template](https://docs.google.com/spreadsheets/d/1EwALToSWKp4EyzPCx4q3rhMHMaJ3MMfwXQoZmC2BWZk/edit?usp=sharing) This sheet provides the list of YouTube channels to process. * **Required Columns:** Create a sheet with the following two columns: * `ChannelID`: The ID of the YouTube channel (e.g., `T7M3PpjBZzw`). * `video_num_to_get`: The number of top videos to retrieve for that channel (e.g., `5`). ### Output Sheet This sheet is where the results will be saved. * **Required Columns:** The workflow will automatically append data to the following columns. You can create them beforehand or let the workflow do it. * `channelName` * `title` * `videoId` * `videoLink` ## 3. Node Configuration * **Read Channel Info from Sheet:** * Select your Google Sheets credential. * Enter your **Spreadsheet ID**. * Enter the **name of your Input Sheet**. * **Fetch Most-Viewed Videos via YouTube API:** * Replace `YOUR_YOUTUBE_API_KEY` with the API key you generated in Step 1. * **Append Video Details to Sheet:** * Select your Google Sheets credential. * Enter your **Spreadsheet ID** (the same one as before). * Enter the **name of your Output Sheet**.