Skip to content

Instantly share code, notes, and snippets.

@WakkyFree
Created July 21, 2021 15:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save WakkyFree/a7eaa87025b5ebf27b34bb3dd3049050 to your computer and use it in GitHub Desktop.
Save WakkyFree/a7eaa87025b5ebf27b34bb3dd3049050 to your computer and use it in GitHub Desktop.
google apps script to read spreadsheet
function readSheet(){
var data = openSheet().getDataRange().getValues();
return data;
}
function doGet() {
const htmlOutput = HtmlService.createTemplateFromFile('ss_open_test').evaluate();
htmlOutput.setTitle("スプレッドシート読み込みテスト");
return htmlOutput;
}
function openSheet() {
var id = "1lDnkZwZxwB0DCN5FtKQJvE44y-LIu9_vsviz9Yn-j7s";
var ss = SpreadsheetApp.openById(id).getSheetByName("messages");
return ss;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment