Scheduled AI blog writer with images and auto-publishing

Deliverables

• Scheduled trigger reading a Google Sheets topic list
• Gemini writing agent for full articles
• Information extractor that structures title and body
• Hugging Face cover image generation and file conversion
• Publishing step that posts to the blog's API and updates the sheet

The challenge

A company blog only helps when it is updated regularly, but writing, formatting, sourcing an image and uploading each article is slow work. Posts get delayed, and the blog goes quiet for weeks at a time.

Our approach

A schedule trigger starts each run and reads the next row from Google Sheets. An AI agent on Google Gemini writes the full article. An information extractor, also running on Gemini, splits the output into clean fields such as title and body so the blog receives exactly what it expects. An HTTP request generates a cover image through Hugging Face, and the Base64 response is converted into an image file. A code step assembles the payload, an HTTP request posts the article to the blog's API, and the sheet row is updated with the result.