Automation library · Chat assistants

Record Property Maintenance Issues with Slack

Started by another system calling it, and works across Gmail, Google Drive, Google Sheets, Slack and one other. It hands the judgement calls to OpenAI. 31 steps, 3 branches: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

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

The flow

Starts it 5Model 1Logic 17Service 8

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

  1. 1WebhookWebhookStarts it
  2. 2Error TriggerError triggerStarts it
  3. 3Is Challenge Request?IfLogic
  4. 4Format Error DataCodeLogic
  5. 5Respond with ChallengeRespond To WebhookStarts it
  6. 6Filter Unwanted EventsIfLogic
  7. 7Log Error to TableData TableService
  8. 8Extract Slack EventSetLogic
  9. 9Respond OK - Filtered EventRespond To WebhookStarts it
  10. 10Send a messageSlackService
  11. 11Generate Reference & Extract CoreCodeLogic
  12. 12Process & Categorize FilesCodeLogic
  13. 13Format OutputSetLogic
  14. 14Respond to WebhookRespond To WebhookStarts it
  15. 15Has Photos or Videos?IfLogic
  16. 16Check for Voice NotesCodeLogic
  17. 17Create FolderGoogle DriveService
  18. 18No Folder NeededCodeLogic
  19. 19Download Voice NoteHttp RequestService
  20. 20Aggregate TranscriptionsCodeLogic
  21. 21Prep Files for UploadCodeLogic
  22. 22Merge Folder with Final OutputMergeLogic
  23. 23Transcribe RecordingOpen AiModel
  24. 24Add Transcriptions to ResultCodeLogic
  25. 25Download from SlackHttp RequestService
  26. 26Prepare Sheet DataCodeLogic
  27. 27Upload to DriveGoogle DriveService
  28. 28Add to Google SheetGoogle SheetsService
  29. 29Extract Email DataCodeLogic
  30. 30Format Professional EmailCodeLogic
  31. 31Send Email NotificationGmailService

How it's built

Starts on
Another system calling it
Steps
31, with 3 branches
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Drive, Google Sheets, Slack, n8n data table
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Gmail, Google Drive, 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 another system calling it.

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