Getting started with google-apps-script Spreadsheet Service DriveApp Service - Files by type and search string Spreadsheet Add Menu Apps Script Web Apps Google sheets MailApp DriveApp Create a custom function for Google Sheets SpreadsheetApp Active Sheet GmailApp DriveApp - getFileById(id)DriveApp Service Google Web App Script To Auto Download From Google Drive Client calls to Google apps-script Firebase and AppScript : Introduction

DriveApp - getFileById(id)

Remarks:

It is also possible to get a file by the file's URL. The ID of a file is in the url, so using the ID instead of the entire URL means that the parameter is shorter. Storing the URL rather than the ID takes up more space.

Get a file from Google Drive using the file ID

function getGoogleDriveFileById(id) {
  var file;
  
  file = DriveApp.getFileById(id);//Returns a file - The "id" must be a string
  
  //One way to manually get a file ID
  // - Open the file from Google Drive
  // - The file ID is in the URL in the browsers address bar
  //https://docs.google.com/spreadsheets/d/File_ID_is_here/edit#gid=0
};

Contributors

Topic Id: 6087

Example Ids: 21223

This site is not affiliated with any of the contributors.