Questions tagged [google-apps-script-add-on]

Filter by
Sorted by
Tagged with
0 votes
1 answer
39 views

Google Workspace Marketplace only shows first 100 sheets add-ons

When I select "Works with Sheets" on Google Workspace Marketplace, it only shows exactly 100 add-ons. I do not see any "More" button or any other way to see other than these 100. I ...
0 votes
1 answer
30 views

Is it possible to write a script that automatically triggers some function within a Google Sheets add-on?

I'm using some Google Sheets add-on which pulls information from API databases, and it has both a free subscription and paid subscriptions which add many additional abilities which I don't really need,...
  • 25
1 vote
1 answer
612 views

Apps Script - Deploy from manifest - Install add-on

The Apps Script code editor has a feature to "Deploy from manifest." After creating and saving a new deployment version, a link is shown that states: Install add-on I can not find any ...
0 votes
1 answer
26 views

Get exactly data to put on email message?

I got a function to email notice like this code below: function approvedby() { var approvedrange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Responses 1").getRange("E2:E500"); var ...
  • 11
0 votes
1 answer
1k views

Add progress bar to Google Slides

I want to add a rectangle along the bottom of each slide that displays the progress through the presentation. For example, if there were 10 slides, and the slide template is 10" wide, then the first ...
  • 1,937
4 votes
1 answer
335 views

My Add-On was approved by Google, but it is available only to members of my employer's domain

I developed an add-on for Google spreadsheets, have sent it over to Google for a review, and after much blood, toil, tears and sweat, had it successfully approved. Yet, the add-on is only available ...
4 votes
1 answer
1k views

What is the difference between Google Apps Script add-on and web app?

The issue is mainly that I don't understand what is meant by the web app. I understood that it must support HTTP requests, but otherwise is it the same? Or is the difference in publishing? I looked ...
  • 203
-1 votes
1 answer
1k views

Avoiding an authorization request for Google Scripts

I'm in the midst of trying to custom code some script that will automatically hide some sheets from some users in a shared company spreadsheet. Yesterday it seemed to be working fine, but now it seems ...
  • 1
3 votes
1 answer
4k views

Using Google Apps Script add-on without publishing

I've just written my first Apps Script add-on for showing some links in a sidebar of a Docs document. It looks like the way I created it made it bound to a specific document (the one from which I ...
  • 135
0 votes
1 answer
1k views

Install a private add-on in GSuite Gmail

Is it possible to install a private add-on (that isn't published in the GSuite Marketplace) in my organization's Gmail? If so, how can I do that? I went through all the settings under Apps Settings ...
  • 121
1 vote
1 answer
2k views

Add my scripts or add-ons to new Google doc

I've created a script or add on for my Google Document. The script exports the content to basic HTML. When I create a new doc I can't find a way to import the scripts from the existing document. From ...
  • 170
7 votes
1 answer
1k views

Test Google Spreadsheets Add-On with custom functions

I have set up a Google Apps Scripts project with the intent of creating a Google Spreadsheets add-on with custom functions. However, when I use the option "Test as add-on", I can't use the functions ...
0 votes
2 answers
53 views

Transferring a custom add-on to another Google form

I created an add-on for a Google Form: After saving it, I can see it in the add-on list: How can I use this add-on in another Google Form?
17 votes
4 answers
12k views

How to export / import a Google Apps Script as a file into a new spreadsheet?

I fear this may have an obvious answer, but I've been knocking my head over this and can't find it! When creating a new spreadsheet, we can easily create a script within it. I like to call it a macro....
  • 1,363