270 questions
Advice
0
votes
4
replies
51
views
Slides Add-On accessing Sheets Data and Narrowing Scopes
I have an Add-On under review in the Google Marketplace.
My Add-On runs in Google Slides and needs to access Google Sheets data to create various visuals in Slides. Specifically my Add-On pulls data ...
- 67
1
vote
1
answer
63
views
How to test a Google Drive add-on?
I have written a simple add-on using google apps script, and "deployed" it as "Add On".
But whatever I do, I cannot figure out how to connect that add on to my drive account so I ...
- 40.6k
0
votes
2
answers
105
views
Making a Google Workspace add-on interface in HTML [closed]
I am planning to build a Google Workspace add-on. However, I am not fond of their CardService that isn't very flexible. I would like to make a more visually appealing interface of my own, using HTML, ...
- 855
0
votes
1
answer
67
views
Card click function in Google App Script add-on?
Cannot understand why when I'm pressing the button it triggers the function multiple times.
Also, the event handler handleCardClick(e) returns back whole json (instead of saying what action was ...
- 11
1
vote
0
answers
96
views
Google Calendar Add-on sync not working for users with many events
I have built a custom Google Calendar Add-on. After user authentication, it allows users to create an event with name, date, time, and selected add-ons. Once the user selects an add-on, the event is ...
0
votes
0
answers
261
views
Google workspace calendar third-party conference add-on not working even tho conferenceData is returned from the http endpoint
I am trying to create a Google Workspace calendar add-on for a third-party conference solution using HTTP endpoint (aka alternate runtime for addons). I set up the HTTP endpoint server in Spring Boot. ...
- 1
1
vote
0
answers
47
views
Issue with URL Whitelisting in Review Environment vs. Local Testing
I'm encountering an issue with my Google Workspace Marketplace app submission. The app was rejected because, during the review, an external URL appears to not be whitelisted. However, when I run the ...
0
votes
0
answers
56
views
setExternalDataSource function not working properly [duplicate]
I am using google appscript to create a selection box with async functionality.
I have been trying to use the setExternalDataSource() method for getting the data from but I am not able to get any ...
- 3
0
votes
1
answer
95
views
Gmail how create draft reply, witch is in these same thread
I created a script (via Google App Script) that simplifies replying to emails. The script replaces the following manual steps:
(while in an email)
Forward the email.
Copy the "To" addresses ...
1
vote
0
answers
93
views
How to pass parameters in the body of a GET api call with UrlFetchApp
Hi,
I’m desperately trying to call this API with Google Apps Script: Get issue limit report.
The documentation says to pass this parameter as payload this object: { "issuesApproachingLimitParams&...
1
vote
0
answers
60
views
How to configure `appscript.json` for a Google Sheets Editor Add-On? [duplicate]
I've been trying to submit a google sheets editor add on to the google workspace marketplace for the last few weeks, and have been stymied by feedback from the review team that my app is configured as ...
- 159
0
votes
0
answers
74
views
In Google Workplace apps, can I create a "forSpreadsheet" "onFormSubmit" trigger from within the Google Forms script?
I have an app current in the Google Workspace Marketplace. It's a Google Forms editor add-on and a Google Sheets editor add-on.
I'd like to make use of the "onFormSubmit" trigger of Sheets ...
-2
votes
1
answer
266
views
How to show instruction with image after install google workspace extension?
We've published our Google Sheets add-on, but new users often don't know how to access the extension after installing it. Currently, this is what we show by default, but I'm not sure how to change it.
...
- 431
0
votes
0
answers
74
views
Quotas and price charge for services running in a App Script Add-On as user in Google Workspace
I'm developing an application to run as Add-On in the Google Workspace Marketplace and after reading all the questions already answered here still not clear the quota limit and cost for an App Script ...
1
vote
1
answer
73
views
Is it possible to use third-party UI libraries like Material UI or Kendo UI within Apps Script for Gmail add-ons?
We are developing a Gmail add-on and are currently using the built-in Card Services UI controls. However, these controls are limited and do not offer the level of customization we need.
We are looking ...
0
votes
1
answer
55
views
Non-Functioning Google Workspace Add-on But Works During Test Deployment
I am new to programming in Google Apps Script. I wanted to create a script to manage Classroom in Google Sheets. The problem is that everything works fine in the test deployment, but nothing shows up ...
0
votes
1
answer
51
views
Unable to Invoke composeTrigger Function and Triggers Fail to Update Signature Quotes in Compose Email Popup Without Page Reload
We are currently experiencing an issue with the Signature quotes not updating in real-time. Presently, the Signature updates are only reflected after reloading the page. Our goal is to achieve real-...
- 124
0
votes
0
answers
74
views
Using IMMUTABLE_HTML inserts HTML twice in mail
We are building a Gmail addon with Google Apps Script. We have run into a strange problem where Apps Script inserts HTML twice into the composed email. This is example code where "HELLO" ...
1
vote
2
answers
197
views
Button colors don't take color scheme defined in manifest into consideration anymore
I have a Google Workspace Add-on for Gmail using Google Apps Script. that has been deployed for more than 1 year now. I've decided to put a log in some part of it and changed a string and when I ...
0
votes
1
answer
166
views
I am using cardService, why addon (testing) takes to run function too long and gives at last error execution maximum time
I have script that works fine as editor add-on but when I am testing as workspace add-on (as a stand alone appscript) the functions takes too long to run, it does what actually planned, but gives ...
1
vote
0
answers
55
views
How the extend the Gmail access token?
I am trying to create an add-on in which you can get a file from Drive or an attached document in a Gmail message and send it to my backend to scan it.
Drive is working perfectly, however I am having ...
0
votes
1
answer
179
views
Google Workspace Add-On addOns.common.homepageTrigger will not trigger a second time
I have an add-on which utilizes the addOns.common.homepageTrigger function to show a sidebar (https://developers.google.com/apps-script/add-ons/concepts/homepages)
If the user clicks the add-on button ...
- 319
1
vote
0
answers
83
views
onGmailCompose has stopped populating the event draftMetadata properties on iOS
All "recipients" properties of the "draftMetadata" object passed into "onGmailCompose" stopped coming through (are now missing) on iOS (iPad and iPhone).
My Apps Script ...
- 119
0
votes
0
answers
380
views
Invalid argument: key error in Utilities.computeRsaSha256Signature
I tried the below code in my code.gs. I'm getting an error.
let privatekey = 'IcA3+ZwPmUMtAou4f9hJMg==';
var key = `-----BEGIN PRIVATE KEY-----\n${privatekey}\n-----END PRIVATE KEY-----\n`;
...
- 311
1
vote
0
answers
388
views
How to center align a button using CardService?
I m trying to center align a button horizontally in my calendar addon plugin using google apps script but cannot find any property to do so for buttons.
So, before, we made it work by a hack, which ...
- 11