Most of the time, when I write Google Scripts that address a Google Form, I almost always access the data through the spreadsheet of responses. But sometimes, getting back to the Form itself is necessary. In those cases, I use this code to access the final response. It’s not quite as simple as it seems.
The script below accesses the last response to a form, gets the email, timestamp, and answers and then adds them to a Google Sheet.
