Thanks for this step by step! Very helpful!
Just one additional note that worked for me. If you are trying to get the form to automatically refresh, just follow all the steps above (including creating the “Refresh” button function) and then do the following:
-> Open up your script editor with the script you are running for this spreadsheet
-> Click on Resources
-> Click Current project’s triggers
-> Remove any existing triggers and then click Add a new trigger
-> Select refershLastUpdate from the dropdown
-> Change the second dropdown to Time-driven
-> Change the last two dropdowns to however frequently you want the spreadsheet to refresh (e.g. “Minutes timer” and “Every 5 minutes”) (but be sure to be aware of Google doc’s quota limits)
-> Press Save on this box
-> Press Save for the overall script
Now the spreadsheet should automatically update with the latest form entries at the frequency you specified!
