I want to automate my daily blog on Tumblr

I’ve a daily blog on Tumblr with one song a day from monday to friday. I want to automate this using either chat gpt or gemini. It’s called justadailysong.com and it’s straight forward. It always uses YouTube music url’s or soundcloud.

Automation works, it gets input from a Google sheet, asks to write the blogpost to chatgpt at the moment, stores the answer in the sheet and uses the different fields to build the post.

I’ve got three problems at the moment.

Problem one, when I want to use Google Gemini, I get errors and I’ve zero examples on how I should fill out al the fields. So this doesn’t work.

Problem two, when I use Chatgpt it works, but the prompt answer is very low on quality and simply wrong. Both in the mini model as the system model.

Problem three, I can post to Tumblr, but it has not the right format so it seems, I want audio file (url in sheet), header 1 headline which is always Song by Artist (both are fields in the Google sheet) and next the answer to the prompt which should ideally be between 2 and maximum 5 paragraphs.

Any help/examples would be greatly appreciated.