I have successfully created a button to execute a function that will actually grab the file off on my computer. But will not to completely import the data of that file into a new sheet tab.

My current code is:


 * Displays an HTML-service dialog in Google Sheets that contains client-side
 * JavaScript code for the Google Picker API.
function showPicker() {
  var html = HtmlService.createHtmlOutputFromFile('dialog2.html')
  SpreadsheetApp.getUi().showModalDialog(html, 'Select a file');

 * Gets the user's OAuth 2.0 access token so that it can be passed to Picker.
 * This technique keeps Picker from needing to show its own authorization
 * dialog, but is only possible if the OAuth scope that Picker needs is
 * available in Apps Script. In this case, the function includes an unused call
 * to a DriveApp method to ensure that Apps Script requests access to all files
 * in the user's Drive.
 * @return {string} The user's OAuth 2.0 access token.
function getOAuthToken() {
  return ScriptApp.getOAuthToken();

function upload(obj) {
  var file = DriveApp.createFile(obj.upload);
  return {
    fileId: file.getId(),
    mimeType: file.getMimeType(),
    fileName: file.getName(),


<!DOCTYPE html>
    <base target="_top">
    <link rel="stylesheet" href="https://ssl.gstatic.com/docs/script/css/add-ons1.css">
  <form> <!-- Modified -->
    <div id="progress" ></div>
    <input type="file" name="upload" id="file">
    <input type="button" value="Submit" class="action" onclick="form_data(this.parentNode)" >
    <input type="button" value="Close" onclick="google.script.host.close()" />
    function form_data(obj){ // Modified
    function closeIt(e){ // Modified
  • But will not to completely import the data of that file into a new sheet tab. Would you please clarify what you mean by this. Your script doesn't include any reference to a developer key - did you follow the docs on this? – Tedinoz May 16 at 10:50
  • No need for the key because it will authorize using the getOAuthToken() I believe. – samjco May 16 at 11:33
  • You might be right; I've always got a key. – Tedinoz May 16 at 11:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.