title: Update a Google Sheet of another Google Drive
body: <p>My need is to update a remote sheet of another user, then I first need to retrieve the file, but then how can I use the file to retrieve the relevant sheet?</p>
  <p>Following my code:</p>
  <pre class="lang-js prettyprint-override"><code>var sss = SpreadsheetApp.getActiveSpreadsheet();
  var ss = sss.getSheetByName('ImportBooks');
  var range = ss.getRange('A2:M');
  var data = range.getValues();
  
  //Destination Range - Tab 1, Range 1
  var file = DriveApp.getFileById(&quot;1VnhUR4NpY8NOtDylo4tKrX-OsBIe4jBmv9KmhxworeI&quot;);  
  var tss = SpreadsheetApp.getActiveSpreadsheet();
  var ts = sheet.getSheetByName('yourBooks');  
  ts.getRange(lastRow(ts, 1), 1, data.length, data[0].length).setValues(data);
  }
  </code></pre>