This is a demo of a Google Apps Script that used the Google Picker API.
Click the 'File Picker' button to open the file picker dialogue box.
After a file has been chosen, the script gets the following file information:
-- path
-- name
-- file ID
And writes this information in the row where the cursor is at, i.e. to the active row.