Workflow
The system:
- Retrieves pending content ideas from Google Sheets
- Generates the image prompt, headline, description, and hashtags
- Checks the generated content against predefined requirements
- Creates the image using Google Gemini
- Selects from 12 branded templates automatically
- Adds the firm’s logo, text, colors, and layout
- Renders the final design as a 1080 × 1080 PNG
- Uploads the finished graphic to Google Drive
- Removes temporary files after processing
- Updates Google Sheets with the final image, description, hashtags, and status



