🎬 Repurpose YouTube videos into multichannel content with Gemini and Google Sheets
⚡ 108 views · 🎬 Content Creation & Video
💡 Pro Tip — YouTube’s API quotas can be a bottleneck when you’re pulling data at scale. ScraperNode is a community node with dedicated scrapers for channels, videos, and comments — no quota limits, just structured data.
Description
Quick overview
This workflow takes a YouTube video URL, fetches its transcript via RapidAPI, uses Google Gemini to generate multiple repurposed content assets, stores everything in Google Sheets, and automatically publishes the LinkedIn post while logging posted/failed status and any errors.
How it works
- Starts when a user submits a YouTube video URL through an n8n form.
- Requests the video transcript from the youtube-transcript3 RapidAPI endpoint and normalizes it into a single clean text block.
- Sends the transcript to Google Gemini to generate a JSON bundle containing a title, summary, blog article, LinkedIn post, X (Twitter) thread, newsletter, content ideas, hooks, and CTA suggestions.
- Parses and validates the Gemini response into consistent fields for downstream use.
- Appends the transcript and all generated content to Google Sheets (Sheet1) as a content database row.
- Publishes the generated LinkedIn post to your LinkedIn profile and updates the same Google Sheets row as Posted or Failed.
- Logs any errors from transcript fetching, AI generation/parsing, Google Sheets, or LinkedIn publishing to a Google Sheets “Errors” tab.
Setup
- Create a RapidAPI subscription for youtube-transcript3 and replace the x-rapidapi-key value with your RapidAPI key.
- Add Google Gemini (PaLM) API credentials in n8n and connect them to the Google Gemini Chat Model node.
- Create a Google Sheets spreadsheet with “Sheet1” and an “Errors” sheet using the exact headers shown in the workflow notes, then set your Google Sheet ID in all Google Sheets nodes.
- Add Google Sheets OAuth2 credentials in n8n with access to that spreadsheet.
- Add LinkedIn OAuth2 credentials in n8n and confirm the workflow is permitted to post to the target LinkedIn account.
Requirements
- I need an AI-powered content workflow that takes a YouTube URL, pulls the transcript automatically, and generates multiple content assets (blog, LinkedIn post, X thread, newsletter, hooks, CTAs) in one run.
- It should log all outputs into a Google Sheet as a structured content database and optionally auto-post to LinkedIn while tracking Posted/Failed status with error logs.
Customization
- I want the system to be customizable for different niches and tones, so I can tweak prompts or add extra output formats without changing the overall workflow logic.
- It should also let me plug in my own API keys and credentials inside n8n, without hardcoding any secrets in the workflow JSON.
Additional info
This is built as an n8n workflow that starts from a form (YouTube URL input), calls a transcript API, uses a Gemini model node, and writes to Google Sheets plus LinkedIn.
I’m comfortable editing nodes, expressions, and environment variables myself, so a clean template without bound credentials is actually preferred.
🔗 Nodes Used
Google Sheets, HTTP Request, LinkedIn, Basic LLM Chain, n8n Form Trigger, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File