Automation library · Research and reporting

Orchestrate sustainability lifecycle analytics with OpenAI

Started by someone submitting a form, and works across Gmail, Slack and n8n data table. It puts OpenAI behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 33 steps, 1 branch: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAIRetrieval

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

The flow

Starts it 3Model 14Logic 7Service 9

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

  1. 1Monitor Lifecycle DataSchedule triggerStarts it
  2. 2Receive Sustainability DataWebhookStarts it
  3. 3Initiative Submission FormForm triggerStarts it
  4. 4Orchestrator ModelLm Chat Open AiModel
  5. 5Orchestrator Output ParserOutput Parser StructuredModel
  6. 6Shared MemoryMemory Buffer WindowModel
  7. 7Circular Economy ModelLm Chat Open AiModel
  8. 8Circular Economy OutputOutput Parser StructuredModel
  9. 9Metrics CalculatorTool CalculatorModel
  10. 10Governance ModelLm Chat Open AiModel
  11. 11Governance OutputOutput Parser StructuredModel
  12. 12Documentation ModelLm Chat Open AiModel
  13. 13Documentation OutputOutput Parser StructuredModel
  14. 14Create ESG DocumentGoogle Docs ToolService
  15. 15Send Approval NotificationSlack ToolService
  16. 16Combine Input SourcesMergeLogic
  17. 17Fetch External Sustainability DataHttp RequestService
  18. 18Sustainability OrchestratorAgentModel
  19. 19Circular Economy AgentAgent ToolModel
  20. 20Sustainability Governance AgentAgent ToolModel
  21. 21Documentation AgentAgent ToolModel
  22. 22Approval Request ToolSlack Hitl ToolService
  23. 23Route by ActionSwitchLogic
  24. 24Prepare Lifecycle DataSetLogic
  25. 25Prepare Governance DataSetLogic
  26. 26Prepare Documentation DataSetLogic
  27. 27Track Lifecycle AnalysisData TableService
  28. 28Track Governance ApprovalsData TableService
  29. 29Track ESG DocumentationData TableService
  30. 30Combine All ResultsMergeLogic
  31. 31Aggregate MetricsAggregateLogic
  32. 32Send Summary NotificationSlackService
  33. 33Send Stakeholder ReportGmailService

How it's built

Starts on
Someone submitting a form
Steps
33, with 1 branch
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Slack, n8n data table
Model
OpenAI
Retrieval
Answers are drawn from documents you supply, not from the model alone

Questions

What does it need to run?

An n8n account, plus your own Gmail and Slack accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on someone submitting a form.

Does it use AI?

Yes. It calls OpenAI. Its answers draw on documents you give it, not on the model alone. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

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