Generate articles from Google Sheets to WordPress with web scraping and GPT-4 Mini
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects Google Sheets, OpenAI and Wordpress.
How it runs
Trigger: When an HTTP GET request hits its webhook URL.
- Get New Articles (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Update Processing (Google Sheets): update
- Fetch HTML (HTTP Request): calls an HTTP API
- If: checks a condition and branches into true / false
- Article Summarizer (OpenAI): uses OpenAI
- Update Error (Google Sheets): update
- Article Creator (OpenAI): uses OpenAI
- Format Article (Code): runs custom JavaScript code
- Create a Draft (Wordpress): uses Wordpress
…plus 1 more step. See the full node list below.
Services it uses
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 (8)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi - Wordpress
n8n-nodes-base.wordpress - Code
n8n-nodes-base.code - Webhook
n8n-nodes-base.webhook
From the author
🤖 Automated AI Article Generation from Google Sheets to WordPress 📝 Short Description Transform a Google Sheet into an automated content factory! This workflow reads article topics, scrapes source content, uses AI to create original articles, and publishes…