Implementing Google sheet API in html

Question

I am planning to use Google sheet API v4 in my website . I have custom form, I want the data of form to dumbed in Google sheet I don't have any servers like Python, Apache, etc., in my host server

Answer 1

You may follow this SO thread on how to get the data in forms using Forms Service. Also check on this Spreadsheet Service on how to modify the spreadsheet using apps script. Then you can publish the script as a web app if the function returns an HTML service HtmlOutput object or a ontent service TextOutput object.

Here are the following tutorials which might help:

• Saving Form Data to Google Spreadsheets Using PHP and the Google Docs API
• Google Sheets as a Database – INSERT with Apps Script using POST/GET methods (with ajax example)