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.