Automation library · Chat assistants

Generate strategic business recommendations with OpenAI

Started by a clock, and works across Asana, Gmail, Google Sheets, Postgres and one other. It hands the judgement calls to OpenAI. 24 steps, 2 branches: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

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

The flow

Starts it 1Model 3Logic 9Service 11

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

  1. 1Monthly ScheduleSchedule triggerStarts it
  2. 2OpenAI Chat ModelLm Chat Open AiModel
  3. 3Structured Output ParserOutput Parser StructuredModel
  4. 4Workflow ConfigurationSetLogic
  5. 5AI Strategy AnalyzerAgentModel
  6. 6Fetch Sales DataHttp RequestService
  7. 7Fetch Marketing DataHttp RequestService
  8. 8Fetch Finance DataHttp RequestService
  9. 9Fetch Support DataHttp RequestService
  10. 10Split RecommendationsCodeLogic
  11. 11Calculate MetricsSetLogic
  12. 12Merge All DataAggregateLogic
  13. 13Send Strategy ReportGmailService
  14. 14Create Tasks in AsanaAsanaService
  15. 15Route by PrioritySwitchLogic
  16. 16Store Analysis ResultsPostgresService
  17. 17Build Unified Data ModelSetLogic
  18. 18Validate Data QualityCodeLogic
  19. 19Log to DashboardGoogle SheetsService
  20. 20Send High Priority AlertSlackService
  21. 21Fetch Historical TrendsHttp RequestService
  22. 22Check Data QualityIfLogic
  23. 23Enrich with Historical DataSetLogic
  24. 24Send Data Quality WarningSlackService

How it's built

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

Questions

What does it need to run?

An n8n account, plus your own Asana, Gmail, Google Sheets, Postgres 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 24 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 24 steps before you point it at anything that matters.