2,024 questions
0
votes
0
answers
13
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:
...
-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 ...
-3
votes
0
answers
48
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:...
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
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
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, ...
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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
1
vote
0
answers
94
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 ...
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
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 ...
2
votes
2
answers
250
views
Google Workspace Admin SDK Email Log Search Reports API: How to retrieve email delivery status?
I'm using the Google Workspace Admin SDK Reports API - Email Log Search in Node.js to retrieve email logs for messages sent from my domain. I'm able to get details like:
Sender email
Recipient email
...
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 ...
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
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 ...
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 ...
-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 ...
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" ...
19
votes
7
answers
20k
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 = '/...
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
518
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 ...
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 ...
3
votes
1
answer
354
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 ...
5
votes
2
answers
301
views
Can we get Workspace Customer ID through API for non-SuperAdmin users?
There is a value called Customer ID in Google Workspace, which will be unique for every Workspace. You can find this value in Google Admin Console -> Account -> Account Settings -> Profile -&...
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 ...
41
votes
10
answers
43k
views
Configuring GSuite to work with route 53 - "MX record doesn't have 2 fields" error
I'm doing my best to follow GSuite's out of date instructions for routing emails to Gmail via a AWS Route 53 hosted zone (i.e. domain). Here are the outdated instructions:
I set the Values as ...
-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
140
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 ...
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
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/...
-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 ...
-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
1
answer
202
views
How to setup Aurinko api for google email API
I recently watched a YouTube video where he built a SaaS project. The instructor built an email client SaaS project, and you have to set up an Aurinko account. I was following and building the same ...
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("...
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 ...
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
...
4
votes
2
answers
5k
views
How do I remove the iam.disableServiceAccountKeyCreation constraint
I am trying to implement backups for a Google Workspace using Synology's Backup for Google Workspace, and following their implementation guide.
I have set up a Project and am now trying to create a ...
0
votes
2
answers
3k
views
Finding the last row
I have a script that is copying data from a sheet on a google sheet to a different google sheet. It's supposed to find the last row and then copy the data 1 row below that. It has been working but ...
5
votes
1
answer
7k
views
Organisational Policy Permissions Google Cloud for Microsoft Migration
I am attempting to shift a small business (5 email inboxes) over to Microsoft 365 business. I made sure to organise all the DNS prerequisites on both sides before performing the migration. During the ...
0
votes
1
answer
57
views
How do I make a drop down of variations for a product?
When I type "product" in a cell. The cell next to it would show a list of available variations via a drop-down menu?
Something like this?
This is the data sheet
DATA SHEET:
Column A
Column B
...
0
votes
2
answers
191
views
Filters Not Functioning for Admin Application Logs in Google Admin SDK
I am using the Google Admin SDK (Reports API) in a C# .NET console application to retrieve logs for the Admin application. While the API supports filters to refine the results, none of the filters ...