Google Forms Response Importer
This code is similar to the one you saw in our Youtube tutorial on creating a response importer - https://youtu.be/bf8oEvLDa7o. There are some minor changes to it so that you can use it as plug n' play code in your Apps Script project.
In this sample code, you'll find 3 Functions:
- getSettings()
- importFormResponses()
- determineType()
The only thing you'll have to change to had it work for you is what's found in the getSettings() function, within the return statement. You'll need your Google Form ID and Google Sheets/Spreadsheet ID - Both of which you can find in the URL. You'll also need the Sheet Name, assuming you didn't name it "importList" like I did in the tutorial.
**Make sure to run the "importFormResponses()" function when you try to execute the script. To do so, select "importFormResponses()" from the dropdown of functions found next to the "run" and "debug" buttons.