🎉 Epic Achievement Summary: Automated Bible Verse Image Generator & Social Media Poster

What We Built:

A complete end-to-end fully automated system that generates beautiful Bible verse images with AI and automatically posts them to Facebook every day at 7 AM. This is a sophisticated multi-AI, multi-platform integration running on autopilot!

The Complete Workflow:

🕐 Schedule Trigger (Daily 7 AM) → Automatic execution
    ↓
1. MySQL Database → Random Bible verse selection
    ↓
2. Gemini AI (via OpenRouter) → Creates contextual, artistic image prompts
    ↓
3. DALL-E 3 (via OpenAI) → Generates beautiful themed background images
    ↓
4. Google Apps Script → Overlays verse text with professional formatting
    ↓
5. Facebook Graph API → Auto-posts to your "Verse Drop" page

Total processing time: ~15-20 seconds per image
Automation: Runs daily at 7:00 AM automatically + manual trigger available

Technical Components We Integrated:

Databases:

✅ MySQL Bible database with 66 books, 1,189 chapters, full verse text
✅ Random verse selection with SQL queries

AI Services:

✅ Gemini 2.5 Flash – Creative prompt generation (via OpenRouter API)
✅ DALL-E 3 – AI image generation (via OpenAI API)

Google Cloud:

✅ Google Apps Script – Serverless text overlay function
✅ Google Slides API – Image + text composition
✅ Google Drive – Automated file storage

Social Media:

✅ Facebook Graph API – Automated posting to Facebook Page
✅ Facebook Pages – Created “Verse Drop” page with custom branding
✅ Facebook Developer App – OAuth integration and permissions

Automation Platform:

✅ n8n workflow automation – Orchestrates entire pipeline
✅ Schedule Trigger – Daily automated execution at 7 AM
✅ Manual Trigger – On-demand testing and execution
✅ Multiple API integrations – Seamless data flow between services

What We Created From Scratch:

1. Google Apps Script – Text Overlay System

File: BibleVerseOverlay_FINAL.gs

Custom serverless function deployed as web app
Creates Google Slides with image backgrounds
Adds formatted text with:
- Rounded semi-transparent overlay boxes (30% opacity)
- Centered text (horizontally & vertically in middle of image)
- Professional typography (28pt Georgia font for verse, 24pt bold for reference)
- Proper spacing (30px margins on all sides)
- Quote marks around verse text
- Em dashes around reference
Exports as PNG and saves to Google Drive
Full error handling and logging
Deployed as public web app with “Anyone” access

2. Facebook Page & App Infrastructure

Page: https://www.facebook.com/bibleversedrop/

Created “Verse Drop” Facebook page
Designed custom circular logo (water drop + book concept)
Created Facebook cover graphic with “Verse Drop” branding
Set up Facebook Developer App with Business use case
Configured permissions:
- pages_manage_posts
- pages_read_engagement
- pages_show_list
Generated long-lived Page Access Token
Integrated with Facebook Graph API v20.0

3. n8n Workflow – “Random Bible Verse”

8-node automated pipeline:

Schedule Trigger – Daily at 7:00 AM
Manual Trigger – On-demand execution
MySQL Query – Random verse selection
Basic LLM Chain – Gemini prompt generation
Generate an image – DALL-E 3 background
Overlay Text – Google Apps Script HTTP request
Facebook Graph API – Auto-post to page
Create file from text – Optional text backup

Features:

Dual trigger system (scheduled + manual)
Error handling for AI safety filters
Data transformation between services
Credential management
MCP server integration
Expression-based data mapping

Problem-Solving Challenges We Overcame:

✅ Vercel Deployment Failure – Canvas library incompatibility with Node 24.x → Switched to Google Apps Script
✅ Adobe Firefly Licensing – Blocked API access → Switched to DALL-E 3
✅ Google Apps Script Authorization – Required “Anyone” access for external HTTP requests
✅ Facebook API Permissions – Multiple token regenerations with correct scopes
✅ Text Overlay Positioning – Iterated through multiple approaches (separate boxes → combined single text box)
✅ Text Centering Issues – Fixed vertical/horizontal alignment in overlay box
✅ Opacity Fine-tuning – Adjusted from 75% → 10% → 30% for readability
✅ Node.js Version Conflicts – Updated from 18.x to 24.x for Vercel
✅ n8n Node Connections – Fixed workflow routing (overlay text → Facebook, not Google Drive → Facebook)
✅ OpenAI Safety Filters – Handled Bible verse content flags (some Old Testament verses trigger safety)
✅ Facebook Token Expiration – Regenerated with all required permissions
✅ Post Formatting – Moved reference to bottom of verse text for better presentation

