This system automatically updates images based on a schedule and content bank in Google Sheets.
It uses GPT-5-mini to select the best image template based on the content and then uses Nano Banana to replace the template image with content from the Google Sheet.
This runs of a schedule trigger but it could easily be replaced with a Telegram bot to handle the input instead.
Requirements:
Google Client for Google Sheets and Google Drive
The full workflow is attached below.
Let me know if you have any questions!