Generate and post Instagram captions with Google Drive, GPT-4.1-mini, Gmail and Blotato

Social Media Post & Caption Generator (Google Drive → AI Caption → Approval → Auto-Post)

Automatically turn your existing content library into approved, AI-written social media posts. This workflow selects a random file from Google Drive, generates an Instagram caption using AI, sends it to you for approval, and—once approved—uploads and publishes the post via Blotato.

🎥 Watch Step-By-Step Guide: https://youtu.be/9XU9ECcj9dg

What this template does

On a scheduled basis (default: 10:00 AM), this workflow: Searches a specified Google Drive folder for content files Randomly selects one file to avoid repetitive posting Uses AI to generate an Instagram-ready caption based on the file name Sends the caption + file link to you via email for approval

If approved: Downloads the file from Drive Uploads the media to Blotato Creates and publishes the social media post

If rejected: Automatically loops back and selects a different random file

Why it’s useful Keeps your social media consistent with minimal manual effort Adds a human-in-the-loop approval step for quality control Eliminates the need to manually write captions or pick content Ideal for creators, solo marketers, and small teams managing content at scale