Automation library · Chat assistants

Spreadsheet data into smart charts with OpenAI

Started by an event in a connected app, and works across Google Drive, Google Sheets, Postgres and Slack. It hands the judgement calls to OpenAI. 76 steps, 8 branches, 1 loop or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
76 stepsLarge: read it before trusting it with anything live
8Branches: places the flow splits
1Loop or waits
4Services it connects to

The flow

Starts it 1Model 16Logic 23Service 20

The steps in the order they run, from what starts it. The first 60 of 76.

  1. 14.1-miniLm Chat Open AiModel
  2. 2Structured Output ParserOutput Parser StructuredModel
  3. 3Slack TriggerSlack triggerStarts it
  4. 4Structured Output Parser1Output Parser StructuredModel
  5. 5Structured Output Parser3Output Parser StructuredModel
  6. 6Structured Output Parser4Output Parser StructuredModel
  7. 7Structured Output Parser6Output Parser StructuredModel
  8. 8Structured Output Parser9Output Parser StructuredModel
  9. 9Let User Know Upload CompleteAgentModel
  10. 10Review and approvalAgentModel
  11. 11AI AgentAgentModel
  12. 12Bar ChartChain LlmModel
  13. 13Line GraphChain LlmModel
  14. 14Bubble ChartChain LlmModel
  15. 15Doughnut ChartChain LlmModel
  16. 16Pie ChartChain LlmModel
  17. 17Initial ProcessingCodeLogic
  18. 18Message: UserSlackService
  19. 19Message: User 1SlackService
  20. 20IfIfLogic
  21. 21Edit FieldsSetLogic
  22. 22If audioIfLogic
  23. 23Update Thread Memory Session14PostgresService
  24. 24Update Thread Memory Session6PostgresService
  25. 25Get row(s) in sheetGoogle SheetsService
  26. 26HTTP RequestHttp RequestService
  27. 27Switch1SwitchLogic
  28. 28Switch3SwitchLogic
  29. 29Update Thread Memory SessionPostgresService
  30. 30Update Thread Memory Session1PostgresService
  31. 31Loop Over ItemsSplit In BatchesLogic
  32. 32Upload fileGoogle DriveService
  33. 33Process AudioHttp RequestService
  34. 34Set TextSetLogic
  35. 35Process Other FilesSetLogic
  36. 36Process Drive LinksSetLogic
  37. 37Aggregate3AggregateLogic
  38. 38Process Spreadsheet LinksSetLogic
  39. 39Set Titles & LinksSetLogic
  40. 40OpenAIOpen AiModel
  41. 41Merge Text InputMergeLogic
  42. 42Parse Links 1CodeLogic
  43. 43Parse Links 2CodeLogic
  44. 44Switch2SwitchLogic
  45. 45MergeMergeLogic
  46. 46Combine Text InputCodeLogic
  47. 47Log FilesGoogle SheetsService
  48. 48Log Drive LinksGoogle SheetsService
  49. 49Download File2Http RequestService
  50. 50Download File3Http RequestService
  51. 51Download File4Http RequestService
  52. 52Download File5Google DriveService
  53. 53Download File7Google DriveService
  54. 54Switch4SwitchLogic
  55. 55Merge Text & FilesMergeLogic
  56. 56Extract from ExcelExtract From FileService
  57. 57Extract from FileExtract From FileService
  58. 58Extract from File1Extract From FileService
  59. 59SwitchSwitchLogic
  60. 60Combine Text & FilesCodeLogic

How it's built

Starts on
An event in a connected app
Steps
76, with 8 branches, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Google Drive, Google Sheets, Postgres, Slack
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Google Drive, 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 an event in a connected app.

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 76 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 76 steps before you point it at anything that matters.