Generate SEO blog topics and articles with Google Sheets, OpenAI, and Claude
Ready for 3.0What this workflow does
This AI workflow has 21 nodes and runs on Google Sheets events (plus 2 other triggers). Along the way it connects OpenAI Chat Model, Google Sheets and Anthropic Chat Model. It also calls script.google.com over HTTP.
How it runs
Trigger: On Google Sheets events (plus 2 other triggers).
- Keep the newest row (Code): runs custom JavaScript code
- Get client details (Google Sheets): uses Google Sheets
- Get approved topics (Google Sheets): uses Google Sheets
- Loop over clients (Loop Over Items (Split in Batches)): loops over the items in batches
- Loop over topics (Loop Over Items (Split in Batches)): loops over the items in batches
- Pass the client through (Code): runs custom JavaScript code
- Get this client details (Google Sheets): uses Google Sheets
- Generate blog titles (AI Agent): runs an AI agent, with model: Chat model - Titles
- Write the article (AI Agent): runs an AI agent, with model: Chat model - Writing
- Review and refine titles (AI Agent): runs an AI agent, with model: Chat model - Review; output parser: Output Parser - Topic list
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: script.google.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger
From the author
Quick overview This workflow uses Google Sheets, OpenAI, Anthropic, and a Google Apps Script web app to generate blog topic ideas per client, save them for approval, and then turn approved topics into full HTML articles that are converted into Google Docs and…