Automation library · Content

Generate UGC product videos from Google Sheets with DALL

Started by a clock, and works across Google Drive and Google Sheets. 28 steps, 2 branches, 3 loops or waits: large, and worth reading before you trust it with anything live.

Large

Download free
28 stepsLarge: read it before trusting it with anything live
2Branches: places the flow splits
3Loops or waits
2Services it connects to

The flow

Starts it 2Logic 16Service 10

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

  1. 1Error TriggerError triggerStarts it
  2. 2Schedule Trigger1Schedule triggerStarts it
  3. 3Parse Error DetailsCodeLogic
  4. 4Read Product Sheet1Google SheetsService
  5. 5Row Number Known?IfLogic
  6. 6Filter Pending Rows1CodeLogic
  7. 7Update Sheet, ErrorGoogle SheetsService
  8. 8Log Error (Unknown Row)CodeLogic
  9. 9Loop Over Items1Split In BatchesLogic
  10. 10Loop Complete1No OpLogic
  11. 11AI Prompt Builder1CodeLogic
  12. 12DALL-E 3 Generate Image1Http RequestService
  13. 13Extract DALL-E URL1CodeLogic
  14. 14GPT-4 Vision Analysis1Http RequestService
  15. 15Parse Vision Analysis1CodeLogic
  16. 16Video Script Builder1CodeLogic
  17. 17Wait for Sora Rate Limit1WaitLogic
  18. 18Sora Generate Video1Http RequestService
  19. 19Extract Sora Job ID1CodeLogic
  20. 20Wait 30 Seconds1WaitLogic
  21. 21Poll Sora Status1Http RequestService
  22. 22Check Sora Status1CodeLogic
  23. 23Video Ready?1IfLogic
  24. 24Fetch Sora Video Content1Http RequestService
  25. 25Upload Video to Google Drive1Google DriveService
  26. 26Make File Public1Http RequestService
  27. 27Build Public Drive URL1CodeLogic
  28. 28Update Sheet, Done2Google SheetsService

How it's built

Starts on
A clock
Steps
28, with 2 branches, 3 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Google Drive, Google Sheets
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Google Drive and Google Sheets accounts. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

No. Every step is fixed logic or a call to a service, so it does the same thing every time.

How long does it take to set up?

Take your time. At 28 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 28 steps before you point it at anything that matters.