HR & RECRUITING

Email-Submitted Scorecard Intake to Notion Candidate Rollup

Parses interviewer feedback emailed to a shared inbox, extracts each rating and recommendation, and appends it to the candidate's running scorecard rollup in Notion.

CategoryHR & Recruiting
Enginepaperclip
Difficultyintermediate
Triggerevent
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew email in scorecard inboxGmailGmail
  • LogicIs this a scorecard submission? Identify candidate
  • ActionExtract ratings, notes, and vote from email body
  • ActionFind or create candidate record in NotionNotionNotion
  • OutputAppend feedback and update running average in NotionNotionNotion

What it does

Monitors a shared Gmail inbox where interviewers reply with their candidate feedback by email. It parses each message to pull the candidate name, the interviewer's competency ratings, and their hire/no-hire vote, then logs the structured result into the candidate's row in a Notion scorecard database so the panel's tally stays current without manual entry.

When to use it

Use this when interviewers prefer to reply by email rather than open a form or board, but you still want a tidy, queryable record of every score in Notion. It is ideal for distributed panels and exec interviewers who live in their inbox.

How it works

  1. 1A new email arrives in the scorecard inbox in Gmail.
  2. 2Confirm the message is a scorecard submission and identify the candidate; skip anything unrelated.
  3. 3Extract the interviewer name, per-competency ratings, written notes, and overall vote from the body.
  4. 4Find or create the candidate's record in the Notion scorecard database.
  5. 5Append this interviewer's structured feedback and update the running average.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect GmailRead, draft, send, label.
  2. 2
    Connect NotionPages, databases, comments.
  3. 3
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  4. 4
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  5. 5
    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.