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
39
votes
5 answers

You do not have permission to call openById

Problem: When I run the script, Google tells me, You do not have permission to call openById I had copied a script from another one of my Google spreadsheets and changed the target_ssKey variable's cell reference and created properly-sized Named…
user3014111
  • 529
  • 1
  • 4
  • 7
24
votes
1 answer

How can I share my app script, between google spreadsheets?

I have a corporate google account (with a domain) and I've created a script to access a database, to share data between some spreadsheets to make simulations. I created some custom functions like =listAllCustomers() and now I want to use with any…
Rodrigo Pereira Fraga
  • 499
  • 1
  • 3
  • 11
21
votes
4 answers

We're sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED

I wrote a google scripts editor addon, and published it to the google marketplace with private visibility (it is only visible to the users in my organization). I tested the addon with all types of permissions (installed for current user, enabled in…
Carlos
  • 405
  • 5
  • 12
18
votes
3 answers

There is no API Console project with the id specified in the manifest's api_console_project_id field

I am trying to publish a spreadsheet web add-on but getting following error. There is no API Console project with the id specified in the manifest's api_console_project_id field Can anyone tell me why I am getting this error ?
Hari Das
  • 10,145
  • 7
  • 62
  • 59
16
votes
5 answers

Detect user inserting row or column in a google spreadsheet and reacting in a script

In Google Apps Script, one of the basic tools is the onEdit trigger in a spreadsheet, which enables us to detect when a user edits a cell, and react to it. How about when a user inserts a row or column ? Is there a way to detect that ? Would that…
Vic Seedoubleyew
  • 9,888
  • 6
  • 55
  • 76
14
votes
3 answers

G Suite Marketplace SDK [Publish] button always greyed out?

My app is finally published in the G Suite Marketplace. However, I need to update the banner image as it's blurry and the [Publish] button is always greyed out. What is missing from this screenshot?
Paul Brown
  • 223
  • 1
  • 14
14
votes
1 answer

Custom Functions with add-ons?

I've been trying to create a Google Spreadsheet plugin from some existing Google App Scripts that I have, and one important part of this app script is Custom Functions. Though the documentation for the add-ons doesn't indicate that this is…
Bob Wold
  • 371
  • 1
  • 3
  • 5
11
votes
1 answer

Publish an add-on privately

I am trying to publish a test add-on with the option Private, because there is nothing new in this add-on, and would not be accepted by Google if I published it with Public. The add-on contains a sidebar, a custom menu and a custom function. It…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
10
votes
2 answers

You do not have permission to call showSidebar / showModalDialog

I created a spreadsheet in Google Sheets several months ago and use the Google Analytics add-on. It has always worked fine until today, now if I try to create a new report, I see this error message: You do not have permission to call…
Bill
  • 109
  • 3
8
votes
1 answer

Unable to set project name in the "grant permissions" dialog for Google Apps Script Add-on

I have an add-on for Google Sheets that's currently being tested within my domain. For this post, let's call it My First Add On. When users install the add-on they're prompted for permissions, but it always appears as "Untitled project" in the…
Mathew
  • 89
  • 2
7
votes
2 answers

How to solve common errors in Google Apps Script development

The Q&A is currently a subject of meta discussion, do participate. The current plan is to split where possible into Q&As. Answers to the A&A are community wiki and the question should become one when the status is resolved. Preface This Q&A…
Oleg Valter is with Ukraine
  • 9,619
  • 8
  • 37
  • 59
7
votes
1 answer

Meaning of "Script delayed (xx min) waiting for quota" in Stackdriver when working with Google Sheet Add-on

I have developed a Google Sheet Add-On "Jira Sheet Tools" which basically for my understanding should only be affected by the followings quotas from google according to the quota dashboard: Properties read/write URL Fetch calls URL Fetch data…
LJay
  • 101
  • 7
7
votes
2 answers

onEdit(e) not working in Add-on

I've written a script that works great when used in a native spreadsheet. I am now trying to publish it as a Add-on, and am finding that onEdit(e) is not working, when onOpen(e) and onInstall(e) work fine. I've looked over the documentation on…
ebreckley
  • 111
  • 1
  • 6
5
votes
1 answer

Switching from Rhino to V8 causes Error code PERMISSION_DENIED

Recently I switched my google slides script runtime from Rhino to V8. I tested my Add-on but I got an error: We're sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED. My script uses…
tprieboj
  • 1,680
  • 6
  • 31
  • 54
5
votes
0 answers

G Suite Add-on refusing to connect to drive? How to solve "drive.google.com refused to connect" error?

I am trying to use a G Suite Add-on called YAMM that I regularly use. Recently, I have been encountering an error "drive.google.com refused to connect" often. When I contacted the developer, they say it is Google's problem. How do I get it fixed?
AHunt
  • 1
  • 1
  • 4
  • 12
1
2 3
…
17 18