drkostas/Youtube-FirstCommentBot — reverse-engineered prompt

Build me a simple Python YouTube comment bot for educational use, not spam. I want to be able to give it a list of YouTube channels to follow, and whenever one of those channels posts a new video, the bot should quickly leave the first comment if it has not already commented on that video.

Please make it use a reusable pool of comments from text files so it does not post the exact same thing every time. Store followed channels and posted comments in a MySQL database, and include basic tools to add or remove channels, list channels, list comments, set channel priority, and refresh saved channel profile photo URLs. I also want a separate stats mode that goes back through comments the bot already posted and saves things like likes and reply counts.

Make the setup configurable with env vars and YAML files, and keep it friendly for running locally with Python 3.8 or newer. If possible, make it easy to deploy on Heroku, with optional Dropbox support for saving tokens or config. Look up current YouTube API auth docs online if needed.