This sample shows how to create a "file-open" dialog in Google Sheets thatallows the user to select a file from their Drive. It does so by loading Google Picker, for this purpose. More information is available in the Apps Script guide Dialogs and Sidebars in Google Workspace Documents.
Note that this sample expects to be bound to a spreadsheet.