Fully automate blog creation with GPT & publish to WordPress via Google Sheets

by Zakwan ✓ · 820 views · created 2025-08-29 · Content Creation, Multimodal AI

What this workflow does

This workflow has 42 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Google Sheets: uses Google Sheets
2. HTTP Google SERP (HTTP Request): calls an HTTP API
3. HTTP SearchVolume (HTTP Request): calls an HTTP API
4. HTTP Keyword Suggestions (HTTP Request): calls an HTTP API
5. HTTP Related Keywords (HTTP Request): calls an HTTP API
6. HTTP Keyword Ideas (HTTP Request): calls an HTTP API
7. HTTP Subtopics (HTTP Request): calls an HTTP API
8. HTTP Screenshot (HTTP Request): calls an HTTP API
9. HTTP Local Finder (HTTP Request): calls an HTTP API
10. Extract Organic (Code): runs custom JavaScript code

…plus 31 more steps. See the full node list below.

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (5)

• Manual Triggern8n-nodes-base.manualTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Mergen8n-nodes-base.merge

From the author

Creating high-quality, SEO-friendly blog posts consistently can be time-consuming. This template helps content creators, bloggers, SEO specialists, and agencies fully automate their blogging workflow. By combining AI content generation (GPT), Google Sheets…

View the original on n8n.io → Check your own copy