Johannes King joleroi
triblondon
/ apps-script.js
Last active
August 31, 2022 11:43
Google apps script for form data to gsheet
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Submit form data directly to Google sheets | |
| // | |
| // (Based on http://railsrescue.com/blog/2015-05-28-step-by-step-setup-to-send-form-data-to-google-sheets/) | |
| // | |
| // ## Setup | |
| // | |
| // 1. Create a Google spreadsheet and name it | |
| // 2. Choose Tools > Script editor | |
| // 3. Replace the sample code with the contents of this file | |
| // 4. Name the script project something like "Submit form data to Google sheet" (click on 'Untitled project' to change name) |