Automating YouTube content scouting

I'm working on building a YouTube content scout for a project. I've utilized ChatGPT, Clause, Deepseek, and now Grok to assist with troubleshooting, but it's still not functioning correctly. In my initial draft, I successfully extracted the information, but all the YouTube URLs became invalid or private. The AI models suggested a second HTTP call to another JSON parser before the data is sent to the Google Sheet, but the mapping isn't working for some reason, and now the data isn't reaching the Google Sheet at all. I suspect it's a mapping problem, but the terminology used by the AI models differs from the options I see on callin.io. I've been attempting to pull the information I believe should be mapped, but it's not working. Has anyone encountered a similar workflow or would be willing to help me get it operational?