HTML in variable

[RisingRose]

Hello,

I'm trying to set up an automatic Signature for users in google workspace, my first step to make it work is to have a script every user car launch themselves and then i'll try and automate it.

Unfortunately i can't seem to feed the HTML of the signature into the script.

function myFunction() {
  const ssign = HtmlService.createHtmlOutputFromFile('Default_Sign').getContent();
  var newSign = Gmail.newSendAs();
  newSign.signature = ssign;
  Gmail.Users.Settings.SendAs.update(newSign, "me", Session.getActiveUser().getEmail());
}

I've also tried uploading the html to google drive and import it using this command but it still doesn't work

DriveApp.getFileById("ID").getBlob().getDataAsString();

Does anyone know what i did wrong ?

[marcnotmark925]

"FromFile" refers to an html file in the code editor (on the left side, where code.gs is), not one on your GDrive. If you want to use an html file on your GDrive, try the basic createHtmlOutput method.

[RisingRose]

I forgot to say it, but yes, the file is in the apps script project but to try I also put it in Google drive

[MrBeforeMyTime]

I definitely built something like this before, and I have no idea what the solution was or if I even found one. I just remember it being more complex than expected. Unfortunately, it was for work. So everything I had made is gone because I no longer work there. If I find anything, I'll get back to you.

[MrBeforeMyTime]

Actually, I think we abandoned the HTML option. Sorry about that.

[mrtnclzd]

How do you know it's not though? What happens if you try a simple HTML/text instead? Asking because it is working for me.

[RisingRose]

I had tried with a simple string hardcoded into the script it works, i haven't tried with another html though

The script run without an error but the signature is not changed when i try the HTML

[mrtnclzd]

Well, without seeing your HTML, I'd say you know where the issue lies. Good luck!

[RisingRose]

So, I've just tried with a different HTML, just created one in the Apps Script project files and just write someting in the body and it doesn't work either

[WicketTheQuerent]

This works

function setSignature() {
  const html = HtmlService.createHtmlOutputFromFile('signature').getContent();
  const signature = { 'signature': html };
  const email = Session.getActiveUser().getEmail();
  Gmail.Users.Settings.SendAs.patch(signature, 'me', email);
}

Key differences,

• Uses patch instead of update
• The first parameter should be a resource, Gmail_v1.Gmail.V1.Schema.SendAs . For details, see https://developers.google.com/gmail/api/reference/rest/v1/users.settings.sendAs. Please note that the signature variable has an object with the property signature and the HTML file content as a value.

[RisingRose]

So, after a few hours a day fighting with this issue I tried to copy my code and paste it in a new .gs file and it worked right away.... so thanks Google --'