Automation library · Lead generation

Manage lead follow-ups with Google Sheets and SMTP

Started by another system calling it, and works across Email and Google Sheets. 26 steps, 3 branches: large, and worth reading before you trust it with anything live.

Large

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

The flow

Starts it 2Logic 15Service 9

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

  1. 1When Lead Form Is SubmittedWebhookStarts it
  2. 2Trigger Daily Follow-Up CheckSchedule triggerStarts it
  3. 3When Lead Replies By EmailEmail Read ImapService
  4. 4Parse Incoming Lead DataCodeLogic
  5. 5Fetch Follow-Up Tracker DataGoogle SheetsService
  6. 6Parse Reply Email SenderCodeLogic
  7. 7Build Acknowledgment Email ContentCodeLogic
  8. 8Calculate Due Follow-Up StageCodeLogic
  9. 9Read Tracker For Reply MatchGoogle SheetsService
  10. 10Check Ack Email ComplianceExecute WorkflowLogic
  11. 11Build Follow-Up Email ContentCodeLogic
  12. 12If Lead Reached Final StageIfLogic
  13. 13Match Reply To Lead TrackerCodeLogic
  14. 14If Ack Email Is ApprovedIfLogic
  15. 15Check Follow-Up Email ComplianceExecute WorkflowLogic
  16. 16Build No-Response Alert EmailCodeLogic
  17. 17Skip Alert For Non-Final StageNo OpLogic
  18. 18Mark Lead As Responded In SheetGoogle SheetsService
  19. 19Send Acknowledgment EmailEmail SendService
  20. 20Skip Ack Email For Opt-Out LeadNo OpLogic
  21. 21If Follow-Up Email ApprovedIfLogic
  22. 22Send No-Response Alert EmailEmail SendService
  23. 23Append Lead To Follow-Up SheetGoogle SheetsService
  24. 24Send Follow-Up EmailEmail SendService
  25. 25Skip Follow-Up For Opted-Out LeadNo OpLogic
  26. 26Update Tracker Post Follow-UpGoogle SheetsService

How it's built

Starts on
Another system calling it
Steps
26, with 3 branches
Size
Large: read it before trusting it with anything live
Connects to
Email, Google Sheets
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

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

What starts it?

It starts on another system calling it.

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 26 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 26 steps before you point it at anything that matters.