📱 WordPress article summarization with GPT-4 and email broadcasting via Google Sheets
⚡ 349 views · 📱 Social Media & Email Marketing
Description
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
- Trigger: Starts on a schedule (e.g., daily at 9:00 AM).
- Fetch Blog Post: Retrieves the most recent post from a WordPress blog via HTTP Request.
- Extract Fields: A Set node extracts the title, link, and content.
- Summarize Article: OpenAI processes the article and returns a 3-point summary.
- Fetch Subscribers: Google Sheets reads email addresses from a subscriber list.
- Loop Emails: SplitInBatches and Send Email nodes loop through subscribers.
- 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
- Replace blog URL in HTTP Request node.
- Connect OpenAI API key.
- Link your Google Sheet with a column named Email.
- Set up Gmail or SMTP credentials.
- Run manually for testing, then activate schedule.
🔗 Nodes Used
Cron, Send Email, Google Sheets, HTTP Request, OpenAI
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File