Psychometric Feedback Generator

Apps Script pipeline that writes role-specific development feedback for every questionnaire item. A person then reviewed samples of the output.

Pipeline

How the feedback generator works Four spreadsheet tabs feed an Apps Script, which prepares one batch per trait and role. Claude writes one feedback block per item and checks it against the writing rules in the prompt. The blocks go to an output sheet, and a person reviews a sample. Four input tabs personas, traits, items, target grid one trait x role at a time Apps Script prepares flips reverse items, fills the prompt one batched request Claude writes feedback one block per item, self-checked feedback blocks Output sheet role, item id, feedback block a sample Human review (sample) a person reads samples after generation Automated A person does this

Pick a role and a trait

Input

Questionnaire item
Item type
Trait definition
Role context
Target answer

Feedback block

Raw output written to the sheet

    

  


  

    
Review

    
    

    

  


  

    
Writing rules the generator follows