Hi everyone,
I’m trying to build an automation scenario in n8n and need some advice. My goal is:
- 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).
- 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