Automation library · Hiring

AI-Powered Interview Transcript Evaluation

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

LargeCalls a model: OpenAI

21 stepsLarge: read it before trusting it with anything live
3Branches: places the flow splits
0Loops or waits
1Service it connects to

The flow

Starts it 1Model 3Logic 11Service 6

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

  1. 1Manual TriggerManual triggerStarts it
  2. 2OpenAI Chat ModelLm Chat Open AiModel
  3. 3Structured Output ParserOutput Parser StructuredModel
  4. 4Workflow ConfigurationSetLogic
  5. 5AI EvaluatorAgentModel
  6. 6Read Raw_TranscriptsGoogle SheetsService
  7. 7Check for ErrorsIfLogic
  8. 8Filter NEW StatusCodeLogic
  9. 9Flatten Evaluation JSONCodeLogic
  10. 10Update Status ERRORGoogle SheetsService
  11. 11Extract Doc IDCodeLogic
  12. 12Append to Candidates_SummaryGoogle SheetsService
  13. 13Check Doc ID ExistsIfLogic
  14. 14Read Config JDGoogle SheetsService
  15. 15Fetch Transcript TextHttp RequestService
  16. 16Update Raw_Transcripts StatusGoogle SheetsService
  17. 17MergeMergeLogic
  18. 18Error - No Doc IDSetLogic
  19. 19Check Transcript ExistsIfLogic
  20. 20LLM Inputs1CodeLogic
  21. 21Error - No TranscriptSetLogic

How it's built

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

Questions

What does it need to run?

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