Why can't i log the output into logger of google sheets?

Question

I was trying to get add some custom scripts into google Sheets. But got so many problems even after following the ditto steps as given in the guides of GoogleCodeLabs.

that's my code main.gs file

 function doGet() {
  return HtmlService.createHtmlOutputFromFile('Index');
}

function doSomething() {
  Logger.log('I was called!');
}

index.html file

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
    <script>
      google.script.run.doSomething();
    </script>
  </head>
  <body>
  </body>
</html>

appsscript.json file

{
  "timeZone": "Asia/Kolkata",
  "dependencies": {
  },
  "webapp": {
    "access": "MYSELF",
    "executeAs": "USER_DEPLOYING"
  },
  "exceptionLogging": "STACKDRIVER",
  "oauthScopes": ["https://www.googleapis.com/auth/spreadsheets.readonly",
                  "https://www.googleapis.com/auth/userinfo.email",
                  "https://www.googleapis.com/auth/spreadsheets",
                  "https://www.googleapis.com/auth/script.container.ui"],
  "runtimeVersion": "V8"
}

also i am deploying it with every small changes but even after doing the same as mentioned in the guides i couldn't log the output. what am i missing?

The logger does take a long time to display results in V8 and so I find it quick to use view/executions — Cooper
– Cooper, Commented Jun 27, 2020 at 22:36
Related Very slow “Logs” with Google Apps Script V8 vs Rhino? — Wicket
– Wicket, Commented Jun 27, 2020 at 22:46
More related: stackoverflow.com/q/61727630/1595451, stackoverflow.com/q/60918110/1595451 (no answers yer), stackoverflow.com/q/62010980/1595451 — Wicket
– Wicket, Commented Jun 27, 2020 at 22:53
Logs are viewable in script executions. Go to the script dashboard and look at the script execution logs there. — IMTheNachoMan
– IMTheNachoMan, Commented Jun 27, 2020 at 23:01

Cooper · Accepted Answer · 2020-06-27 22:24:16Z

3

Try this:

function myfun() {
  const ss=SpreadsheetApp.getActive();
  const sh=ss.getActiveSheet();
  const html='<!DOCTYPE html><html><head><base target="_top"><script>google.script.run.withSuccessHandler(function(){document.getElementById("msg").innerHTML="I did something Useful";}).doSomething();</script></head><body><div id="msg"></div></body></html>';
  SpreadsheetApp.getUi().showModelessDialog(HtmlService.createHtmlOutput(html), "Dialog");
}

function doSomething() {
  console.log('something');
  return;
}

edited Jun 27, 2020 at 22:24

answered Jun 27, 2020 at 21:37

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dharman · Accepted Answer · 2021-06-17 16:42:08Z

1

I ran into this same thing recently on the NEW google apps script editor.

the Logger.log will not show anything on the "Execution Log" in the editor unless you execute the function from the editor itself.

but,

if the function that has the Logger.log is executed with google.script.run (client side), You WILL see whatever was logged with Logger.log in "Executions"

edited Jun 17, 2021 at 16:42

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Jun 17, 2021 at 16:36

Francisco Cortes

1,26813 silver badges30 bronze badges

Collectives™ on Stack Overflow

Why can't i log the output into logger of google sheets?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related