YouTube content scout automation

I am trying to build a YouTube content scout for a project I’m working on. I have used ChatGpt, Clause, Deepseak and now Grok to try and help me trouble shoot issues but it isn’t working properly still. My first draft I was able to get it to pull the information properly but all of the YouTube url’s were no longer valid or private. The AI models have suggested a 2nd HTTP call to a 2nd JSON parser before the data goes into the Google Sheet but the mapping isn’t working for some reason and now the data isn’t going into the Google sheet at all. I’m sure it’s a mapping issue but the terms on the AI models are different than what i’m seeing as options on Make.com so I have been trying to pull the information I think i’m supposed to be mapping but isn’t working. Anyone have experience with this type of workflow or be interested in helping me get it working properly?