Post daily AI-generated Instagram images from Google Sheets with GPT-4.1 Nano and Google Gemini

A fully automated n8n workflow that runs every day at 1:10 PM IST and publishes a fresh AI-generated image to Instagram — zero manual effort required after setup.

It reads content ideas from a Google Sheet, uses GPT-4.1 Nano to craft a cinematic image prompt and a niche-matched caption, generates the image with Google Gemini 2.5 Flash, uploads it to a public CDN called Upload to Url (https://uploadtourl.com) , posts it to Instagram, and logs everything back to the sheet.

---

✨ What This Workflow Does

1. Triggers daily at 1:10 PM IST via Schedule Trigger 2. Fetches a pending idea from a Google Sheet where Status = "Ready" 3. Generates an image prompt + caption using GPT-4.1 Nano — tailored to the niche's aesthetic (luxury, minimalist, vibrant, etc.) 4. Creates the image using Google Gemini 2.5 Flash Image model 5. Uploads the image to a public CDN via UploadToURL (https://uploadtourl.com) 6. Posts to Instagram as a feed post with the AI-generated caption 7. Updates the Google Sheet row with the prompt, caption, image URL, and status "Posted"

---

🛠 Tools & Services Used

| Tool | Purpose | |---|---| | n8n Schedule Trigger | Fires the workflow daily at 13:10 | | Google Sheets | Stores content ideas and tracks post status | | OpenAI GPT-4.1 Nano | Generates image prompts and Instagram captions | | Google Gemini 2.5 Flash Image | Generates the AI image from the prompt | | UploadToURL | Hosts the image on a public CDN | | Instagram Graph API | Publishes the image as a feed post |