Create daily Facebook posts from Google Sheets with GPT-4o-mini and Ideogram
Description Set up your keyword schedule once in a Google Sheet and the workflow publishes daily Facebook posts automatically every morning at 6AM. For each keyword scheduled for today, it generates a headline and pos...
Template notes
Description
Set up your keyword schedule once in a Google Sheet and the workflow publishes daily Facebook posts automatically every morning at 6AM. For each keyword scheduled for today, it generates a headline and post content with GPT-4o-mini, creates a professional 1280x704 image with Ideogram, publishes the photo and caption directly to your Facebook Page, and logs the live post URL back to your sheet. Built for SEO agencies and social media managers who want consistent daily Facebook publishing across multiple clients without any manual work.
---
What This Workflow Does
- Reads today's keywords from Google Sheets — Filters rows where the Work Day column matches today's day so only today's scheduled content is published - Loops through each keyword independently — Processes one row at a time so every keyword gets its own unique post, image, and log entry - Generates a headline and post content with GPT-4o-mini — Writes a 6–8 word informational headline, plain text paragraphs under 50 words, and an image generation prompt — all grounded in your provided title and content - Creates a professional image with Ideogram — Generates a realistic 1280x704 business-appropriate image in TURBO mode based on the AI-written image prompt - Publishes directly to the Facebook Page — Posts the image and caption to your Facebook Page via the Facebook Graph API with no manual step needed - Logs the live post URL back to Google Sheets — Appends a timestamp, Domain ID, link type, and the live Facebook post URL to your log sheet after every successful post - Respects Facebook rate limits — Waits exactly 1 minute between each post to prevent rate limiting errors when publishing multiple keywords in the same run
---
Setup Requirements
Tools Needed - n8n instance (self-hosted or cloud) - Google Sheets with a keyword schedule sheet and a log sheet - OpenAI account with GPT-4o-mini API access - Ideogram account with API access - Facebook Page with a Page Access Token