Automation library · Lead generation

Automate lead enrichment & personalized outreach with HubSpot

Started by another system calling it, and works across Gmail, Google Sheets and HubSpot. It hands the judgement calls to OpenAI. 24 steps, 1 branch, 2 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
24 stepsLarge: read it before trusting it with anything live
1Branch: places the flow splits
2Loops or waits
3Services it connects to

The flow

Starts it 1Model 2Logic 10Service 11

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

  1. 1🔗 HubSpot Contact WebhookWebhookStarts it
  2. 2🤖 OpenAI Language ModelLm Chat Open AiModel
  3. 3👤 Fetch ContactHubspotService
  4. 4🧠 Generate Personalized EmailAgentModel
  5. 5📝 Update Sheet with Users Twitter/LinkedInGoogle SheetsService
  6. 6✂️ Parse Email ContentCodeLogic
  7. 7✅ Validate Twitter/LinkedIn ExistsIfLogic
  8. 8📧 Sends EmailGmailService
  9. 9🚀 Launch Profile ScraperHttp RequestService
  10. 10🎯 Launch Tweet ScraperHttp RequestService
  11. 11⏳ Wait for Profile ProcessingWaitLogic
  12. 12⏳ Wait for Tweet ProcessingWaitLogic
  13. 13📊 Fetch Profile ResultsHttp RequestService
  14. 14📊 Fetch Tweet ResultsHttp RequestService
  15. 15🔍 Extract Profile URLCodeLogic
  16. 16🔍 Extract Tweet URLCodeLogic
  17. 17📥 Download Profile DataHttp RequestService
  18. 18📋 Download Tweet JSONHttp RequestService
  19. 19📋 Parse Profile JSONExtract From FileService
  20. 20📋 Parse Tweet JSONExtract From FileService
  21. 21🏷️ Format Profile FieldsSetLogic
  22. 22🏷️ Format Tweet FieldsSetLogic
  23. 23🔄 Merge Data StreamsMergeLogic
  24. 24🧩 Combine All DataCodeLogic

How it's built

Starts on
Another system calling it
Steps
24, with 1 branch, 2 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets, HubSpot
Model
OpenAI

Questions

What does it need to run?

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

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

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