Transcripts of new channel videos — into your database automatically

On a schedule the scenario reads fresh videos from your channels via Facebook Graph API, filters out shorts and old clips, pulls the transcripts, and stores them in Notion with no duplicates.

  • Transcripts are collected automatically, no manual copying
  • Several channels are tracked at once
  • Duplicates are filtered out against the database
  • Shorts and old clips are filtered away
Set it up for yourselfScriptera

How it works

Automating Notion and Facebook Graph API takes no code: a ready-made scenario does the routine for you.

  1. Starts when: Schedule Trigger
  2. Then: Set Max Video Age
  3. Then: Channels To Track
  4. Then: Split Out
  5. Then: Channel Info
  6. Then: Verify Channel ID + Create RSS Link
  7. Then: Channel Info + Channel ID
  8. Check: Loop Over Each Channel
  9. Check: Add Client & Age Rules
  10. Then: Data with Raw Date
  11. Then: Date & Time
  12. Check: Merge Formatted Date
  13. Check: Is Video Recent Enough?
  14. If yes: Loop Over Recent Videos
  15. Check: Loop Over New Videos
  16. Check: Filter Out YouTube Shorts
  17. If yes: Rename Original URL
  18. Then: Find Video ID
  19. Then: Is Video ID valid?
  20. Then: Clean Up URL
  21. Check: Was Video ID Found?
  22. If yes: Merge Video ID With Video Data
  23. Then: Get Transcript from API
  24. Check: Transcript Worked?
  25. If yes: Official Captions/Transcript
  26. Check: Add Transcript to Video Data
  27. Then: Add to Content Queue Table
  28. Then: Wait
  29. If no: Transcript Failed
  30. If no: Rename URL
  31. Then: try to get video_id again
  32. If yes: New Video Information
  33. Then: author + title + link + pubDate
  34. Then: Check if URL Is In Database
  35. Check: Merge DB Check Result
  36. Check: Is Video Already in Database?
  37. If yes: Discard URL
  38. Then: Find Channel's Videos
  39. Then: Max Content Age Days

You can launch this Notion + Facebook Graph API integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios