Here is how to implement: Create an Issue Tracking System with Google Form and Spreadsheet
Email sending is disabled in the script, so no mails will be sent.
Click here to open this sheet in a new tab