Automation library · Lead generation

Lead workflow: Yelp & Trustpilot scraping + OpenAI analysis

Started by someone submitting a form, and works across Gmail and Google Sheets. It hands the judgement calls to Claude and Gemini. 30 steps, 4 branches, 4 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: Claude, Gemini

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

The flow

Starts it 1Model 4Logic 14Service 11

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

  1. 1Form Trigger - Get User InputForm triggerStarts it
  2. 2Gemini - Location AI ModelLm Chat Google GeminiModel
  3. 3Claude - Email AI ModelLm Chat AnthropicModel
  4. 4AI Location AnalyzerAgentModel
  5. 5AI Generate Email ContentAgentModel
  6. 6Split Sub-locationsCodeLogic
  7. 7Parse Email JSONCodeLogic
  8. 8Loop Yelp LocationsSplit In BatchesLogic
  9. 9Send Outreach EmailGmailService
  10. 10Clean Unique WebsitesCodeLogic
  11. 11Yelp ScraperHttp RequestService
  12. 12Loop Trustpilot URLsSplit In BatchesLogic
  13. 13Read Yelp Sheet WebsitesGoogle SheetsService
  14. 14Check Yelp Scrape ProgressHttp RequestService
  15. 15Trigger Trustpilot ScraperHttp RequestService
  16. 16Make Trustpilot URLsCodeLogic
  17. 17Wait (1 min) Yelp CompletionWaitLogic
  18. 18Check Trustpilot Scrape ProgressHttp RequestService
  19. 19Remove Duplicate TP URLsCodeLogic
  20. 20Verify Yelp ReadyIfLogic
  21. 21Verify Trustpilot Scraper ReadyIfLogic
  22. 22If Yelp Has RecordsIfLogic
  23. 23If Trustpilot Has RecordsIfLogic
  24. 24Wait (1 min) Trustpilot CompletionWaitLogic
  25. 25Fetch Yelp ResultsHttp RequestService
  26. 26Download Trustpilot DataHttp RequestService
  27. 27Save Yelp Data to SheetGoogle SheetsService
  28. 28Save Trustpilot Data to SheetGoogle SheetsService
  29. 29Read Emails from Trustpilot SheetGoogle SheetsService
  30. 30Get Unique EmailsCodeLogic

How it's built

Starts on
Someone submitting a form
Steps
30, with 4 branches, 4 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets
Model
Claude, Gemini

Questions

What does it need to run?

An n8n account, plus your own Gmail and Google Sheets accounts, and a key for Claude and Gemini. 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?

Yes. It calls Claude and Gemini. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

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