Daily Google Trends Image Posts with OpenAI + PostWire (n8n)

Turn Google Trends into daily image social posts—automatically

This n8n workflow pulls fresh Google Trends every morning, uses OpenAI to pick the best on-brand trend and write captions, generates a 1024×1024 image with GPT Image, and publishes to Instagram, TikTok, and Facebook via PostWire—while logging results to Google Sheets and alerting you by Gmail if anything fails.

What this workflow does

• Runs daily at 8:00 via a schedule.
• Reads Google Trends RSS for your chosen country, removes trends already used in previous executions, and keeps the top 10.
• Uses OpenAI for selection + content: sends the trend list and your brand details to OpenAI to either reject all trends or return a JSON plan (chosen trend, angle, image prompt, and per-network captions).
• Creates and publishes an image: if a relevant trend is selected, requests an upload slot from PostWire, generates a 1024×1024 image with GPT Image, uploads it to PostWire, and retrieves a public media URL.
• Publishes to multiple platforms: posts to Instagram, TikTok, and Facebook through PostWire using per-platform captions and an idempotency key based on date + trend.
• Tracks everything: appends the trend, angle, status, and post links to Google Sheets, and sends a Gmail alert with fixes when any platform fails.

Use cases

• SaaS and content teams that want consistent, trend-driven social posting without daily manual work.
• Automation engineers building an OpenAI + social publishing pipeline that includes retries, idempotency, and failure notifications.
• Brands that need a controlled, on-brand approach to trending topics using Google Trends RSS.

Technical details

• n8n scheduling, filtering, and decision logic (if, limit, aggregate, set, sticky note)
• Google Trends RSS input
• OpenAI for trend selection + captions and GPT Image for image generation
• PostWire publishing with HTTP Header Auth: Authorization: Bearer <your PostWire API key>
• Google Sheets logging and Gmail alerts