const sheetUrl = "https://docs.google.com/spreadsheets/d/19RTV39Z6wJQdoa8txs_eSCQf_iA0LoRg9valE594hSQ/"; //スプレッドシートURL const sheetName = "検証データ" //シート名 //ピンポイントでセルを指定して値を取得する(API呼び出し = 4回) function getValue() { let start = Date.parse(new Date()) / 1000; let ss = SpreadsheetApp.openByUrl(sheetUrl); let sheet = ss.getSheetByName(sheetName); let value = sheet.getRange(51, 4).getValue(); let end = Dat
![【徹底検証】GASでセルから最も効率的に値を取得する方法とは? | 初心者でもわかるGoogle Apps Script活用のススメ](https://cdn-ak-scissors.b.st-hatena.com/image/square/c8b3f20f4ab1f7824bba97b379bd71364205176f/height=288;version=1;width=512/https%3A%2F%2Fi0.wp.com%2Ffor-dummies.net%2Fgas-noobs%2Fwp-content%2Fuploads%2F2021%2F03%2Faccelarate_gas_functions.png%3Ffit%3D320%252C180%26ssl%3D1)