2,033 questions
0
votes
0
answers
35
views
Activities.Watch() gives me the 'sync' event only
I want to get notifications when an admin adds a user in a group in Google Workspace. And I call the Watch method to do it:
var channel = new Google.Apis.Admin.Reports.reports_v1.Data.Channel
{
...
- 1
0
votes
1
answer
63
views
Guide User to Log Into Workpace Account with Published Apps Script Web App for Only My Domain
I have a published Web App in Apps Script set to "anyone in my domain can view" that I need to "execute as me". If an end user is only signed into Google accounts that aren't in my ...
- 1,211
0
votes
0
answers
36
views
Modify the signature label in gmail [duplicate]
I am developing a script that will update all the user signatures in our workspace. It works however the signature label is "My Signature" instead of the primary email e.g. [email protected].
...
- 79
0
votes
0
answers
57
views
What function should I use to search a 2d Array for a value and return all values from left most column
I Have a sheet that is bringing across all the article ID's listed there (and associated names) in line with the said name of that sheet.
Also above this information I am looking to make a simple ...
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
2
votes
0
answers
76
views
How to display formatted code blocks in Google Chat cardsV2 API notifications?
I am trying to add code block formatting to a card sent as a notification via Google Chat cardsV2 API. However, the code block formatting is completely ignored and fails to render properly.
I have ...
- 21
1
vote
1
answer
76
views
GmailApp.search() doesn't find recent emails
I'm the IT admin for a small music studio. We receive new inquiries about private lessons from a web form, which sends a copy of each submission to an inbox I share with other staff. An Apps Script ...
- 11
0
votes
0
answers
31
views
automate =QUERY(IMPORTRANGE) or =IMPORTRANGE()
I need to have =QUERY(IMPORTRANGE) or simply =IMPORTRANGE() in sheets2 and sheets3 to automatically do its' thing as soon as the exporting sheet (source file) receives the data from its' source (drive ...
0
votes
1
answer
48
views
Page Totals and Running Totals on Export in Google Sheets
I'm looking to export a logbook of mine to paper. The logbook consists of entries of hours based on dates that continue row by row.
I need to export these entries through printing with each page ...
0
votes
1
answer
138
views
Gmail API OAuth 2.0 Token Expiration – Post SMTP Connection Fails Intermittently
I'm using the Gmail API integration with the Post SMTP plugin on my WordPress site. The setup and initial configuration were smooth, and everything works perfectly after connecting. However, I'm ...
- 1
0
votes
1
answer
485
views
Google Cloud Organization Policy iam.allowedPolicyMemberDomains INVALID_ARGUMENT for Verified Domain
I'm trying to set the Google Cloud Organization Policy constraints/iam.allowedPolicyMemberDomains to restrict IAM members to my organization's verified domain, sksolution.app. However, I'm ...
- 197
0
votes
0
answers
23
views
GCP workspace : incoherent behavior with threadKey
I'm doing this
curl --location 'https://chat.googleapis.com/v1/spaces/XXX/messages?key=this-is-secret&token=this-is-also-secret' \
--header 'Content-Type: application/json' \
--data '{"text&...
- 1,959
0
votes
1
answer
97
views
SAML authentication request with Google Workspace as the IDP
I have tried importing SAML libraries like SimpleSamlPHP and saml_tools and onelogin_saml, but none of them are simple. They are complicated by all of the options available.
So I'm looking to roll my ...
- 434
1
vote
1
answer
118
views
How to restrict access of a service account to only specified user(s) in google workspace?
I'm developing an application that needs to read and label emails from a single, specific mailbox that is a part of a google workspace.
I managed to connect a service account to the workspace using ...
- 10
-4
votes
1
answer
175
views
Appsheet Bot Webhook cannot get JSON response from Google App Script Web app
Since Google Appsheet Bot Webhook cannot handle nested arrays of complex types JSON response from the Plate Recognizer API, I built a simple Google App Script as a proxy to simplify the API response ...
- 11
0
votes
0
answers
79
views
Unable to Enable Google Calendar API
I am unable to enable the Google Calendar API for my project.
Technical Details:
Attempted Command: gcloud services enable calendar.googleapis.com
Error: PERMISSION_DENIED for calendar.googleapis.com
...
2
votes
1
answer
149
views
"Cloud Identity Groups" Advanced Service Missing in Apps Script "Services" List?
This page:
https://developers.google.com/apps-script/advanced/groups
says that there is an Advanced Service for Cloud Identity Groups that can be enabled, but my list of Services has no such option in ...
- 1,211
0
votes
0
answers
72
views
Unable to fetch user list from google workspace due to: Resource Not Found: userKey
I was trying to fetch the user list using the below approach:
def getGsuiteUserData(self, data):
access_token = data.get('access_token')
if not access_token:
raise Exception("...
- 664
0
votes
1
answer
133
views
Java Google Mail API send "Precondition check failed" - 400 Bad Request for Service Account server-to-server no user
In response to Google's recent change to disallow username/password access to Google Workspace accounts from Google Cloud VM-instances, I am attempted to replace sendmail calls with Google API calls ...
- 53
-1
votes
1
answer
276
views
issue with formula googlefinance
I am having an issue with a specific symbol of the HK stock market using the formula googlefinance().
=googlefinance("HKG:2800","price")
returns no value where all other tickets ...
- 1
0
votes
0
answers
52
views
Updating Image Metadata within Google Docs programmatically
I'm looking to programmatically update images within Google Docs, Sheets, and Presentations. I know I can replace images via batchUp using a ReplaceImageRequest, but I have been unable to modify the ...
0
votes
0
answers
59
views
Create and control OAuth clients on Google Workspace/Google Auth Platform
We develop lots of web applications which our employees use to manage integrations between our various systems. Authentication for those applications is OAuth. Currently, we're using IBM Security ...
- 395
0
votes
0
answers
37
views
Edit Google Sites with Google Apps Script
Everything I've found (including this official documentation https://developers.google.com/workspace/sites) shows that there isn't an API to edit the new Google Sites.
Is there any noise or thought to ...
0
votes
0
answers
63
views
Google Drive API: List All Files in a Domain (Including Private & Shared) Using Service Account with DWD
I have created a Google service account and granted it Domain-Wide Delegation (DWD). I am trying to use the Google Drive API to list all files present in the domain, including both users' private ...
- 3,540
3
votes
1
answer
334
views
How to create google doc tabs with the python sdk
I’m trying to create a Tab in a google doc via the python SDK (as in the new(ish) side navigation/organizational tabs, not a tab character). I see how to read and update existing tabs, but don't see ...
