Instagram Content Publishing Google Sheets Gemini Workflow Template

This n8n workflow turns a spreadsheet-based content plan into published Instagram posts.
- Runs on a schedule to check for the next pending content row
- Reads Topic, Audience, Voice, and Platform fields from Google Sheets
- Uses Gemini to generate a post concept, image prompt options, and caption
- Sends an image generation request to Replicate Flux
- Publishes the final image and caption to Instagram
- Updates the source row so the same idea is not published twice

This workflow reads planned post ideas from Google Sheets, generates the creative assets needed for Instagram, publishes the post, and then updates the row so the same idea is not processed again. It is a practical publishing pipeline for teams that already use spreadsheets as a simple content calendar.

Input and output structure

The uploaded export expects each content row to include fields such as Topic, Audience, Voice, Platform, and Status. The workflow looks for rows that are still pending, then uses those fields to guide generation. The output is a published Instagram post plus an updated sheet row that reflects completion. That means Google Sheets acts as both the planning surface and the execution log.

How the generation layer works

The automation does more than write a caption. Gemini is used in multiple stages: first to generate a post concept, then to expand that concept into image prompt options, and finally to write the caption. That staged structure is useful because it separates “what the post should be about” from “how the image should look” and “what the final text should say.” The result is easier to tune than a single all-in-one prompt.

Image creation and publishing

After the caption and image prompt are ready, the workflow calls Replicate to generate the final image. The Instagram publish path then creates a media container and posts the content through the connected account. This part of the flow is where production setup matters most: Instagram permissions, correct account linking, and valid media URLs all need to be checked before relying on scheduled publication.

Who should use this template

This template is a strong fit for small marketing teams, freelancers, and operators who keep a social calendar in Google Sheets and want the publishing stage automated. It is especially useful when post ideas already exist and the missing step is execution, not ideation. It is less suitable if your content process depends on formal editorial review, asset libraries, or multiple approval roles.

What you will likely customize

The first customizations are usually row filtering, approval, and storage of generated assets. Some teams only want the workflow to draft captions and images, not publish automatically. Others want the generated image URL and caption written back to the sheet before a manager signs off. You may also want to use the Platform field more actively so the same queue can branch into LinkedIn or Facebook publishing later.

Main caveats

This workflow depends on clean spreadsheet rows and valid Instagram publishing permissions. If the sheet has inconsistent status values or incomplete topic fields, the generation steps will be weaker. Image generation is also an external dependency, so latency and cost need to be considered. Use this template when you want an execution engine for an existing content calendar, not when you need a full content operations system with approvals, analytics, and asset management built in.