Using gmail : Send email from Html + Spreadsheet as database

We needed a way of sending an email from a "static" HTML page when you don't (want to) have a server.

Advantages:
-No "Backend" to Deploy/Maintain/Pay for
-Fully Customisable - every aspect is customisable!
-Email sent via Google Mail which is Whitelisted Everywhere (high deliverability success)
-Collect/Store any form data in a Spreadsheet for easy viewing
(perfect if you need to share it with non-technical people)

Steps:
STEP-1: Make a Copy of the Sample Spreadsheet
Sample: https://docs.google.com/spreadsheets/d/1Bn4m6iA_Xch1zzhNvo_6CoQWqOAgwwkOWJKC-phHx2Q/copy

You will get a Spreadsheet like this:

STEP-2: Open the Script Editor
Open the Script editor... by clicking "Tools" > "Script editor..."

STEP-3: Set the TO_ADDRESS in the Script

STEP-4: Save a New Version of your Script

STEP-5: Publish the Updated Script as a Web App

STEP-6: Authorize the Script to Send Emails

STEP-7: Create your basic HTML Form

STEP-8: Open the HTML Form (page) in your Browser

Part Two - Make It Look Good ...

Okay we can add more like Submit the Form using JavaScript "AJAX", Adding a customised 'Thank You Message' Shown when Form Submitted or more css...

Please visit for more

dwyl / learn-to-send-email-via-google-script-html-no-server

✉️ An Example of using an HTML form (e.g: "Contact Us" on a website) to send Email without a Backend Server (using a Google Script) perfect for static websites that need to collect data.

I hope you people like the above article and learned something.

IMP REQUEST:

You are most welcome to join my team form for joining .

Also you are most welcome to join OPEN SOURCE INTELLIGENT SYSTEM (OSINT) if you can help in open source project regarding safeguarding humans from various diseases like CORONA outbreak

https://github.com/Manishfoodtechs/OSINTHRH/wiki

Contact email: [e-mail].

If you have any problem, our team is also engaged in professional consultancy and delivery.

Comments

[Shubham Naik]

Pretty cool - definitely could use this for a quick form.

[manish srivastava]

Sure shubham. It is more than just email. It can be used as database for many apps like small apps for schools , doctors and survey much more.