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