Automation library · Research and reporting

Customer feedback analysis with HTML

Started by an event in a connected app, and works across Gmail and Google Sheets. It hands the judgement calls to OpenAI. 34 steps: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

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

The flow

Starts it 1Model 22Logic 9Service 2

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

  1. 1When clicking ‘Test workflow’Manual triggerStarts it
  2. 2OpenAI Chat ModelLm Chat Open AiModel
  3. 3Structured Output ParserOutput Parser StructuredModel
  4. 4OpenAI Chat Model1Lm Chat Open AiModel
  5. 5Structured Output Parser1Output Parser StructuredModel
  6. 6OpenAI Chat Model2Lm Chat Open AiModel
  7. 7Structured Output Parser2Output Parser StructuredModel
  8. 8OpenAI Chat Model3Lm Chat Open AiModel
  9. 9Structured Output Parser3Output Parser StructuredModel
  10. 10OpenAI Chat Model4Lm Chat Open AiModel
  11. 11Structured Output Parser4Output Parser StructuredModel
  12. 12OpenAI Chat Model5Lm Chat Open AiModel
  13. 13Structured Output Parser5Output Parser StructuredModel
  14. 14OpenAI Chat Model6Lm Chat Open AiModel
  15. 15OpenAI Chat Model7Lm Chat Open AiModel
  16. 16Google SheetsGoogle SheetsService
  17. 17Unified AI Agent for analysisAgentModel
  18. 18analysis topics proposalAgentModel
  19. 19proposal refinement agentAgentModel
  20. 20Second iteration of analysisAgentModel
  21. 21Summarization of the unalysed resultsAgentModel
  22. 22Final report editorAgentModel
  23. 23Revisor and HTML formating agentAgentModel
  24. 24Completion agents (optional)AgentModel
  25. 25Get the first n rowsFilterLogic
  26. 26Merge original table and the promptsMergeLogic
  27. 27MergeMergeLogic
  28. 28Transform results into columnsCodeLogic
  29. 29wrap up the whole results into one Json fileCodeLogic
  30. 30Edit FieldsSetLogic
  31. 31Merging first sample rowsCodeLogic
  32. 32Prepare Prompts1FunctionLogic
  33. 33All unique elements mergeCodeLogic
  34. 34GmailGmailService

How it's built

Starts on
An event in a connected app
Steps
34
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets
Model
OpenAI

Questions

What does it need to run?

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