Publish AI-written newsletters and LinkedIn posts from WordPress with Gemini, Google Sheets and Gmail

Description

How it works
This workflow fetches the latest blog post from a WordPress API and checks against a Google Sheets tracker to prevent duplicate processing. If a new post is found, the workflow updates the tracker and cleans the blog data. The cleaned content is then sent to a Gemini-powered AI agent to generate a newsletter and LinkedIn teaser. Finally, the workflow distributes the content via LinkedIn and Gmail to subscribers.

Step-by-step

Detect new blog content**
Schedule Trigger – Runs the workflow automatically at intervals.
HTTP Request – Fetches the latest blog post from WordPress.
Last ID – Retrieves the last processed blog ID from Google Sheets.
If – Compares IDs to check if the blog is new.
Update Last ID – Updates the sheet with the latest blog ID.

Clean and generate AI content**
data cleanse – Cleans HTML, extracts title, content, and image.
AI Agent2 – Generates newsletter and teaser content.
Google Gemini Chat Model – Provides AI model for content generation.

Distribute content across channels**
Format Response – Parses and structures AI output.
Create a post – Publishes content on LinkedIn.
Email List – Fetches subscriber emails from Google Sheets.
Loop Over Items – Iterates through each recipient.
Send Email – Sends HTML newsletter via Gmail.

Why use this?
Automates end-to-end blog promotion workflow
Prevents duplicate publishing using ID tracking
Uses AI to generate engaging content instantly
Saves time on manual posting and emailing
Easily scalable for growing audiences