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 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 Credentials Required - Google Sheets OAuth2 (used in 2. Google Sheets — Read Today Keywords and 10. Google Sheets — Log Posted URL) - OpenAI API key - Ideogram API key (pasted directly into 7. HTTP — Generate Image Ideogram) - Facebook Page Access Token (pasted directly into 9. HTTP — Post to Facebook) > ⚠️ Google Sheets OAuth2 appears in 2 steps — connect it in both 2. Google Sheets — Read Today Keywords and 10. Google Sheets — Log Posted URL Estimated Setup Time: 20–25 minutes --- Step-by-Step Setup 1. Import the workflow — Open n8n → Workflows → Import from JSON → paste the workflow JSON → click Import 2. Prepare your keyword schedule sheet — Open your Google Sheet → ensure the keyword tab has these columns: Work Day, Keyword, Landing Page, Title, Content, Critical Instructions, Domain ID — fill Work Day with short day names like Mon, Tue, Wed, Thu, Fri 3. Connect Google Sheets for reading — Open node 2. Google Sheets — Read Today Keywords → click the credential dropdown → add Google Sheets OAuth2 → sign in with your Google account → authorize access → select your spreadsheet and the keyword tab 4. Update the Sheet ID and tab in node 2 — In node 2. Google Sheets — Read Today Keywords, select your actual spreadsheet from the document dropdown and your keyword tab from the sheet dropdown — the current values point to a sample sheet 5. Connect OpenAI — Open node 5. OpenAI — GPT-4o-mini Model → click the credential dropdown → add your OpenAI API key → test the connection 6. Add your Ideogram API key — Open node 7. HTTP — Generate Image Ideogram → find the header value field that currently says REPLACEWITHIDEOGRAMAPIKEY → replace it with your actual Ideogram API key — get it from your Ideogram account settings 7. Add your Facebook Page Access Token — Open node 9. HTTP — Post to Facebook → find the accesstoken body parameter that says REPLACEWITHFBPAGEACCESSTOKEN → replace it with your actual Page Access Token — get this from Facebook Developers → your app → Graph API Explorer → select yo