Automation library · Lead generation

& enrich HubSpot buying groups with Surfe and Google Sheets

Started by an event in a connected app, and works across Gmail, Google Sheets and HubSpot. 22 steps, 1 branch, 1 loop or waits: large, and worth reading before you trust it with anything live.

Large

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

The flow

Starts it 2Logic 11Service 9

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

  1. 1When clicking ‘Execute workflow’Manual triggerStarts it
  2. 2HubSpot TriggerHubspot triggerStarts it
  3. 3GET deal associated companies from HUBSPOTHttp RequestService
  4. 4HubSpot get dealHubspotService
  5. 5HubSpot Get CompanyHubspotService
  6. 6extract deal infoCodeLogic
  7. 7Google Sheets READ CRITERIASGoogle SheetsService
  8. 8extract companyDomainsCodeLogic
  9. 9Merge1MergeLogic
  10. 10MergeMergeLogic
  11. 11prepare email contentCodeLogic
  12. 12prepare JSON PAYLAOD for Person SearchCodeLogic
  13. 13GmailGmailService
  14. 14Search People in CompaniesHttp RequestService
  15. 15Prepare JSON Payload Enrichment RequestCodeLogic
  16. 16Surfe Bulk Enrichments APIHttp RequestService
  17. 17Surfe check enrichement statusHttp RequestService
  18. 18Is enrichment complete ?IfLogic
  19. 19Extract list of peoples from Surfe API responseCodeLogic
  20. 20Wait 3 secondesWaitLogic
  21. 21Filter: phone AND emailFilterLogic
  22. 22HubSpot: Create or UpdateHubspotService

How it's built

Starts on
An event in a connected app
Steps
22, with 1 branch, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets, HubSpot
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

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

What starts it?

It starts on an event in a connected app.

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