A simple example of sending data from an ordinary web form straight to a Google Spreadsheet without a server.
I created this code for a client, but it is not up-to-date. I recommend checking out the walkthrough repo below instead: https://github.com/dwyl/learn-to-send-email-via-google-script-html-no-server
A friend called and asked for a favor:
"Can you set up a web form that posts data to a Google Spreadsheet
without a (server) backend...? (We need it done by tomorrow)"
Never one to turn down a chance to help a friend and learn something new, I agreed to the task!
The plan is to simulate the POST request an actual Google Form sends when it submits a survey response to its google ("results") spreadsheet. Sounds simple. it is. kinda ...
This repo is just a quick example I made. If you want a full step-by-step tutorial, see: https://github.com/dwyl/learn-to-send-email-via-google-script-html-no-server
An additional requirement was to send an email (IKR!)
when ever the HTML Form is submitted.
Thankfully, Google has a good Method for doing this:
MaillApp
Hypothesis: for high value items some people will prefer to speak to a person on the phone instead of emails. Therefore having a form input for Phone Number will "convert"" better than email.
I've added two new files: _lon-phone.html and _par-phone.html
to test this Hypothesis.
If you want more, please ask!
- AJAX post to google spreadsheet: https://stackoverflow.com/questions/10000020/ajax-post-to-google-spreadsheet which points to:
- MailApp Service: https://developers.google.com/apps-script/reference/mail/mail-app
- I Posted this OverFlow Question because I could not get
MailApp.sendEmailto work: https://stackoverflow.com/questions/33180172/why-does-mailapp-sendemail-from-google-spreadsheet-script-not-work