Automation library · Chat assistants

Govern energy portfolios with OpenAI and Perplexity

Started by a clock, and works across Gmail, Google Sheets and Slack. It hands the judgement calls to OpenAI. 22 steps: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

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

The flow

Starts it 1Model 11Logic 2Service 8

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

  1. 1Energy Analysis ScheduleSchedule triggerStarts it
  2. 2Governance ModelLm Chat Open AiModel
  3. 3Structured KPI OutputOutput Parser StructuredModel
  4. 4Forecasting ModelLm Chat Open AiModel
  5. 5Weather ModelLm Chat Open AiModel
  6. 6Policy ModelLm Chat Open AiModel
  7. 7Energy CalculatorTool CalculatorModel
  8. 8Optimization Algorithm ToolTool CodeModel
  9. 9External Data API ToolHttp Request ToolService
  10. 10Sustainability Research ToolPerplexity ToolService
  11. 11Fetch Weather DataHttp RequestService
  12. 12Fetch Energy DemandHttp RequestService
  13. 13Fetch Renewable GenerationHttp RequestService
  14. 14Energy Governance AgentAgentModel
  15. 15Renewable Forecasting AgentAgent ToolModel
  16. 16Weather Analysis AgentAgent ToolModel
  17. 17Policy Compliance AgentAgent ToolModel
  18. 18Combine Energy DataMergeLogic
  19. 19Prepare Sheet DataSetLogic
  20. 20Send Sustainability AlertSlackService
  21. 21Email Performance DashboardGmailService
  22. 22Store Energy KPIsGoogle SheetsService

How it's built

Starts on
A clock
Steps
22
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets, Slack
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Sheets 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 a clock.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

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.