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