Copy specific Google Form response values into different Google Sheet <p>I have a Google Form that has many questions, but I only want to record some of the responses into a separate, condensed spreadsheet. These are the responses I want to record:</p> <pre><code>First Name Last Name Company Role </code></pre> <p>This is my script, which is triggered to execute on form submission:</p> <pre><code>function copyCondensedResponseData(e) { var array_to_paste_in_participant_attendance_sheet = []; array_to_paste_in_participant_attendance_sheet.push(e.namedValues["First Name"].toString()); array_to_paste_in_participant_attendance_sheet.push(e.namedValues["Last Name"].toString()); array_to_paste_in_participant_attendance_sheet.push(e.namedValues["Role"].toString()); array_to_paste_in_participant_attendance_sheet.push(e.namedValues["Company"].toString()); var participant_attendance_sheet = SpreadsheetApp.openById(/* id */).getSheets()[0]; participant_attendance_sheet.getRange(participant_attendance_sheet.getLastRow()+1,1).getValues()[0] = array_to_paste_in_participate_attendance_sheet; } </code></pre> <p>But nothing is pasted into the participate_attendance_sheet. I know that typically you copy data from one sheet into another by calling getRange() and setValues(), but I think that's only if the data I want to copy is of the class Object [ ] [ ]. Any thoughts?</p>