Generate AI images from text prompts with Gemini 2.0, Google Sheets & Drive

This n8n template demonstrates how to automate the creation of high-quality visual content using AI. The workflow takes simple titles from a Google Sheets spreadsheet, generates detailed artistic prompts using AI, creates photorealistic images, and manages the entire process from data input to final delivery. Use cases are many: Perfect for digital marketers, content creators, social media managers, e-commerce businesses, advertising agencies, and anyone needing consistent, high-quality visual content for marketing campaigns, social media posts, or brand materials! Good to know - The Gemini 2.0 Flash Exp image generation model used in this workflow may have geo-restrictions. - The workflow processes one image at a time to ensure quality and avoid rate limiting. - Each generated image maintains high consistency with the source prompt and shows minimal AI artifacts. How it works 1. Automated Trigger: A schedule trigger runs every minute to check for new entries in your Google Sheets spreadsheet. 2. Data Retrieval: The workflow fetches rows from your Google Sheets document, specifically looking for entries with "pending" status. 3. AI Prompt Generation: Using Google Gemini, the workflow takes simple titles and transforms them into detailed, artistic prompts for image generation. The AI considers: - Specific visual elements, styles, and compositions - Natural poses, interactions, and environmental context - Lighting conditions and mood settings - Brand consistency and visual appeal - Proper aspect ratios for different platforms 4. Text Processing: A code node ensures proper JSON formatting by escaping newlines and maintaining clean text structure. 5. Image Generation: Gemini's advanced image generation model creates photorealistic images based on the detailed prompts, ensuring high-quality, consistent results. 6. File Management: Generated images are automatically uploaded to a designated folder in Google Drive with organized naming conventions. 7. Public Sharing: Images are made publicly accessible with read permissions, enabling easy sharing and embedding. 8. Database Update: The workflow completes by updating the Google Sheets with the generated image URL and changing the status from "pending" to "posted", creating a complete audit trail. How to use 1. Setup: Ensure you have the required Google Sheets document with columns for ID, prompt, status, and imageUrl. 2. Configuration: Update the Google Sheets document ID and folder IDs in the respective nodes to match your setup. 3. Activation: The workflow is currently inactive - activate it in n8n to start processing. 4. Data Input: Simply add new rows to your Google Sheets with titles and set status to "pending" - the workflow will automatically process them. 5. Monitoring: Check the Google Sheets for updated status and image URLs to track progress. Requirements - Google Gemini API account for LLM and image generation capabilities - Google Drive for file storage and management - Google Sheets for data input and tracking - n8n instance with proper credentials configured Customizing this workflow Content Variations: Try different visual styles, seasonal themes, or trending designs by modifying the AI prompt in the LangChain agent. Output Formats: Adjust the aspect ratio or image specifications for different platforms (Instagram, Pinterest, TikTok, Facebook ads, etc.). Integration Options: Replace the schedule trigger with webhooks for real-time processing, or add notification nodes for status updates. Batch Processing: Modify the limit node to process multiple items simultaneously, though be mindful of API rate limits. Quality Control: Add additional validation nodes to ensure generated images meet quality standards before uploading. Analytics: Integrate with analytics platforms to track image performance and engagement metrics. This workflow provides a complete solution for automated visual content creation, perfect for businesses and creators looking to scale their visual content production while maintaining high quality and consistency across all marketing materials.