Automation library · Data collection

Marketing automation workflow with Google Sheet

Started by a clock, and works across Google Sheets. 29 steps, 8 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

Large

Download free
29 stepsLarge: read it before trusting it with anything live
8Branches: places the flow splits
1Loop or waits
1Service it connects to

The flow

Starts it 1Logic 17Service 11

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

  1. 1Schedule TriggerSchedule triggerStarts it
  2. 2Query TemplatesGoogle SheetsService
  3. 3Edit FieldsSetLogic
  4. 4FilterFilterLogic
  5. 5Query Flow DataGoogle SheetsService
  6. 6user_id Not EmptyIfLogic
  7. 7template_name Not EmptyIfLogic
  8. 8Error: empty user_idStop And ErrorLogic
  9. 9type Not EmptyIfLogic
  10. 10Error: empty template_nameStop And ErrorLogic
  11. 11type_template_id Not EmptyIfLogic
  12. 12Error: empty typeStop And ErrorLogic
  13. 13metabase_id Not EmptyIfLogic
  14. 14Error: empty type_template_idStop And ErrorLogic
  15. 15Update Data By Status ProcessingGoogle SheetsService
  16. 16Error: empty metabase_idStop And ErrorLogic
  17. 17Fetch Query Processing Data1Google SheetsService
  18. 18Remove DuplicatesRemove DuplicatesLogic
  19. 19Change Status to SendingGoogle SheetsService
  20. 20Fetch Query Processing Data2Google SheetsService
  21. 21WaitWaitLogic
  22. 22No Email CheckIfLogic
  23. 23DIsposal CheckIfLogic
  24. 24Change Status to no-emailGoogle SheetsService
  25. 25Block Email CheckIfLogic
  26. 26Change Status to disposal-emailGoogle SheetsService
  27. 27Brevo Send EmailSend In BlueService
  28. 28Change Status to disposal-email1Google SheetsService
  29. 29Change Status to disposal-email2Google SheetsService

How it's built

Starts on
A clock
Steps
29, with 8 branches, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Google Sheets
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Google Sheets account. 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 29 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 29 steps before you point it at anything that matters.