Automation library · Lead generation

Gmail Cold Email Sequence with Google Sheets Tracking

Started by a clock, and works across Gmail, Google Sheets and Slack. 55 steps, 10 branches, 12 loops or waits: large, and worth reading before you trust it with anything live.

Large

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

The flow

Starts it 4Logic 26Service 25

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

  1. 1Schedule TriggerSchedule triggerStarts it
  2. 2Schedule Trigger2Schedule triggerStarts it
  3. 3Schedule Trigger1Schedule triggerStarts it
  4. 4Switch1SwitchLogic
  5. 5Schedule Trigger3Schedule triggerStarts it
  6. 6If3IfLogic
  7. 7Google Sheets8Google SheetsService
  8. 8Google Sheets7Google SheetsService
  9. 9Google SheetsGoogle SheetsService
  10. 10Google Sheets12Google SheetsService
  11. 11Loop Over Items4Split In BatchesLogic
  12. 12Loop Over Items5Split In BatchesLogic
  13. 13Loop Over ItemsSplit In BatchesLogic
  14. 14If1IfLogic
  15. 15SlackSlackService
  16. 16Switch2SwitchLogic
  17. 17Slack1SlackService
  18. 18Replied?GmailService
  19. 19MergeMergeLogic
  20. 20Slack2SlackService
  21. 21Replied?2GmailService
  22. 22Merge2MergeLogic
  23. 23Switch3SwitchLogic
  24. 24Gmail1GmailService
  25. 25Edit FieldsSetLogic
  26. 26IfIfLogic
  27. 27Edit Fields2SetLogic
  28. 28If2IfLogic
  29. 29Loop Over Items6Split In BatchesLogic
  30. 30Loop Over Items7Split In BatchesLogic
  31. 31Loop Over Items8Split In BatchesLogic
  32. 32Google Sheets9Google SheetsService
  33. 33Google Sheets6Google SheetsService
  34. 34Gmail2GmailService
  35. 35Google Sheets1Google SheetsService
  36. 36GmailGmailService
  37. 37Slack3SlackService
  38. 38SwitchSwitchLogic
  39. 39Slack4SlackService
  40. 40Switch4SwitchLogic
  41. 41Slack5SlackService
  42. 42Switch5SwitchLogic
  43. 43Wait4WaitLogic
  44. 44Google Sheets10Google SheetsService
  45. 45WaitWaitLogic
  46. 46Gmail3GmailService
  47. 47Gmail4GmailService
  48. 48Gmail5GmailService
  49. 49Wait5WaitLogic
  50. 50Google Sheets11Google SheetsService
  51. 51Google Sheets13Google SheetsService
  52. 52Google Sheets14Google SheetsService
  53. 53Wait6WaitLogic
  54. 54Wait7WaitLogic
  55. 55Wait8WaitLogic

How it's built

Starts on
A clock
Steps
55, with 10 branches, 12 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets, Slack
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

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