Skip to Workflow Atlas
ETL PipelineAI systemIntermediate

Daily Churn Risk Offer Automation

Daily Churn Risk Offer Automation is a 12-node automation blueprint connecting Google Sheets, Gmail, Google Palm API. Inspect its trigger, execution graph, branches, and implementation requirements.

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.

12

Nodes

12

Links

1

Run groups

Connected tools

3 integrations

  • Google Sheets
  • Gmail
  • Google AI

Canvas controls

Fit wide systems, then zoom into any run group.

Daily Churn Risk Offer Automation execution lanes1 run groups containing 12 workflow nodes and 12 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.Scheduled Start: Daily Churn Check. trigger node, scheduleTrigger. 0 incoming and 1 outgoing connections.STARTScheduled Start: Daily Ch…TRIGGERSCHEDULETRIGGER0 IN / 1 OUTFetch Customer Data from Sheet. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 02Fetch Customer Data from …GOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTFilter High Churn Risk & No Campaign Customers. decision node, filter. 1 incoming and 1 outgoing connections.STEP 03Filter High Churn Risk & …DECISIONFILTER1 IN / 1 OUTCheck if Eligible Customers Found. decision node, if. 1 incoming and 2 outgoing connections.STEP 04Check if Eligible Custome…DECISIONIF1 IN / 2 OUTSet 'Not Found' Status. transform node, set. 1 incoming and 1 outgoing connections.STEP 05Set 'Not Found' StatusTRANSFORMSET1 IN / 1 OUTLog 'Not Found' in System Log. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.STEP 06Log 'Not Found' in System…GOOGLE SHEETSGOOGLESHEETS1 IN / 0 OUTProcess Each Eligible Customer. integration node, splitInBatches. 2 incoming and 1 outgoing connections.STEP 07Process Each Eligible Cus…INTEGRATIONSPLITINBATCHES2 IN / 1 OUTGenerate Win-Back Offer. ai node, chainLlm. 3 incoming and 1 outgoing connections.STEP 08Generate Win-Back OfferAICHAINLLM3 IN / 1 OUTLog Sent Offer in System Log. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 09Log Sent Offer in System …GOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTSend Win-Back Offer via Email. Gmail node, gmail. 1 incoming and 1 outgoing connections.OUTCOMESend Win-Back Offer via E…GMAILGMAIL1 IN / 1 OUT(LLM Model for Offer Generation). Google AI node, lmChatGoogleGemini. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1(LLM Model for Offer Gene…GOOGLE AILMCHATGOOGLEGEMINI0 IN / 1 OUT(Parse Offer JSON). ai node, outputParserStructured. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1(Parse Offer JSON)AIOUTPUTPARSERSTRUCTURED0 IN / 1 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.12 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

Scheduled Start: Daily Churn C…

10 Execution Links2 Support Dependencies
  1. Start

    Scheduled Start: Daily Churn Check

    Trigger

  2. Step 2

    Fetch Customer Data from Sheet

    Integration

  3. Step 3

    Filter High Churn Risk & No Campaign Customers

    Decision

  4. Step 4

    Check if Eligible Customers Found

    Decision

  5. Step 5

    Set 'Not Found' Status

    Transform

  6. Step 6

    Log 'Not Found' in System Log

    Integration

  7. Step 7

    Process Each Eligible Customer

    Integration

  8. Step 8

    Generate Win-Back Offer

    AI reasoning

  9. Step 9

    Log Sent Offer in System Log

    Integration

  10. Outcome

    Send Win-Back Offer via Email

    Integration

Attached dependencies

These nodes support the runtime above; they are not additional starts or outcomes.

2 nodes
  • (LLM Model for Offer Generation)

    AI reasoning dependency

  • (Parse Offer JSON)

    AI reasoning dependency

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.