WordPress article summarization with GPT-4 and email broadcasting via Google Sheets

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.