Generate unique reference number, log details in spreadsheet, and notify submitter via email

Generate unique reference numbers for product questionnaire submissions, log details in Google Sheets, and notify submitters via email with confirmation and next steps, ensuring efficient tracking and communication.