Just as the post title suggest, this post is about how to do it. Here are the steps. 1. Create a New Google Sheets Spreadsheet. Give a meaningful and consistent header such as the image below: 2. Share it as public (anyone with the link) and set the anyone as Editor. 3. From the GSheets Menu, go to Extension > App Scripts. 4. Delete the initial function, and copy/paste code snippets below. // Original code from https://github.com/jamiewilson/form-to-google-sheets // Updated for 2021 and ES6 standards const sheetName = 'Geolocation' const scriptProp = PropertiesService . getScriptProperties () function initialSetup () { const activeSpreadsheet = SpreadsheetApp . getActiveSpreadsheet () scriptProp . setProperty ( 'key' , activeSpreadsheet . getId ()) } function doPost ( e ) { const lock = LockService . getScriptLock () lock . tryLock ( 10000 ) try { const doc = SpreadsheetApp . openById ( scriptProp . getProperty (
