How ubagyan/blogger-ai-automation works
Project Type and Purpose
• This is an automation‐workflow tool written in Google Apps Script. It lives inside a Google Sheet and orchestrates AI-driven blog content creation, image enrichment, auto-publishing to Blogger, and feedback synchronization.
File Structure
• Top level only has three entries: LICENSE, README.md, blogAutomation.gs.
• blogAutomation.gs is the single script file that contains all business logic, API calls, and menu triggers.
README for Insights
• The script connects to four major services:
• Gemini API for text generation
• Pexels API for image retrieval
• Blogger API v3 for publishing and comment retrieval
• Google Sheets for configuration, data storage, and UI menus
• It handles two workflows:
a) Draft generation → publishing → metadata sync
b) Comment and post metadata synchronization
Detail Without Over-Segmentation
• Break the orchestrator rectangle into subcomponents or annotate it with function names:
• generateBlogDraft()
• fetchPexelsImage()
• publishToBlogger()
• syncPostsAndComments()
• Which sheet tabs are read/written at each stage (“Sheet1”, “Posts”, “Comments”).