Automation library · Content

FB Ad Spy: AI-Powered Competitor Ad Intelligence & Auto-Video

Started by an event in a connected app, and works across Google Cloud Storage, Google Drive and Google Sheets. It hands the judgement calls to OpenAI. 54 steps, 3 branches, 10 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

54 stepsLarge: read it before trusting it with anything live
3Branches: places the flow splits
10Loops or waits
3Services it connects to

The flow

Starts it 1Model 6Logic 23Service 24

The steps in the order they run, from what starts it.

  1. 1On Manual StartManual triggerStarts it
  2. 2Scrape Ad Library DataHttp RequestService
  3. 3Distribute Ad CardsSplit OutLogic
  4. 4Extract Batch of Ad CardsSplit OutLogic
  5. 5Separate Video ResourcesSplit OutLogic
  6. 6Filter by Ad LikesFilterLogic
  7. 7Filter Ads by LikesFilterLogic
  8. 8Filter Videos by LikesFilterLogic
  9. 9Apply Filter to Image AdsFilterLogic
  10. 10Apply Multi-Condition Filter to Text AdsFilterLogic
  11. 11Apply Filter to Video AdsFilterLogic
  12. 12Batch Image Ads ProcessingSplit In BatchesLogic
  13. 13Batch Text Ads ProcessingSplit In BatchesLogic
  14. 14Batch Video Ads ProcessingSplit In BatchesLogic
  15. 15Fetch Image From URLHttp RequestService
  16. 16Summarize Text with AIOpen AiModel
  17. 17Download Video ContentHttp RequestService
  18. 18Analyze Image with AIOpen AiModel
  19. 19Record Text Data in SheetsGoogle SheetsService
  20. 20Save Video to Google DriveGoogle DriveService
  21. 21Summarize Image with AIOpen AiModel
  22. 22Wait Before Processing Text AdsWaitLogic
  23. 23Initiate Gemini UploadHttp RequestService
  24. 24Record Image Data in SheetsGoogle SheetsService
  25. 25Retrieve Video from DriveGoogle DriveService
  26. 26Wait Before Image CreationWaitLogic
  27. 27Submit Video to GeminiHttp RequestService
  28. 28Generate Image with AIOpen AiModel
  29. 29Wait for Analysis CompletionWaitLogic
  30. 30Analyze Video in GeminiHttp RequestService
  31. 31Summarize Video with AIOpen AiModel
  32. 32Create Video Prompt with AIOpen AiModel
  33. 33Record Video Data in SheetsGoogle SheetsService
  34. 34Wait Before Video ProcessingWaitLogic
  35. 35Configure API ParametersSetLogic
  36. 36Create JWT TokenJwtService
  37. 37Obtain OAuth TokenHttp RequestService
  38. 38Start Video Generation ProcessHttp RequestService
  39. 39Pause for 20 SecondsWaitLogic
  40. 40Query Server StatusHttp RequestService
  41. 41Evaluate Condition RouteSwitchLogic
  42. 42Convert Media Into FileConvert To FileService
  43. 43Save File to Cloud StorageGoogle Cloud StorageService
  44. 44Transform Video to 9:16 RatioHttp RequestService
  45. 45Await Rendering CompletionWaitLogic
  46. 46Check Rendering StatusHttp RequestService
  47. 47Verify Status OKIfLogic
  48. 48Insert Video CaptionsHttp RequestService
  49. 49Await Caption CompletionWaitLogic
  50. 50Verify Caption CompletionHttp RequestService
  51. 51Verify Captions PresenceIfLogic
  52. 52Download Finalized VideoHttp RequestService
  53. 53Upload Final Output to CloudGoogle Cloud StorageService
  54. 54Modify Google Sheet EntryGoogle SheetsService

How it's built

Starts on
An event in a connected app
Steps
54, with 3 branches, 10 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Google Cloud Storage, Google Drive, Google Sheets
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Google Cloud Storage, Google Drive and Google Sheets accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an event in a connected app.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 54 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 54 steps before you point it at anything that matters.