Google Spread Sheet最後の行に追加

aa, bb, ccを最後の行に追加<br />

<hr />

aa:<input id="aa" type="text" value="" style="width: 100px;"><br />

bb:<input id="bb" type="text" value="" style="width: 100px;"><br />

cc:<input id="cc" type="text" value="" style="width: 100px;"><br />

<hr />

<input class="btn" type="button" value="追加" onClick="add();">

<input id="pwd" type="text" value="" style="width: 100px;">(VkrXQ)

<br />

<div id="kekka" class="scrollable"></div>

<script src="https://code.jquery.com/jquery-3.2.1.min.js"></script>

<script>

function add() {

    addData($("#aa").val(), $("#bb").val(), $("#cc").val());

}

async function addData(aa, bb, cc) {

    try {

        const sid = "デプロイIDの後ろをいくつか削除" + $("#pwd").val();

        const url = "https://script.google.com/macros/s/"+sid+"/exec?aa="+aa+"&bb="+bb+"&cc="+cc;

        $("#kekka").html("読み込み中");

        const response = await fetch(url);

        const data = await response.text();

        $("#kekka").html(data);

    } catch (error) {

        $("#kekka").html("ERROR");

    }

}

</script>