Google Sans font in review Docs

[Brett Grear]

Has anyone noticed this before?

I have an add-on out for marketplace review and I received the usual Doc that has any comments that need to be addressed.  But I noticed that the font used on the doc is Google Sans.  As I understand it, this is the font used by Google for their branding and isn't accessible in Docs.

Is this just something Google is able to enable on their own domain or am I missing something?

Screenshot attached

Kind regards,

[Alan Wells]

I just opened a Google Doc and I can't find Google Sans as an available font.

[Brett Grear]

Yeh, it's not available usually.  It was a Doc shared with me from one of the Marketplace reviewers that used it as the font.  I was able to copy and paste the text from that Doc into a new Doc of my own and now I'm able to use it as a font and it appears in the fonts list, but only for that Doc.

I tried setting the paragraph style to use it as the default but it wouldn't allow that, it came up with an error message.

[Tanaike]

Can you provide the sample Google Document including the sample text using the font you want to use?

[Brett Grear]

https://docs.google.com/document/d/19651cH-yS-azw2pw7QqfMxsEnkIqPjfphQ5hpLuMvEs/edit?usp=sharing

[Kim Nilsson]

Google has done this a few times.

The company Netflix also has their own font.

It's very uncommon, and the only way to be able to use it is to copy from a document that has the font.

[Brett Grear]

Yeh, this is what I thought. I knew about the Google Sans font but didn't know it was compatible with Docs.  I guess, maybe, Google has an in-house add-on that allows it to be used or something?  It is interesting that it can be copied and pasted across to a new Doc that contains the font and Google Docs picks up the name but if you try to set it as a default style it fails. 

[Tanaike]

Thank you for adding more information. From your provided Google Document, I could know the font name. By this, I tested to change the font family to Google Sans for new created Google Document using Google Apps Script, I confirmed that the font can be changed to Google Sans. It seems that when the font name is directly set to the method of "setFontFamily", Google Sans can be used.

For this, I prepared the sample script to my blog by adding the demonstration video. Could you please confirm it? If that was not the direction you expect, I apologize.

[Brett Grear]

Yes, I can confirm this works.

I might create a quick internal add-on to make this easier to do.

[Shreyan EMR]

OMG this is the best thing I've ever seen! Thanks a lot!

[Samuel Alake]

Hi Tanaike, please is it possible to upload a custom font to Google Doc using this logic and font uploaded to Google drive (https://stackoverflow.com/questions/72590081/adding-customize-font-to-google-script-app)?

[Kim Nilsson]

No, Samuel.

It is not possible to upload custom fonts to Google Docs.

There are thousands to choose from, but you can't add your own.

You can petition Google to add fonts, but there are very few that have managed to do so.

The Australian government has had a few fonts added, as they are used to teach children how to read according to the Australian curriculum.

Kim

[Andrew Cao]

Did you end up writing the add-on? Would love to use it.

[Brett Grear]

I only ever published it for internal usage. Not sure If it would pass verification from Google's end.

--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/ehC7C95W5t0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/122ebf07-7fda-43d6-b84e-6b24791a0a3an%40googlegroups.com.

[Andrew Cao]

You could send me the source code, and I can build the add-on myself, if you're okay with that.

[Brett Grear]

Again, this was super basic and I was a lot less experienced with add-ons than I am now so it's not the most user friendly.  I seem to have made it to work with Docs, Sheets and Slides but I've only ever used it with Docs so I can't even remember if it worked with the others or not.

function onInstall(e) {

onOpen();

}

function onOpen(e) {

try {

var ui = DocumentApp.getUi();

var menu = ui.createAddonMenu();

menu.addItem('Google Sans','setFontDocs');

menu.addToUi();

} catch(e) {

try {

var ui = SlidesApp.getUi();

var menu = ui.createAddonMenu();

menu.addItem('Google Sans','setFontSlides');

menu.addToUi();

} catch(e) {

var ui = SpreadsheetApp.getUi();

var menu = ui.createAddonMenu();

menu.addItem('Google Sans','setFontSheets');

menu.addToUi();

}

}

}

function setFontDocs() {

try {

const selection = DocumentApp.getActiveDocument().getSelection();

const element = selection.getRangeElements()[0];

element

.getElement()

.asText()

.setFontFamily(

element.getStartOffset(),

element.getEndOffsetInclusive(),

"Google Sans"

);

} catch(e) {

console.log(e);

}

}

function setFontSlides() {

try {

const selection = SlidesApp.getActivePresentation().getSelection();

selection.getTextRange().getTextStyle().setFontFamily('Google Sans');

} catch(e) {

console.log(e);

}

}

function setFontSheets() {

try {

var cell = SpreadsheetApp.getActive().getSelection().getActiveRange().setFontFamily('Google Sans');

} catch(e) {

console.log(e);

}

}