Automation library · Lead generation

Extract & enrich LinkedIn comments to leads

Started by someone submitting a form, and works across Google Sheets. 28 steps, 1 branch, 2 loops or waits: large, and worth reading before you trust it with anything live.

Large

28 stepsLarge: read it before trusting it with anything live
1Branch: places the flow splits
2Loops or waits
1Service it connects to

The flow

Starts it 2Logic 20Service 6

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

  1. 1Trigger manuallyManual triggerStarts it
  2. 2On form submissionForm triggerStarts it
  3. 3Set manual fieldsSetLogic
  4. 4Set fields from the formSetLogic
  5. 5Set APIFY TokenSetLogic
  6. 6Run Apify Comments ScraperHttp RequestService
  7. 7AggregateAggregateLogic
  8. 8More runs needed?IfLogic
  9. 9Set paginationCodeLogic
  10. 10Create Unique List of LeadsCodeLogic
  11. 11Split OutSplit OutLogic
  12. 12Split in batchesCodeLogic
  13. 13Loop Over CommentsSplit In BatchesLogic
  14. 14Split Out BatchesSplit OutLogic
  15. 15Aggregate All CommentsAggregateLogic
  16. 16Run Apify Comments Scraper LoopHttp RequestService
  17. 17Loop Over ProfilesSplit In BatchesLogic
  18. 18Gather All CommentsSetLogic
  19. 19Aggregate CommentsAggregateLogic
  20. 20Aggregate All ProfilesAggregateLogic
  21. 21Run Apify Profile EnrichmentHttp RequestService
  22. 22Prepare the list for exportCodeLogic
  23. 23Aggregate ProfilesAggregateLogic
  24. 24Create Google SheetGoogle SheetsService
  25. 25Convert to FileConvert To FileService
  26. 26Set the list for sheetsCodeLogic
  27. 27Add LeadsGoogle SheetsService
  28. 28DoneNo OpLogic

How it's built

Starts on
Someone submitting a form
Steps
28, with 1 branch, 2 loops 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 someone submitting a form.

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.