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