WordPress Article Summarization with GPT-4 and Email Broadcasting via Google Sheets

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.