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...

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 vari...

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 ...

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 ...

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 paragraph...

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...

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) wo...

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: Prope...

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...

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...

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 ...

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 c...

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 fo...

I'm working on a Google Sheets add-on in Google Apps Script and want to know how I can deploy it and install it into a Google Sheets spreadsheet whilst it is still in development (i.e. not ready to...

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 ...