All Questions
Tagged with google-workspace google-apps-script
50
questions
4
votes
1
answer
5k
views
How to use the Gmail API, OAuth2 for Apps Script, and Domain-Wide Delegation to set email signatures for users in a G Suite domain
This is a follow-up to a previous question/answer I posted (How to use the Google Email Settings API and the OAuth2 for Apps Script Library to set email signatures for users in a Google Apps domain), ...
8
votes
1
answer
3k
views
Publish Google Sheets addon privately (no-verification) with new G Suite Marketplace process
Problem
I can't find a way to publish a "private" google sheets addon and share it to testers with the new G Suite Marketplace process as it used to be possible with the Chrome Web Store publication.
...
0
votes
1
answer
2k
views
How to enable not authorized users to protect the spreadsheet
In our team we have the following scenario:
we're using a google spreadsheet with some protected areas (mainly formulas that must not be overridden - only the "admin", in our case it's me, ...
6
votes
1
answer
2k
views
Creating and testing an add-on for Google Sheets in the new Script Editor
I've created several internal add-ons to automate a few workflows within our company using the "old" Apps Script IDE. Now I'd like to create a new one using the all new Apps Script IDE which ...
0
votes
2
answers
3k
views
How to get a list of G Suite users which are using Google Apps Script?
I would like to find out, is there any chance to get a list of G Suite users (of one domain) who are using Google Apps Script?
25
votes
1
answer
27k
views
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 =...
7
votes
2
answers
7k
views
Allowing anonymous access to Google Apps Script web app (Google Apps account)
I have a spreadsheet in my Google Drive that I would like to share through a web app. I want the script to run as me and allow everyone to access the web app.
When this is done in my personal Google ...
4
votes
4
answers
2k
views
Publishing Google Script Addon to G Suite Marketplace SDK
I've got some Google Sheet script code that I'd like to extract into Google Sheet Addon to be published for just of our domain (not public web). Individuals on my team have been able to do this ...
3
votes
1
answer
3k
views
An explicit urlFetchWhitelist is required for all Google Workspace add-ons using UrlFetchApp error while deploying sheet add on
I am trying to deploy a google sheet add on (private add on.)
I am using moment js for calculating the date in my code.js file
My manifest looks like this
Manifest:
When I go to deploy the add on I ...
3
votes
1
answer
1k
views
Is it possible to publish a Google Apps Script Web App to G Suite Marketplace?
I know it is possible to publish a Google Script Web App to Chrome Web Store, but it's possible to publish in Google Suite Marketplace?
There's no "Publish to Marketplace" option in GAS editor, but ...
3
votes
1
answer
1k
views
Google Apps Script to open password-protected Excel?
Is there a way for Google Apps Script to open a password-protected Excel file if the password is supplied when getting the file? I don't see any DriveApp method that accepts a "password" ...
2
votes
3
answers
5k
views
Retrieve custom attribute from user profile in Google API Scripts- Google Admin Directory
This is about G suite users.The following works in Google Admin Directory using Google Admin SDK. It retrieves email address and full name of user.
var myemail = Session.getActiveUser().getEmail();
...
2
votes
1
answer
1k
views
Create a Google Calendar event with a specified Google Meet ID, conferenceData.conferenceId
I am wondering why the following function creates an event with a random meet ID instead of the conferenceId I specified. The conferenceId can't be programmatically set as I want? I can set the meet ...
1
vote
1
answer
214
views
Getting an Internal Server Error when I try to edit my App Script
I have been working on a Google Sheet linked to a Google Form. I created a app script and tested it to work fine. Then I closed the App script editor and cannot get it to open again. Everytime I try ...
0
votes
2
answers
164
views
Why can't I return a list of specific email addresses from a Calendar invite with App Script?
I'm trying to return a list of specific email addresses of all event attendees on a GSuite calendar with a script and I can only return either an ID number or a list that appears only as "EventGuest, ...