HR & RECRUITING

Email Interview Notes to Structured Scorecard Parser

Catches free-form interview feedback emailed by panelists, extracts competency ratings and a recommendation with AI.

CategoryHR & Recruiting
Enginesim
Difficultyintermediate
Triggerevent
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerFeedback email receivedGmailGmail
  • ActionExtract ratings and lean from emailOpenAI
  • LogicConfident and complete enough?
  • ActionWrite structured scorecard rowAirtableAirtable
  • OutputReply requesting specifics if thinGmailGmail

What it does

Many interviewers reply with feedback as a quick email instead of filling out a form. This watches a dedicated feedback inbox, parses each message into structured fields (competencies, evidence, lean, confidence), and writes a clean scorecard row to your tracker. It also flags emails that are too vague to score so the recruiter can ask for more.

When to use it

Use it when your panel resists structured forms but you still need comparable, searchable scorecards. It meets interviewers where they are and does the normalization for you.

How it works

  1. 1Gmail triggers on a new message in the interview-feedback label.
  2. 2An OpenAI step extracts per-competency ratings, supporting evidence, and an overall lean from the email body.
  3. 3A logic step checks whether the extraction met a minimum confidence and completeness bar.
  4. 4Sufficient feedback is written as a structured scorecard row in Airtable.
  5. 5Thin or ambiguous feedback triggers a reply asking the interviewer for specifics.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect GmailRead, draft, send, label.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect AirtableBases, tables, views, automations.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.