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

The entire automation, wired and inspectable.

Brand marks identify the operational stack. Focus or select any node to isolate its real incoming and outgoing connections.

12

Nodes

12

Edges

6

Zones

System stack

3 integrations

  • Google Sheets
  • Gmail
  • Google AI
Daily Churn Risk Offer Automation interactive execution graphStructural view of 12 workflow nodes and 12 visible connections. Focus any node to inspect its connected path. Parameters and credentials are intentionally excluded.Scheduled Start: Daily Churn Check. trigger node, scheduleTrigger. 0 incoming and 1 outgoing connections.Scheduled Start: Daily Ch…TRIGGERSCHEDULETRIGGER0 IN / 1 OUTFetch Customer Data from Sheet. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.Fetch Customer Data from …GOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTFilter High Churn Risk & No Campaign Customers. decision node, filter. 1 incoming and 1 outgoing connections.Filter High Churn Risk & …DECISIONFILTER1 IN / 1 OUTCheck if Eligible Customers Found. decision node, if. 1 incoming and 2 outgoing connections.Check if Eligible Custome…DECISIONIF1 IN / 2 OUTProcess Each Eligible Customer. integration node, splitInBatches. 2 incoming and 1 outgoing connections.Process Each Eligible Cus…INTEGRATIONSPLITINBATCHES2 IN / 1 OUTSet 'Not Found' Status. transform node, set. 1 incoming and 1 outgoing connections.Set 'Not Found' StatusTRANSFORMSET1 IN / 1 OUTLog 'Not Found' in System Log. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.Log 'Not Found' in System…GOOGLE SHEETSGOOGLESHEETS1 IN / 0 OUTGenerate Win-Back Offer. ai node, chainLlm. 3 incoming and 1 outgoing connections.Generate Win-Back OfferAICHAINLLM3 IN / 1 OUT(LLM Model for Offer Generation). Google AI node, lmChatGoogleGemini. 0 incoming and 1 outgoing connections.(LLM Model for Offer Gene…GOOGLE AILMCHATGOOGLEGEMINI0 IN / 1 OUT(Parse Offer JSON). ai node, outputParserStructured. 0 incoming and 1 outgoing connections.(Parse Offer JSON)AIOUTPUTPARSERSTRUCTURED0 IN / 1 OUTLog Sent Offer in System Log. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.Log Sent Offer in System …GOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTSend Win-Back Offer via Email. Gmail node, gmail. 1 incoming and 1 outgoing connections.Send Win-Back Offer via E…GMAILGMAIL1 IN / 1 OUT

Signal inspector

Focus, hover, or select a node to illuminate its real path.

triggeraidecisiontransformintegration
Scroll horizontally to inspect every zone.12 connected nodesEnter or click to lock · Escape to clear

Structured review

Read the workflow as a system, not a node dump.

The workflow is grouped into operational zones, then reviewed for the controls needed to adapt the pattern safely.

01

Entry signals

1 node

Events, schedules, and unconnected roots that can start an execution.

Scheduled Start: Daily Churn Check

Trigger

02

Data & operations

5 nodes

Transformations and external-system actions that move the work forward.

Fetch Customer Data from Sheet

Integration

Process Each Eligible Customer

Integration

Log Sent Offer in System Log

Integration

Send Win-Back Offer via Email

Integration

Set 'Not Found' Status

Transform

03

Intelligence & routing

5 nodes

Model calls and control points that interpret, branch, or govern the run.

Filter High Churn Risk & No Campaign Customers

Decision

Check if Eligible Customers Found

Decision

Generate Win-Back Offer

AI reasoning

(LLM Model for Offer Generation)

AI reasoning

(Parse Offer JSON)

AI reasoning

04

Terminal actions

1 node

Nodes with no visible outgoing edge: the workflow’s observable outcomes.

Log 'Not Found' in System Log

Integration

Adjacent systems

Keep tracing the stack.

Related workflows share tools and similar system patterns.

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.