/** * Return a list of sheet names in the Spreadsheet with the given ID. * @param {String} a Spreadsheet ID. * @return {Array} A list of sheet names. */ function getSheetNames(sheetId) { var ss = SpreadsheetApp.openById(sheetId); var sheets = ss.getSheets(); return sheets.map(function(sheet) { return sheet.getName(); }); } 外から叩ける様に設定する 通常のスクリプトを勝手に外から叩かれるといろいろセキュリティ的に困るので、明示的に外部からの起動を許可する必要があります。
![GASのExecution APIを使ってGASを外部からぶっ叩く - Qiita](https://cdn-ak-scissors.b.st-hatena.com/image/square/8c38baea78a68592e833ca61c48b39ed3bba330c/height=288;version=1;width=512/https%3A%2F%2Fqiita-user-contents.imgix.net%2Fhttps%253A%252F%252Fqiita-user-contents.imgix.net%252Fhttps%25253A%25252F%25252Fcdn.qiita.com%25252Fassets%25252Fpublic%25252Farticle-ogp-background-afbab5eb44e0b055cce1258705637a91.png%253Fixlib%253Drb-4.0.0%2526w%253D1200%2526blend64%253DaHR0cHM6Ly9xaWl0YS11c2VyLXByb2ZpbGUtaW1hZ2VzLmltZ2l4Lm5ldC9odHRwcyUzQSUyRiUyRnFpaXRhLWltYWdlLXN0b3JlLnMzLmFtYXpvbmF3cy5jb20lMkYwJTJGMjk2NSUyRnByb2ZpbGUtaW1hZ2VzJTJGMTQ3MzY4MjQxNT9peGxpYj1yYi00LjAuMCZhcj0xJTNBMSZmaXQ9Y3JvcCZtYXNrPWVsbGlwc2UmZm09cG5nMzImcz01ZDQwODE2YTcxYjZiZjNiMzIyYTg3OTA5OWQxYTIyNQ%2526blend-x%253D120%2526blend-y%253D467%2526blend-w%253D82%2526blend-h%253D82%2526blend-mode%253Dnormal%2526s%253Df246ca533cbb769c433e791368d01d48%3Fixlib%3Drb-4.0.0%26w%3D1200%26fm%3Djpg%26mark64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTk2MCZoPTMyNCZ0eHQ9R0FTJUUzJTgxJUFFRXhlY3V0aW9uJTIwQVBJJUUzJTgyJTkyJUU0JUJEJUJGJUUzJTgxJUEzJUUzJTgxJUE2R0FTJUUzJTgyJTkyJUU1JUE0JTk2JUU5JTgzJUE4JUUzJTgxJThCJUUzJTgyJTg5JUUzJTgxJUI2JUUzJTgxJUEzJUU1JThGJUE5JUUzJTgxJThGJnR4dC1hbGlnbj1sZWZ0JTJDdG9wJnR4dC1jb2xvcj0lMjMxRTIxMjEmdHh0LWZvbnQ9SGlyYWdpbm8lMjBTYW5zJTIwVzYmdHh0LXNpemU9NTYmdHh0LXBhZD0wJnM9NmYzNmExZjg5NDBlN2UzOTBlOTdkMmE1NjA4MGVlODM%26mark-x%3D120%26mark-y%3D112%26blend64%3DaHR0cHM6Ly9xaWl0YS11c2VyLWNvbnRlbnRzLmltZ2l4Lm5ldC9-dGV4dD9peGxpYj1yYi00LjAuMCZ3PTgzOCZoPTU4JnR4dD0lNDBzb3VuZFRyaWNrZXImdHh0LWNvbG9yPSUyMzFFMjEyMSZ0eHQtZm9udD1IaXJhZ2lubyUyMFNhbnMlMjBXNiZ0eHQtc2l6ZT0zNiZ0eHQtcGFkPTAmcz05NDIyZGM2OWIxNzk3YWMyYWQ2MzlkMjEzZTZmMjUwZA%26blend-x%3D242%26blend-y%3D480%26blend-w%3D838%26blend-h%3D46%26blend-fit%3Dcrop%26blend-crop%3Dleft%252Cbottom%26blend-mode%3Dnormal%26s%3D073f68454496955ec9cb755655abc2a3)