neno-tech/code.gs

## code.gs
function doGet() {
  return HtmlService.createTemplateFromFile("index")
  .evaluate()
  .addMetaTag('viewport', 'width=device-width, initial-scale=1')
  .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL)
}
function addRecord(obj){
  const ws = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()
  const data = ws.getRange(1,1,ws.getLastRow(),1).getValues()
  var maxNum = 0
  data.forEach( r => {
    maxNum = r[0] > maxNum ? r[0] : maxNum
  })
  var newId = maxNum + 1
  ws.appendRow( [newId, obj.username, obj.nickname, "'"+obj.phone ])
}

## index.html
<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body>
  ฟอร์มบันทึกข้อมูล  <p>
  <label>ชื่อ สกุล</label><input type="text" id="username"> <p>
  <label>ชื่อเล่น</label><input type="text" id="nickname"><p>
  <label>เบอร์โทร</label><input type="text" id="password"><p>
  <button id="btn">บันทึกข้อมูล</button>

  <script>
  document.getElementById("btn").addEventListener("click",submit)

  function submit(){
  var obj={}
   obj.username = document.getElementById("username").value
   obj.nickname = document.getElementById("nickname").value
   obj.phone = document.getElementById("password").value
  google.script.run.addRecord(obj)
  document.getElementById("username").value=""
  document.getElementById("nickname").value=""
  document.getElementById("password").value=""

  }
  </script>
  </body>
</html>
	function doGet() {
	return HtmlService.createTemplateFromFile("index")
	.evaluate()
	.addMetaTag('viewport', 'width=device-width, initial-scale=1')
	.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL)
	}
	function addRecord(obj){
	const ws = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()
	const data = ws.getRange(1,1,ws.getLastRow(),1).getValues()
	var maxNum = 0
	data.forEach( r => {
	maxNum = r[0] > maxNum ? r[0] : maxNum
	})
	var newId = maxNum + 1
	ws.appendRow( [newId, obj.username, obj.nickname, "'"+obj.phone ])
	}
	<!DOCTYPE html>
	<html>
	<head>
	<base target="_top">
	</head>
	<body>
	ฟอร์มบันทึกข้อมูล <p>
	<label>ชื่อ สกุล</label><input type="text" id="username"> <p>
	<label>ชื่อเล่น</label><input type="text" id="nickname"><p>
	<label>เบอร์โทร</label><input type="text" id="password"><p>
	<button id="btn">บันทึกข้อมูล</button>

	<script>
	document.getElementById("btn").addEventListener("click",submit)

	function submit(){
	var obj={}
	obj.username = document.getElementById("username").value
	obj.nickname = document.getElementById("nickname").value
	obj.phone = document.getElementById("password").value
	google.script.run.addRecord(obj)
	document.getElementById("username").value=""
	document.getElementById("nickname").value=""
	document.getElementById("password").value=""

	}
	</script>
	</body>
	</html>