Repurpose YouTube videos into weekly LinkedIn and Bluesky posts with Gemini and PostWire

Description

Quick Overview
This workflow collects a YouTube link via an n8n form, uses Google Gemini to extract a summary and daily takeaways from the video, then uses PostWire to generate and schedule a week of LinkedIn and Bluesky posts, logging results to Google Sheets and emailing the plan via Gmail.

How it works
Receives a submission from an n8n form with a YouTube URL, optional posting angle, and the number of days to generate.
Extracts the YouTube video ID from the submitted URL and stops if the URL is not a valid YouTube link.
Calls the Google Gemini API with the YouTube video URL to return a JSON brief containing a title, short summary, a takeaway for each day, and an optional direct quote.
Sends the brief to PostWire to generate platform-specific posts in your brand voice and schedule one post per day to LinkedIn and Bluesky.
If scheduling succeeds, writes one row per queued post into Google Sheets and emails you the full weekly schedule with a link to the PostWire queue.
If Gemini cannot extract takeaways or PostWire fails to schedule, logs the failure to Google Sheets and emails you the error details and what to fix.

Setup
Create a PostWire account, connect your LinkedIn and Bluesky profiles, install the PostWire community node in n8n, and add a PostWire API credential.
Add a Google Gemini (Google PaLM) API credential for the Gemini HTTP request.
Connect a Gmail account in n8n for sending the plan/failure emails, and update the recipient email plus the “brand voice” and posting hour values.
Create a Google Sheet with columns date, video, title, goes_out, status, post, link, and note, then select the target document and sheet in both Google Sheets nodes.