Publish science newsletter posts from YouTube using Ghost and Google Sheets
UnknownWhat this workflow does
This AI workflow has 103 nodes and runs manually, when you click “Execute workflow” (plus 5 other triggers). Along the way it connects Google Sheets, OpenAI Chat Model, Anthropic Chat Model and Redis Chat Memory and 9 more. It also calls api.cohere.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 5 other triggers).
- Global Constants: uses Global Constants
- Global Constants: uses Global Constants
- Global Constants: uses Global Constants
- Global Constants: uses Global Constants
- Global Constants: uses Global Constants
- Global Constants: uses Global Constants
- Get Keywords (Google Sheets): uses Google Sheets
- Get Keywords (Google Sheets): uses Google Sheets
- Get YouTube Videos (Google Sheets): uses Google Sheets
- Get YouTube Videos (Google Sheets): uses Google Sheets
…plus 64 more steps. See the full node list below.
Services it uses
HTTP calls to: api.cohere.com
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 5 community packages, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-globals is verified or supports 3.0 (used in Global Constants, Global Constants5, Global Constants7).
- Check that @brave/n8n-nodes-brave-search is verified or supports 3.0 (used in Brave Search2, Brave Search3).
- Check that n8n-nodes-qdrant is verified or supports 3.0 (used in Delete Old Qdrant Collection, Qdrant Upsert).
- Check that @brave/n8n-nodes-brave-search is verified or supports 3.0 (used in Brave Search).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Run an Actor and get dataset).
Rarely used nodes in this template: @n8n/n8n-nodes-langchain.lmChatMoonshot
Nodes used (26)
- Manual Trigger
n8n-nodes-base.manualTrigger - Global Constants
n8n-nodes-globals.globalConstants - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Redis Chat Memory
@n8n/n8n-nodes-langchain.memoryRedisChat - Mistral Cloud Chat Model
@n8n/n8n-nodes-langchain.lmChatMistralCloud - Brave Search Tool
@brave/n8n-nodes-brave-search.braveSearchTool - Jina AI
n8n-nodes-base.jinaAi - Qdrant
n8n-nodes-qdrant.qdrant - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Qdrant Vector Store
@n8n/n8n-nodes-langchain.vectorStoreQdrant - Embeddings Cohere
@n8n/n8n-nodes-langchain.embeddingsCohere - Brave Search
@brave/n8n-nodes-brave-search.braveSearch - Merge
n8n-nodes-base.merge - Sort
n8n-nodes-base.sort - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Apify
@apify/n8n-nodes-apify.apify - Webhook
n8n-nodes-base.webhook - If
n8n-nodes-base.if - Moonshot Kimi Chat Model
@n8n/n8n-nodes-langchain.lmChatMoonshot
From the author
Quick overview This workflow turns science keywords from Google Sheets into researched Ghost newsletter posts by discovering and screening YouTube videos with Apify, validating claims using Brave Search, storing sources in Qdrant with Cohere embeddings,…