title: Google form auto assign different staff once submitted
body: <p>Im creating student list for our library. The student will submit their info (Name and ID) through google form. Once the student submit, I would like to assign each student to different staff (total of 5 staffs) (Column D). Something like screenshot below. Could someone help me get this done? BTW, is it possible to send email too to the assign staff email?</p>
  <p><a href="https://i.stack.imgur.com/YBsku.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YBsku.png" alt="" /></a></p>