Automated AI content creation & Instagram publishing from Google Sheets

Automated AI Content Creation & Instagram Publishing from Google Sheets

This n8n workflow automates the creation and publishing of social media content directly to Instagram, using ideas stored in a Google Sheet. It leverages AI (Google Gemini and Replicate Flux) to generate concepts, image prompts, captions, and the final image, turning your content plan into reality with minimal manual intervention.

Think of this as the execution engine for your content strategy. It assumes you have a separate process (whether manual entry, another workflow, or a different tool) for populating the Google Sheet with initial post ideas (including Topic, Audience, Voice, and Platform). This workflow takes those ideas and handles the rest, from AI generation to final publication.

What does this workflow do?

This workflow streamlines the content execution process by:

Automatically fetching unprocessed content ideas from a designated Google Sheet based on a schedule. Using Google Gemini to generate a platform-specific content concept (specifically for a 'Single Image' format). Generating two distinct AI image prompt options based on the concept using Gemini. Writing an engaging, platform-tailored caption (including hashtags) using Gemini, based on the first prompt option. Generating a visual image using the first prompt option via the Replicate API (using the Flux model). Publishing the generated image and caption directly to a connected Instagram Business account. Updating the status in the Google Sheet to mark the idea as completed, preventing reprocessing.

Who is this for?

Social Media Managers & Agencies: Automate the execution of your content calendar stored in Google Sheets. Marketing Teams: Streamline content production from planned ideas and ensure consistent posting schedules. Content Creators & Solopreneurs: Save significant time by automating the generation and publishing process based on your pre-defined ideas. Anyone using Google Sheets to plan social media content and wanting to automate the creative generation and posting steps with AI.