{"product_id":"automate-science-newsletters-youtube-to-ghost-with-n8n","title":"Automate Science Newsletters: YouTube to Ghost with n8n","description":"\u003ch3\u003eAutomate Science Newsletters: YouTube to Ghost with n8n\u003c\/h3\u003e\n\n\u003cp\u003eTransform your newsletter creation process with an intelligent, end-to-end workflow that automates the conversion of trending science topics into captivating Ghost posts. Harness the power of n8n, Apify, Brave Search, and Cohere to streamline content gathering and creation, all while reducing manual effort and improving accuracy.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBegin with a Google Sheets filled with science-related keywords. Manually qualify keywords or let the workflow schedule take over the automation.\u003c\/li\u003e\n  \u003cli\u003eLeverage Brave Search with an advanced LLM agent to analyze each keyword's relevance, domain, and context, updating Google Sheets with the findings.\u003c\/li\u003e\n  \u003cli\u003eWhen triggered, select a keyword, use Apify's YouTube Scraper to locate relevant videos, and log potential video candidates into a Candidate Videos sheet, focusing on English transcript content.\u003c\/li\u003e\n  \u003cli\u003eEvaluate each video's viral potential based on views, engagement, and channel metrics, categorizing them as VIRAL or NOT VIRAL, with non-viral entries archived.\u003c\/li\u003e\n  \u003cli\u003eEmploy an editorial LLM agent for an in-depth review of VIRAL videos, selecting one credible video to explore further or determining that no video meets the criteria.\u003c\/li\u003e\n  \u003cli\u003eFor the chosen video, compile 5–8 supplementary sources using Brave Search and perform text extraction with Jina AI, then embed these sources into Qdrant for robust content synthesis.\u003c\/li\u003e\n  \u003cli\u003eCreate an engaging Ghost draft using the video's transcript and enriched data from Qdrant, getting it ready to attract your audience.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eContent creators looking to automate their newsletter production by efficiently integrating multimedia content.\u003c\/li\u003e\n  \u003cli\u003eScience communicators aiming to quickly publish up-to-date information derived from trending topics and trustworthy sources.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who need an automated content pipeline to enhance user engagement and retention.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eUtilizes Google Sheets for keyword management and status updates.\u003c\/li\u003e\n  \u003cli\u003eApify's YouTube Scraper fetches videos with comprehensive metadata.\u003c\/li\u003e\n  \u003cli\u003eIntegration of Brave Search utilizing LLM agents for thorough contextual research.\u003c\/li\u003e\n  \u003cli\u003eEmploy Jina AI for text extraction, and store source data in Qdrant using Cohere embeddings.\u003c\/li\u003e\n  \u003cli\u003eLeverages Ghost's HTTP endpoints for seamless publication draft handling.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eEmbrace automation excellence with the \"Automate Science Newsletters: YouTube to Ghost with n8n\" workflow, designed for users who crave efficiency, precision, and quality content curation.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45593475449011,"sku":"N8N-16586","price":33.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/qtFP-vPLsF6pSjf3NE4kT_9c493072a4ff42f6bfb01630cc3a2a88.jpg?v=1782291757","url":"https:\/\/buyflowscripts.com\/products\/automate-science-newsletters-youtube-to-ghost-with-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}