Post Google News headlines to Instagram images with GPT-4o-mini, PDF API Hub and Google Sheets

Description

Name

Auto-post Google News to Instagram with OpenAI, PDF API Hub & Google Sheets

Description

Automatically fetch trending news from Google News RSS, rewrite headlines into viral captions with OpenAI, generate branded breaking-news images using PDF API Hub's HTML-to-Image API, and publish directly to Instagram — all tracked in a Google Sheet.

How it works

Every hour, the workflow pulls the latest articles from Google News RSS for your chosen topic
New articles are deduplicated against a Google Sheet to avoid reposting
OpenAI (GPT-4o-mini) rewrites the headline into a short, high-impact viral caption
PDF API Hub converts a branded HTML template into a mobile-format breaking-news image
The image is published to Instagram, and the Google Sheet row is updated with the image URL and marked as posted

Set up steps

Create a Google Sheet with a tab named rss and add the required column headers (~2 min). See the sticky note inside the workflow for the exact structure.
Connect your four credentials: Google Sheets OAuth2, OpenAI API, PDF API Hub API, and Instagram API (~5 min)
Set your news topic in the Set Topic node (e.g. ai, crypto, sports)
Optionally customize the HTML/CSS in the Generate News Image node to match your brand
Activate the workflow