Hey everyone, I had this idea as I was clicking through the many YouTube videos learning what I could on N8N.
BLUF: I want to build a Training guide of what videos you should work through across channels of the top 10 content providers (NateH) is high on that list. also if I wanted to look for how to do something the Agent could provide the videos that cover that topic.
Full disclosure I started with FloWise but found it too restrictive. Any way I saw some of videos on YouTube analysis and also one from Ben Young on how to pull in transcripts. Not wanting to stop there I used the community node for pulling YouTube transcripts, then use the GoogleAPI to pull in view, comment, and like counts and wrote that to a GDrive spreadsheet. Next step was to process the transcripts and produce a summary of the video and also some keywords from each one. The goal was to have a database of All the N*N videos for the last 90 days from the top 10 contributors I knew of. It is still a work in progress as I found out pulling lots of data via API is problematic. Much like Nate talked about stability and enterprise grade. I got a little Chat and prompt to query the spreadsheet but well that's crap. so I am building and going to put it to Air Table then do my querying from there. . I will share the workflow in a bit but wanted to mention it here so some could suggest how to refactor it .