Skip to Workflow Atlas
Playbook AtlasWorkflow Atlas
Workflow blueprintBrowse workflows
ETL PipelineAI systemIntermediate

Automated Lead Enrichment & Reporting Workflow

Automated Lead Enrichment & Reporting Workflow is a 25-node automation blueprint connecting Apollo API, Google Sheets, Slack. Inspect its trigger, execution graph, branches, and implementation requirements.

Apollo APIGoogle SheetsSlackOpenAI

Interactive system map

Follow the runtime. Inspect what supports it.

Solid horizontal paths show main-channel execution. Violet dependencies sit beneath the exact step they configure or empower.

25

Nodes

26

Links

2

Run groups

Connected tools

4 integrations

  • Apollo API
  • Google Sheets
  • Slack
  • OpenAI

Canvas controls

Fit wide systems, then zoom into any run group.

Automated Lead Enrichment & Reporting Workflow execution lanes2 run groups containing 25 workflow nodes and 26 visible links. Solid horizontal lines are main-channel runtime links. Violet dashed lines connect typed dependencies beneath the runtime step they support. Focus any node to inspect its immediate path.Google Sheets Trigger. Google Sheets node, googleSheetsTrigger. 0 incoming and 1 outgoing connections.STARTGoogle Sheets TriggerGOOGLE SHEETSGOOGLESHEETSTRIGGER0 IN / 1 OUTSelect Unprocessed Companies. decision node, filter. 1 incoming and 1 outgoing connections.STEP 02Select Unprocessed Compan…DECISIONFILTER1 IN / 1 OUTIs Domain Already Provided?. decision node, if. 1 incoming and 2 outgoing connections.STEP 03Is Domain Already Provided?DECISIONIF1 IN / 2 OUTApollo Organization Search. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 04Apollo Organization SearchINTEGRATIONHTTPREQUEST1 IN / 1 OUTAdd Company Website. Google Sheets node, googleSheets. 1 incoming and 2 outgoing connections.STEP 05Add Company WebsiteGOOGLE SHEETSGOOGLESHEETS1 IN / 2 OUTApprove Company Website. Slack node, slack. 1 incoming and 0 outgoing connections.STEP 06Approve Company WebsiteSLACKSLACK1 IN / 0 OUTMerge Rows Which Now All Contain Domains. decision node, merge. 2 incoming and 1 outgoing connections.STEP 06Merge Rows Which Now All …DECISIONMERGE2 IN / 1 OUTApollo Organization Enrichment. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 07Apollo Organization Enric…INTEGRATIONHTTPREQUEST1 IN / 1 OUTSummarize Core Business. OpenAI node, openAi. 1 incoming and 1 outgoing connections.STEP 08Summarize Core BusinessOPENAIOPENAI1 IN / 1 OUTAdd Company Details. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 09Add Company DetailsGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTLoop Over Items (1000 per Batch). integration node, splitInBatches. 2 incoming and 2 outgoing connections.STEP 10Loop Over Items (1000 per…INTEGRATIONSPLITINBATCHES2 IN / 2 OUTSplit Out Batched Decision Maker Response. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 11Split Out Batched Decisio…TRANSFORMSPLITOUT1 IN / 1 OUTCreate Apollo People Search URL. transform node, code. 1 incoming and 1 outgoing connections.STEP 12Create Apollo People Sear…TRANSFORMCODE1 IN / 1 OUTDetermine Contact's Department. OpenAI node, openAi. 1 incoming and 1 outgoing connections.STEP 13Determine Contact's Depar…OPENAIOPENAI1 IN / 1 OUTApollo Find Decision Makers. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 14Apollo Find Decision MakersINTEGRATIONHTTPREQUEST1 IN / 1 OUTAdd Contacts. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 15Add ContactsGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTLoop Over Items For Bulk Enrichment (10 per batch). integration node, splitInBatches. 2 incoming and 2 outgoing connections.STEP 16Loop Over Items For Bulk …INTEGRATIONSPLITINBATCHES2 IN / 2 OUTSplit Out Batched Enrichment Response. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 17Split Out Batched Enrichm…TRANSFORMSPLITOUT1 IN / 1 OUTCreate Apollo People Enrichment Payload. transform node, code. 1 incoming and 1 outgoing connections.STEP 18Create Apollo People Enri…TRANSFORMCODE1 IN / 1 OUTEnrich Contacts. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.STEP 19Enrich ContactsGOOGLE SHEETSGOOGLESHEETS1 IN / 0 OUTApollo Enrich Decision Makers. integration node, httpRequest. 1 incoming and 1 outgoing connections.OUTCOMEApollo Enrich Decision Ma…INTEGRATIONHTTPREQUEST1 IN / 1 OUTWeekly Report Trigger. trigger node, scheduleTrigger. 0 incoming and 1 outgoing connections.STARTWeekly Report TriggerTRIGGERSCHEDULETRIGGER0 IN / 1 OUTRetrieve Verified Leads. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 02Retrieve Verified LeadsGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTDerive Past Week's Lead Gen. Metrics. transform node, code. 1 incoming and 1 outgoing connections.STEP 03Derive Past Week's Lead G…TRANSFORMCODE1 IN / 1 OUTSend Weekly Report. Slack node, slack. 1 incoming and 0 outgoing connections.OUTCOMESend Weekly ReportSLACKSLACK1 IN / 0 OUT

Signal inspector

Focus, hover, or select a step to isolate its runtime and support links.

Main-channel runtimeTyped dependencytriggeraidecisiontransformintegration
Scroll horizontally to follow every connected flow.25 connected nodesEnter or click to lock · Escape to clear

Runtime breakdown

Read the execution spine before its dependencies.

Each run group separates main-channel steps from the models, tools, retrievers, and data services that support them. Start and outcome labels apply only to runtime nodes.

01

Run Group

Google Sheets Trigger

23 Execution Links

  1. Start

    Google Sheets Trigger

    Trigger

  2. Step 2

    Select Unprocessed Companies

    Decision

  3. Step 3

    Is Domain Already Provided?

    Decision

  4. Step 4

    Apollo Organization Search

    Integration

  5. Step 5

    Add Company Website

    Integration

  6. Step 6

    Approve Company Website

    Integration

    Merge Rows Which Now All Contain Domains

    Decision

  7. Step 7

    Apollo Organization Enrichment

    Integration

  8. Step 8

    Summarize Core Business

    AI reasoning

  9. Step 9

    Add Company Details

    Integration

  10. Step 10

    Loop Over Items (1000 per Batch)

    Integration

  11. Step 11

    Split Out Batched Decision Maker Response

    Transform

  12. Step 12

    Create Apollo People Search URL

    Transform

  13. Step 13

    Determine Contact's Department

    AI reasoning

  14. Step 14

    Apollo Find Decision Makers

    Integration

  15. Step 15

    Add Contacts

    Integration

  16. Step 16

    Loop Over Items For Bulk Enrichment (10 per batch)

    Integration

  17. Step 17

    Split Out Batched Enrichment Response

    Transform

  18. Step 18

    Create Apollo People Enrichment Payload

    Transform

  19. Step 19

    Enrich Contacts

    Integration

  20. Outcome

    Apollo Enrich Decision Makers

    Integration

02

Run Group

Weekly Report Trigger

3 Execution Links

  1. Start

    Weekly Report Trigger

    Trigger

  2. Step 2

    Retrieve Verified Leads

    Integration

  3. Step 3

    Derive Past Week's Lead Gen. Metrics

    Transform

  4. Outcome

    Send Weekly Report

    Integration

Turn the map into a plan

Adapt this blueprint to your company.

Bring the system shape into a workspace, then define the production controls, data boundaries, owners, and delivery sequence around your context.

Create a build planReturn to the atlas