HTML Form to Google Sheets

In this tutorial you will learn how to store data into Google sheet from an HTML form

Step 1. Create a Google Sheet

 You can add your own gs fields (Changes should be reflected in HTML form also

Step 2. Create Google Apps Script And Publish it (Code.gs)

 Open Script editer

 Delete the text and paste Code.gs




Follow the instruction as show in the images

Authorize the script by sign in to your Google account

Step 3. Publish the project

Publish the app and copy the url

Step 4. Input your web app URL

Open the file `message.js` and paste the url  `scriptURLC` on first line