Stack Overflow
Stack Overflow

Questions tagged [google-apps-script-addon]

Use for questions regarding editor-addons. Use in addition to any of the editors tags like [google-spreadsheet], [google-docs], slides or form. Do NOT use for gmail-addons(use [gmail-addon] instead).

Editor Addons are written in Google-apps-script and may be published to the Chrome webstore. They are used to enhance the functionality of Google drive editor applications: Google sheets, docs, slides and forms.

269 questions
5
votes
2 answers

How to tell if a slide is "skipped" in Google Slides with Google Apps Script or API?

In Google Slides, it's possible to set a slide to be "skipped" in presentation mode (as described here). However, the automated page numbering still includes skipped slides (meaning that in presentation mode, if slide 4 is skipped, the slide…
soulshake
  • 780
  • 8
  • 12
5
votes
1 answer

Publish new version of Google Sheets Add-on

I have published a Google Sheets Add-on for internal use. It works. But I can't seem to publish a new version. I'm following this: https://developers.google.com/gsuite/add-ons/how-tos/manage-addons Given Google's announcement that they're retiring…
Paul B
  • 198
  • 6
5
votes
1 answer

Add container-bound script to a Google Docs file programmatically

I am uploading files to Google Drive using the Drive REST API. I would like to have some default add-ons enabled on those files by default. I was reading about container-bound scripts here. But it is only possible to add container-bound script after…
Asym
  • 1,836
  • 3
  • 21
  • 36
5
votes
3 answers

add-on with LIMITED auth cannot open sidebar

I have a Google docs add-on which is programmed to open the sidebar as soon as the document is open. Of course this requires the add-on to be installed and enabled in the document. I see that, since a week, the sidebar auto open feature, which is…
Yves
  • 159
  • 7
5
votes
1 answer

Add a section widgets dynamically into Card on newSelectionInput OnChangeAction

I'm trying to add a section widgets dynamically to Card/CardService on newSelectionInput OnChangeAction, the card already added. I did not see any documentation on Google, how to achieve this behavior. Can someone please direct me to the right…
jkyadav
  • 1,214
  • 5
  • 18
  • 32
5
votes
2 answers

Menu items do not appear in Google Sheets add-on

I am trying to make this add-on plugin that can help me and other to export sheet in to JSON. In my testing it's the menu shows up and all the functionality works (as you see in screenshots). When I sent for publish on Google Web Store the "Docs…
Sunil
  • 51
  • 2
4
votes
2 answers

Google Add-on script throws server error when calling DriveApp getFolderById or getFileById

I have deployed a spreadsheet bound script as an add-on. It worked when it was container bound. But now, as an add-on, I get a server error when I call DriveApp.getFolderById function makeMap (){ console.log("start lesmap"); try{var…
Bert A
  • 59
  • 5
4
votes
1 answer

How to reproduce "You do not have access to perform that action" on onOpen that only creates a menu

Tl;Dr My partner and I published a Google Sheets add-on that is "randomonly" throwing "You do not have access to perform that action" when opening a spreadsheet. The onOpen function doesn't require authorization to be executed. Is there a way to…
Rubén
  • 34,714
  • 9
  • 70
  • 166
4
votes
2 answers

How to use versioned deployments when programmatically creating triggers?

When creating a trigger programmatically, i.e. through ScriptApp.newTrigger(), does it always point to the "head" deployment, or the most recent published (versioned) deployment? (See documentation on deployment types here.) For context, I'm…
Ryan
  • 95
  • 9
4
votes
0 answers

Google Admin Directory API: Error Not Authorized

I have a script that I would like a regular user of our domain to be able to run. I pushed it out as an add-on for docs but when my users run the script they get this error: GoogleJsonResponseException: Not Authorized to access this…
Salty Teapot
  • 61
  • 3
4
votes
0 answers

How to share Google API authorizations for a Google Apps Script add-on with other Google Cloud project?

Components of the system Published Google Apps Script add-on ("add-on") and also published on the G Suite marketplace for domain-wide installation still in its original GCP project P1 has the OAuth2 client ID that was generated automatically when…
Ani
  • 1,377
  • 1
  • 18
  • 29
4
votes
1 answer

onInstall() not running when I test my project as add-on on google spreadsheet

Should onInstall trigger work when I test my project as an add-on? I made a very simple onInstall function. It just adds content to a row on the spreadsheet. It should be called when the add-on is installed, but I am now trying to verify this…
Mauricio Moraes
  • 7,255
  • 5
  • 39
  • 59
4
votes
0 answers

Google Add-on adding menu items in limited mode app scripts

We have a addon published in the new google app scripts add on store, but permissions don't seem to work correctly when using the add on in any spreadsheet other than the initial one it is installed in. I'm seeing an issue where when a new…
Ted Tomlinson
  • 773
  • 2
  • 7
  • 18
3
votes
1 answer

How to remove empty lines in a google doc using the script editor (Google Docs add-ons)?

I am creating a Google Docs add-on, and one of the features I am trying to create is a feature that reduces the number of empty lines between two paragraphs. So, for instance, if I have 2 paragraphs with 5 empty/blank lines between them, I want the…
lakshhk4
  • 53
  • 1
  • 6
3
votes
1 answer

Google appscript does not recognize Chromium based Edge

I am trying to detect Chromium based Edge browser in google slides addon. Code.gs function onInstall(event) { onOpen(event); } function onOpen(event) { SlidesApp.getUi().createAddonMenu() .addItem('Open the sidebar',…
tprieboj
  • 1,680
  • 6
  • 31
  • 54
1
2
3
…
17 18