The Full Workflow For Facebook & IG Auto Post Creation And Posting
Resources You’ll Need (click below for access)
Pipedream Workflow
Step 1 : Sign up for pipedream HERE
Step 2: Click on the template link HERE
Step 3: Save the template under whatever name you choose
Step 4: Change the trigger step to whatever time you want it to upload the captions (currently configured for 4 posts per day for seven days, 28 posts)
Step 5: get_my_content step, connect your google sheet to wherever the database of your content is, choose the range to encompass all of your data in the google sheet
Step 6: create_captions step, connect your openrouter account
Step 7: caption_input step, connect the google sheet location where you want your captions to be, make sure you use this same location for the first and last step of your Make.com automation workflow
Don’t change any of the code or anything unless it was explicitly stated in steps 1-7
Make.com Workflow
Step 1 : Sign up for Make.com HERE
Step 2: Get a cell, the first cell of your list of captions that were generated from the pipedream workflow
Step 2: OpenAI Prompt to get the images you want to be posted on instagram and facebook.
Step 3: Create a photo post on instagram
Step 4: Create a post on facebook
Step 5: Deleting the row that the cell was in in the first step
Here is my OpenAI prompt:
“Create a professional, clean, high-resolution illustration of a man or woman using or interacting with an AI-powered automation system. Randomly choose one of the following interaction types for the scene:
1. Content Creation Tools – writing assistants, AI-generated images or videos, editing dashboards
2. Workflow Automation Dashboards – flowchart builders, task automation systems, API connectors
3. Robotic Assistants or Agents – humanoid or abstract AI bots helping with tasks
4. Smart Data Interfaces – charts, metrics, predictive analytics tools being used or analyzed
5. Voice-Activated AI Systems – human speaking to or receiving feedback from a digital interface
Then randomly choose one of the following visual styles to match the entire image:
1. Futuristic Sci-Fi – holograms, sleek surfaces, ambient glow, advanced tech
2. Minimalist Office – modern furniture, clean lines, soft daylight, sparse UI
3. Retro 90s Tech – vintage computer stations, CRT monitors, pixelated UI, old-school interfaces
4. Cyberpunk Neon – neon signs, gritty tech, nighttime city backdrop
5. Nature-Tech Fusion – indoor plants, wood-metal hybrids, natural light mixing with tech
Make sure the person is clearly engaged with the system — either typing, touching, analyzing, or speaking to it. Avoid abstract art styles. Focus on clarity, balance, and visual storytelling. This image should feel ready to be used on a website, newsletter, or social media post about AI and automation.”
YOU’RE GOOD TO GO, YOU ARE FULLY AUTOMATED