Publish Instagram Carousels from Google Sheets (n8n)

Turn Google Sheets requests into fully published Instagram carousels—automatically

This n8n workflow reads your queued carousel ideas from Google Sheets, uses Google Gemini to generate the concept, caption, and 5–6 slide prompts, creates square slide images, uploads them to Google Cloud Storage, and publishes the finished Instagram carousel via the Meta Graph API—then logs the results and emails you confirmation.

What this workflow does

• Runs daily at 12:00 using a schedule trigger.
• Selects the next queued row in Google Sheets where Pick = 1 and the row is not marked Published or Processing; then updates the row status to Processing.
• Generates carousel content with Google Gemini: creates a structured concept, an Instagram caption, and a structured set of exactly 5–6 slides.
• Creates slide images: generates an image prompt per slide with the Gemini image API, converts each result to a file, and resizes slides to 1080×1080.
• Publishes to Instagram via Meta Graph API: uploads each slide to a public Google Cloud Storage bucket, creates Instagram carousel child containers for each image, polls until children finish, then polls the carousel parent container until completion.
• Updates Google Sheets + sends email: writes Published status and carousel IDs/URLs back to the originating row and sends a confirmation via Gmail.

Use cases

• SaaS and content teams queue weekly Instagram carousel ideas in Google Sheets and publish without manual design.
• Automation engineers want a reliable n8n pipeline for Instagram carousel publishing driven by structured inputs.
• Operators streamline approvals by marking Pick = 1 for ready-to-publish rows.

Technical details

• Integrations: Google Sheets, Google Gemini (text + image generation), Google Cloud Storage, Meta Graph API (Instagram publishing), Gmail.
• Core n8n logic includes nodes such as if, set, code, wait, gmail, and edit image.