How do you grab a photo from your device's storage?

TIMAI2 · April 4, 2025, 10:52pm

Well, it didn't actually take all that long:

Drive Folder with Images

Google Apps Script Web App

function doGet(e) {
  var ss = SpreadsheetApp.getActive();
  var sheet = ss.getActiveSheet();
  sheet.clear();
  sheet.appendRow( ['Filename', 'FileType', 'FileID', 'ViewUrl'] );
  
  var folderId = '1EjhZxyuFy_edited_wkS--QdpauABaMpU';
  var folder = DriveApp.getFolderById(folderId);
  var contents = folder.getFiles();
  var file, name, id, url, type;
 
  while(contents.hasNext()) {
    file = contents.next();
    name = file.getName();
    id = file.getId();
    url = "https://lh3.googleusercontent.com/d/" +file.getId();
    type = niceFileType(file.getMimeType());
    sheet.appendRow( [name,type,id,url] );     
  }  
  SpreadsheetApp.flush();
  rng = sheet.getDataRange().getValues();
  return ContentService.createTextOutput(JSON.stringify(rng));
}

function niceFileType( mimeType ) {
  
  if (typeof this.fileType === 'undefined') {
    this.fileType = {};
    this.fileType[MimeType.FOLDER] = "Folder";
    this.fileType[MimeType.GOOGLE_APPS_SCRIPT] = "Google Apps Script";
    this.fileType[MimeType.GOOGLE_DOCS] = "Google Doc";
    this.fileType[MimeType.GOOGLE_DRAWINGS] = "Google Drawing";
    this.fileType[MimeType.GOOGLE_FORMS] = "Google Form";
    this.fileType[MimeType.GOOGLE_SHEETS] = "Google Sheet";
    this.fileType[MimeType.GOOGLE_SLIDES] = "Google Slides";
    this.fileType[MimeType.JPEG] = "JPG";
    this.fileType[MimeType.PNG] = "PNG";
    this.fileType[MimeType.BMP] = "BMP";
    this.fileType[MimeType.GIF] = "GIF";
    this.fileType[MimeType.SVG] = "SVG";
    this.fileType[MimeType.PDF] = "PDF";
    this.fileType[MimeType.CSV] = "CSV";
  }
  return (this.fileType.hasOwnProperty(mimeType)) ? this.fileType[mimeType] : "UNKNOWN";
}

Blocks (updated to call thumbnails)

Spreadsheet with Data

App Screenshot

note: the image folder is set to anyone with the link (as are the files inside). The spreadsheet can either be restricted or anyone with the link.

You might also be interrested in this approach...