Questions tagged [google-workspace]
Use for questions about Google workspace, a paid solution by Google for all work place needs. Use in addition to the product in question(eg:[gmail],[google-sheets],[google-apps-script])
google-workspace
114
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), ...
15
votes
1
answer
18k
views
How to access Team Drive using service account with Google Drive .NET API v3
Does anyone know which configurations should be done to grant Google service account an access to a Team Drive which is already created?
The idea is to use a service account in a .NET backend ...
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, ...
14
votes
5
answers
13k
views
【Google OAuth】AttributeError: 'InstalledAppFlow' object has no attribute 'run_console'
I wrote a Python script(Google_add.py) which creates users in the Google Workspace. However, When it is run, an AttributeError occurred. How do I resolve this Error?
・Google_add.py (Excerpt)
PATH = '/...
7
votes
2
answers
2k
views
How to fix the "Your account does not belong to the same domain as this cloud project or app" error?
I'm updating an app on G Suite Marketplace SDK. It used to work by just changing the script version at the "App Configuration" Tab, and click Save.
Now it posted a warning at the top of the ...
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 ...
5
votes
1
answer
2k
views
Service account not Authorized to access this resource/api while trying to access directory api using Python
We use Python to get all users from a particular G Suite managed domain, but after completing the following tutorial and granting all the access needed to the Service Account, the following snippet ...
2
votes
2
answers
2k
views
How to set up Google sheets API for personal use
I'm trying to follow the instructions here which tell me to create credentials via the instructions here, which as step 6 tells me 'Click the user type for your app. If you're running a Quickstart, ...
2
votes
1
answer
2k
views
Google G-Suite API Console not showing Enable G Suite Domain-wide Delegation
I'm working with a client to setup service account credentials, for the purpose of reading G-Suite Directory information over API.
I've done this a dozen times before with no issues, and now I'm ...
0
votes
2
answers
2k
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 =...
14
votes
2
answers
10k
views
Google SAML app_not_configured_for_user / equivalent of prompt=select_account SAML
I'm using Gsuite as an Saml IDP to authentify users of my organisation on internal apps.
Everything is working fine, except for one point:
when one of my users if logged in with his/her personal ...
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 ...