Workflow overview
Why this workflow matters
Potentially useful as a reusable automation building block.
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 AlekSystem 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 AlekSystem 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 AlekSystem with access to that spreadsheet. Add LinkedIn OAuth2 credentials in AlekSystem 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 AlekSystem, without hardcoding any secrets in the workflow JSON. Additional info This is built as an AlekSystem 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.
Best fit
Categories
Services
Use cases
Need another direction?