Automating Skool/GoKollab Posts from YouTube Video Materials via n8n

Hi everyone,
I’m trying to build an automation scenario in n8n and need some advice. My goal is:

  1. Whenever a new YouTube video is published, I want the workflow to:
  • Check if there’s a corresponding folder in Google Drive for that video.
  • In that folder, there are various materials (e.g., JSON files, TXT files, or a Google Doc).
  1. Based on the contents of these materials, the workflow should create a post on Skool. For instance:
  • If it’s a Google Doc, extract text and use it for the post.
  • If there are other files, process them accordingly.

Challenges I’m facing:

  • Identifying the correct video when multiple videos are scheduled. The workflow needs to pick only the newly published one, not the oldest or others in bulk.
  • Handling dynamic folder detection in Google Drive and ensuring the right files are used. (could name it the same way the video is named but not sure if that’s the best solution)

I’d appreciate any guidance, tips, or examples of similar setups. Thanks in advance!

  • n8n version: 1.69.2
  • Database (default: SQLite): QLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own, main
  • Running n8n via (Docker, npm, n8n cloud, desktop app): self-hosted in google cloud
  • Operating system: Windows10

hi @Kiremit

This is an interesting use case, but can be a bit complex to set up. Can you share what you have so far in terms of workflow and a few examples so the community can help?

Thanks!

Not much. I would be able to setup the logic of checking for new videos and than based on that maybe be able to look for a document in a folder with the same name as the video title.