/**

* Copyright Google LLC

*

* Licensed under the Apache License, Version 2.0 (the 'License');

* you may not use this file except in compliance with the License.

* You may obtain a copy of the License at

*

* https://www.apache.org/licenses/LICENSE-2.0

*

* Unless required by applicable law or agreed to in writing, software

* distributed under the License is distributed on an 'AS IS' BASIS,

* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

* See the License for the specific language governing permissions and

* limitations under the License.

*/

// [START picker_code]

/**

* Creates a custom menu in Google Sheets when the spreadsheet opens.

*/

function onOpen() {

SpreadsheetApp.getUi()

.createMenu("Picker")

.addItem("Start", "showPicker")

.addToUi();

}

/**

* Displays an HTML-service dialog in Google Sheets that contains client-side

* JavaScript code for the Google Picker API.

*/

function showPicker() {

const html = HtmlService.createHtmlOutputFromFile("dialog.html")

.setWidth(800)

.setHeight(600)

.setSandboxMode(HtmlService.SandboxMode.IFRAME);

SpreadsheetApp.getUi().showModalDialog(html, "Select a file");

}

// Ensure the Drive API is enabled.

if (!Drive) {

throw new Error("Please enable the Drive advanced service.");

}

/**

* Checks that the file can be accessed.

* @param {string} fileId The ID of the file.

* @return {Object} The file resource.

*/

function getFile(fileId) {

return Drive.Files.get(fileId, { fields: "*" });

}

/**

* Gets the user's OAuth 2.0 access token so that it can be passed to Picker.

* This technique keeps Picker from needing to show its own authorization

* dialog, but is only possible if the OAuth scope that Picker needs is

* available in Apps Script. In this case, the function includes an unused call

* to a DriveApp method to ensure that Apps Script requests access to all files

* in the user's Drive.

*

* @return {string} The user's OAuth 2.0 access token.

*/

function getOAuthToken() {

return ScriptApp.getOAuthToken();

}

// [END picker_code]