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

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