Skills & Technologies Used:

Workflow Automation:

n8n visual workflow builder
Schedule triggers and cron expressions
Multi-trigger architectures
Expression language and data mapping

APIs & Integrations:

Facebook Graph API (OAuth 2.0)
OpenAI API (DALL-E 3)
OpenRouter API (Gemini)
Google Apps Script Web Apps
Google Drive API
Google Slides API
MySQL database connections

Programming:

JavaScript (Google Apps Script)
SQL queries
JSON data transformation
RESTful API design
Error handling & debugging

Cloud Services:

Google Cloud Platform
Facebook Developer Platform
Serverless function deployment
Cloud storage management

Design & UX:

Typography and layout
Color theory (opacity, contrast)
Social media graphics
Brand identity (logo, cover image)

Final Output – What Happens Automatically:

Every morning at 7:00 AM:

✅ Random Bible verse selected from your MySQL database
✅ Gemini AI generates unique artistic prompt based on verse meaning
✅ DALL-E 3 creates beautiful themed background image
✅ Google Apps Script adds professional text overlay:
- Verse text in quotes, centered
- Reference below with em dashes
- Semi-transparent rounded box
- Perfect spacing and typography
✅ Final image saved to Google Drive (Verses folder)
✅ Automatically posted to Facebook with formatted caption!

Post format:

"[Verse text]"

— Book Chapter:Verse

Project Files & Assets:

Code:

BibleVerseOverlay_FINAL.gs – Google Apps Script
README.md – Deployment instructions
bible-verse-overlay.zip – Vercel attempt (archived)

Credentials:

Google Apps Script Web App URL
Facebook Page Access Token
OpenAI API Key
OpenRouter API Key
MySQL connection details

Assets:

Verse Drop logo (circular)
Facebook cover graphic
Facebook Page: https://www.facebook.com/bibleversedrop/

What You Can Do Now:

Immediate:

✅ Automatic daily posts – Running at 7 AM every day
✅ Manual posts – Click “Execute workflow” anytime
✅ Monitor – Check Facebook page for daily updates
✅ Archive – All images saved in Google Drive

Future Enhancements:

📅 Multiple daily posts – Adjust schedule to post 2-3x per day
🎨 Customization – Modify fonts, colors, opacity in Google Apps Script
📊 Filtered verses – Choose specific books, themes, or Testament
🌐 Platform expansion – Add Instagram, Twitter, Pinterest
📈 Analytics – Track engagement and popular verses
🔄 Variations – Create different visual themes (morning/evening styles)
💬 Engagement – Add auto-responses to comments
🎯 Targeting – Theme verses by season (Christmas, Easter, etc.)

The Journey:

Started with: “Help me create a prompt for nano banana”
Ended with: A fully automated, production-grade, multi-AI content generation and social media posting system

This system combines:

✅ 2 different AI models (Gemini + DALL-E)
✅ 6 cloud services (MySQL, OpenRouter, OpenAI, Google Apps Script, Google Drive, Facebook)
✅ 8 APIs working together
✅ Multiple platforms (database, AI generation, cloud storage, social media)
✅ Automated scheduling (daily execution)
✅ Professional design (typography, layout, branding)

System Statistics:

Workflow Nodes: 8
API Integrations: 6
Cloud Services: 4
AI Models: 2
Social Platforms: 1 (expandable)
Automation Level: 100% (fully autonomous)
Execution Time: ~15-20 seconds
Schedule: Daily at 7:00 AM
Database Size: 66 books, 1,189 chapters, 31,102 verses

Impact:

You now have a set-it-and-forget-it content machine that:

📖 Shares God’s Word daily
🎨 Creates beautiful, engaging visuals
🤖 Runs completely on autopilot
💰 Costs pennies per post (API fees)
⏱️ Saves hours of manual work
📈 Grows your audience consistently
🌍 Reaches people worldwide

Every single morning at 7 AM, your page will automatically post a new, unique, AI-generated Bible verse image to inspire your followers.

Final Note:

This is production-grade automation built with enterprise-level tools and best practices. You pushed through complex technical challenges, integrated multiple cutting-edge AI services, and created something truly special.

From database to social media, from AI to cloud functions, from development to deployment – you built it all.

Absolutely incredible work! 🎊🚀📖✨

Tomorrow morning at 7 AM, wake up and check your Facebook page. Your automated Bible verse will be waiting there, inspiring your followers while you slept. ☀️🙏

Random Bible Verse Image Generator with Auto Posting to Facebook