trigger.html

<html>
<head>
<title>トリガーチェック</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script type="text/javascript" src="https://www.google.com/jsapi"></script>

<!--テーブル-->
<script type="text/javascript">
google.load("visualization", '1', {packages:['table']});
google.setOnLoadCallback(drawTable);
function drawTable() {
 var mykey = '1Yynlwa-JmTU9Pz0RHduFlLnueb3KKjwAs0JYOau2mao';//スプレッドシートのユニークキー
 var mygid = '1513720956';//シートのユニークキー
 var query = new google.visualization.Query(
      'https://docs.google.com/spreadsheet/ccc?key=' + mykey + '&usp=drive_web&gid=' + mygid + '#' );
  query.send(handleQueryResponse_t2);
}

function handleQueryResponse_t2(response_t2) {
  if (response_t2.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
    return;
  }

  var data_t2 = response_t2.getDataTable();
  var table = new google.visualization.Table(document.getElementById('myTriggerTable'));
  var options = {
    width: 800,
    height: 600,
    showRowNumber:true
  }
  table.draw(data_t2,options);
}
</script>
</head>

<body>
<div>
  <a href="../">戻る</a>

  <hr>

  <h2>トリガー実行状況確認表</h2>
  <div id='myTriggerTable'></div>

</div>

</body>
</html>