2,035 questions
0
votes
0
answers
11
views
How can I correctly set the nestingLevel (0, 1, 2) for items created by createParagraphBullets in Google Docs using the Google Docs API?
I am trying to programmatically create a hierarchical bulleted list in a Google Doc. The goal is to have items at different nesting levels (e.g., Level 0 ●, Level 1 ○, Level 2 ■). My process involves:
...
0
votes
0
answers
35
views
Google Script Cannot Fetch Users With Licenses (Via SKU ID)
I have recently gotten into Google Scripting to manage a School's IT space. I am currently working on a script that should check any students who have left and remove their paid licenses. However, I ...
-3
votes
0
answers
47
views
Workspace Flows Error: "Unsupported mime type" in Ask Gemini step when processing multiple attachments [closed]
I recently encountered an issue with a Google Workspace Flow that was previously working fine. The flow is designed to review contracts received via email using Gemini.
My Workflow Structure:
Trigger:...
-1
votes
0
answers
72
views
Is Looping possible in Google Workspace Flows [closed]
So, while building automation agents with google workspace flows, I'm documenting a number of files, and extracting data from the files, and inserting them in google sheets, using the flows ...
0
votes
0
answers
59
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
{
...
0
votes
0
answers
51
views
Gmail API 403 "Delegation denied" error using Service Account DWD (Apps Script) despite Super Admin role
I am running a Google Apps Script to programmatically update Gmail signatures for users across my Google Workspace domain using a Service Account with Domain-Wide Delegation (DWD).
Despite confirming ...
0
votes
1
answer
64
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 ...
0
votes
0
answers
37
views
Drive API Impersonation Ignored Despite Correct Admin/GCP Configuration
I am a Google Workspace Admin attempting to set up a scheduled Apps Script using a Service Account (SA) and Domain-Wide Delegation (DWD). The goal is to iterate through all user Drives, find "...
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].
...
0
votes
0
answers
26
views
Completed tasks are missing in Google App Scripts when showHidden is false
I'm using the Task API in Google App Scripts.
When getting a list of tasks, if I don't explicitly specify showHidden: true in the request, the completed tasks are missing.
Shouldn't showCompleted: ...
0
votes
0
answers
61
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
0
answers
62
views
Why doesn’t the Google Cloud Identity Policy API reflect changes to password settings like max length?
I'm working with the **Google Cloud Identity Policy API **to programmatically retrieve the configured security policies of my organization. Specifically, I updated the maximum password length from the ...
0
votes
2
answers
106
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, ...
1
vote
1
answer
94
views
How do I convert a newly generated Google Apps Script url into a hyperlink that is also displayed within the Google Apps Script?
The following Google Apps Script runs with absolute perfection. I prefer the newly generated Google Forms url be converted into a hyperlink to avoid copying and pasting, but I am not sure how and ...
2
votes
0
answers
79
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 ...
0
votes
0
answers
13
views
shoppingcontent.products.update is not updating the product
I am trying to update the customLabel0 of the products in my Merchant Center through Google ads script. I have enabled the Shopping Content in the advanced API section.
When sending the request, I am ...
1
vote
1
answer
80
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 ...
1
vote
1
answer
92
views
Can I download all files from a selected directory using only drive.file permission?
I'm using the Google Drive Picker to let users upload files from their own Google Drive. I'm using the https://www.googleapis.com/auth/drive.file scope for permissions.
Users can manually select ...
0
votes
0
answers
35
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 ...
1
vote
0
answers
141
views
Google Docs API - 403 - googleapiclient.errors.HttpError: 403
Problem:
I am facing this error-
googleapiclient.errors.HttpError: <HttpError 403 when requesting https://docs.googleapis.com/v1/documents?alt=json returned "The caller does not have ...
0
votes
1
answer
56
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 ...
1
vote
0
answers
93
views
I can't send email from .NET application using Google SMTP client, application passwords
I have Google workspace, created for my mail application passwords and used the code as password in my .NET application. This worked for me in test application without Google workspace, from private ...
0
votes
1
answer
149
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 ...
0
votes
0
answers
71
views
Google Calendar API keeps returning empty result set with events.list
I have Google Calendar with multiple events, both single and recurring. Occasionally I run a script to refresh it by deleting all existing events and adding new ones, using the Google Calendar API.
To ...
0
votes
1
answer
517
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 ...
2
votes
0
answers
107
views
How can I retrieve Google Classroom audit logs programmatically (without Admin Console)?
Is it possible to automatically retrieve Google Classroom audit logs via an API or similar method, instead of downloading them manually from the Admin Console?
I initially thought I could use the ...
0
votes
0
answers
26
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&...
0
votes
1
answer
60
views
When I try to assign a license to a user, the Google Licensing API returns 503 status ServiceUnavailable
I'm trying to assign a Google Workspace for Education Plus license to a user.
LicenseAssignmentInsert body = new()
{
UserId = "111111111111111111111",
}
await queries.LicensingService....
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 ...
0
votes
1
answer
108
views
Data Transfer API 401 error with service account (Domain-wide Delegation), but Directory API works
I'm trying to use a service account with domain-wide delegation to transfer Google Drive data between users in my Workspace domain.
The service account works fine with Directory API, but the Data ...
1
vote
1
answer
126
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 ...
0
votes
0
answers
61
views
AppScript creates #ERROR! depending on folder of saved file
I've programmed an App Script in Google Sheets. This App Script provides the name of the respective sheet (tab) as a formula. I've used this App Script in several Google Sheets, all of which are ...
-4
votes
1
answer
184
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 ...
0
votes
1
answer
55
views
Getting 404 when trying to execute GCP scripts().run using service account
I'm trying to access an Apps Script I have created, via Python using a service account that I have which is linked to my GCP project.
I've created an API executable deployment, and set the project ...
0
votes
0
answers
84
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
...
1
vote
1
answer
63
views
Google License API Manager: 503 'backendError'
Currently getting this error:
Error managing archive license for [email protected]: <HttpError 503 when requesting https://licensing.googleapis.com/apps/licensing/v1/product/101034/sku/1010340001/...
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 ...
0
votes
1
answer
102
views
Finding the google spreadsheet line with <input type="date"> [closed]
I am working on a web application(google apps scripts) that summarizes the reports for the day(with bootstrap 5). I am using a data input to make the user choose a date for him to read the day's ...
0
votes
0
answers
75
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("...
-1
votes
1
answer
108
views
How to integrate/access google drive API when deploy in cloud run (trouble when using ADC)
I have developed an application using GCP- using python, and have tested it on local environtment and it was running successfully.
My apps access google drive API using local OAuth credentials.json ...
0
votes
1
answer
139
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 ...
3
votes
1
answer
174
views
Does Google Chat App Support Showing Typing Indicators?
I've developed a Google Chat app through a Google Cloud project (enabled the Google Chat API, created the app, and deployed it internally). The app is added to chats via the "New Chat" ...
-1
votes
1
answer
293
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 ...
0
votes
0
answers
116
views
Google Chat CardV2 with 'buttons' widget results in "Bot not responding" / API 400 Error
I'm developing a Google Chat bot using Node.js on Google Cloud Functions. I'm trying to respond to a slash command with an interactive card (CardV2) containing buttons.
What Works:
My function ...
-1
votes
0
answers
59
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
47
views
Email Routing Catchall Rules
I'm having trouble defining the rules to help me route the emails the way I'd like in my google workspace instance.
For now, the instance just has 2 users, my spouse and I (gonna use john and jane in ...
0
votes
0
answers
63
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 ...
0
votes
0
answers
35
views
Will the Google Document's generated published url expire?
I used the google drive api v3 to get the published url for a google document. This is the api I used to retrieve the publishedLink: revisions.get. I am able to get the published url, it's something ...
0
votes
0
answers
41
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 ...
1
vote
0
answers
23
views
How connect by JDBC Service Apps Script to Oracle Database [duplicate]
In the JDBC Service documentation
'This service allows scripts to connect to JDBC-compliant databases, including Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle. See also the JDBC Guide .'
...