WordPress article summarization with GPT-4 and email broadcasting via Google Sheets
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Cron, OpenAI (legacy). 2 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| Cron Schedule Trigger | Schedule Trigger |
| OpenAI (legacy) Summarize with OpenAI | OpenAI node (AI section) |
Nodes used (7)
- Cron
n8n-nodes-base.cron - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
n8n-nodes-base.openAi - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Send Email
n8n-nodes-base.emailSend
What it does
This automation fetches the latest article from a WordPress blog, summarizes it using OpenAI, and sends the summary to a list of subscribers via email. Ideal for content creators and bloggers who want to distribute digestible content without manual effort. Use Case Perfect for: • Newsletter creators • Content marketers • Bloggers • Knowledge managers Nodes Used • Schedule Trigger • HTTP Request • Set • OpenAI • Google Sheets • Email (Gmail/SMTP) • IF • SplitInBatches Workflow Steps 1. Trigger: Starts on a schedule (e.g., daily at 9:00 AM). 2. Fetch Blog Post: Retrieves the most recent post from a WordPress blog via HTTP Request. 3. Extract Fields: A Set node extracts the title, link, and content. 4. Summarize Article: OpenAI processes the article and returns a 3-point summary. 5. Fetch Subscribers: Google Sheets reads email addresses from a subscriber list. 6. Loop Emails: SplitInBatches and Send Email nodes loop through subscribers. 7. Conditional Logic: IF node skips articles shorter than 300 words. Credentials Required • OpenAI API Key (for content summarization) • Google Sheets OAuth2 (to read subscriber emails) • Gmail or SMTP (for sending emails) Test Instructions 1. Replace blog URL in HTTP Request node. 2. Connect OpenAI API key. 3. Link your Google Sheet with a column named Email. 4. Set up Gmail or SMTP credentials. 5. Run manually for testing, then activate schedule.