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
2,024
questions
0
votes
0
answers
24
views
google apps script to return sheetnames along with isActive and isHidden state, on deploying the web url does not output as expected in doGet function
the implement function returns the sheetname, sheet active or not, sheet hidden or not accurately. Function given below -
function doGet() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var ...
0
votes
1
answer
91
views
Google Apps Script: creation of PDF Documents out of Spreadsheet data and providing the PDF URL into the Spreadsheet
I am trying to create PDF Documents with Spreadsheet Data and I wanna paste the PDF URLs of the created PDF Documents back into the Spreadsheet.
My Code seems to be working mostly, it creates the Temp ...
0
votes
1
answer
69
views
503 error when trying to get google doc with many pages
I am facing an issue with Google Drive API.
I am using PHP (version 8.1.27) with the Symfony framework (version 6.4.*) on Ubuntu ( version 22.04.3 LTS). I incorporated the latest Google API library (...
0
votes
0
answers
27
views
Appointments canceled from a series do not appear in the events api as canceled
We've implemented a connection to Google's API (GET https://www.googleapis.com/calendar/v3/calendars/calendarId/events/eventId) to retrieve events from the Google calendar. Typically, when a series ...
0
votes
0
answers
34
views
Google Workspace SAML login for custom apps
Currently at my company we have custom apps to do a bunch of things but each has it's own login and password as well as expiration for passwords and other nonsense. I've been asked to use the SAML ...
0
votes
0
answers
96
views
How to stop Google Docs from showing the annoying @ sign before I type
How to disable that annoying and distracting @ sign? I do not want to collaborate, I want to work alone.
1
vote
0
answers
24
views
Set vendors on Context Manager (Custom Access Level)
I am looking to block Google Workspace sign in for any user who do not have my agent on their computer. I have seen a new parameter "vendor" appearing on the list below. This new parameter ...
0
votes
0
answers
88
views
Google App Script cannot fetch CSS file hosted on Google Drive (403 unauthorized)
I have a problem with Google App Script accessing Google Drive hosted assets. And the strange fact is that it was working all the time and just stopped working several days ago.
What is happening: In ...
0
votes
0
answers
61
views
OnSelectionChange trigger works only after page reload
I have a simple script that is triggered when the selected cell is changed. Unfortunately, when the document is freshly opened, the script does not start, no matter how many cells I click on. It ...
0
votes
0
answers
12
views
Xcode login Managed Google Workspace account
I can't login to Xcode for signing anymore now that my dev account was transfered to a managed Google Workspace account. Any idea how i can login, Xcode says it doesnt recognize the E-Mail as an Apple-...
1
vote
1
answer
899
views
why Image is not Display in web app made in google app script? [duplicate]
Why is not displayed in the web app made in the app script and using Google Workspace ID as well as Gmail ID, in both cases image is not displayed, but in some domain IDs, the image is displayed with ...
0
votes
0
answers
14
views
Duplicating a Name and assigning a number based off a cell quantity
I am runninga fundraiser and am trying take a report that shows the number of tickets purchased by an individual for a specific item. I want to be able to assign a paper ticket number for each ...
0
votes
1
answer
399
views
Connecting my cloud build with cloud sql specifically inside the docker build
Thank you in advance for your help.
I want to deploy my landing page to Cloud Run, it's a pretty basic NextJS app, there was no problem in deploying the app until I added this single API route:
import ...
1
vote
1
answer
85
views
How to copy a cell with a mention to another cell
I have 2 spreadsheets.
In the first I have a column filled with the values made by @mention as shown in the image below.
enter image description here
The second spreadsheet I use to receive this data ...
0
votes
0
answers
17
views
Can you create 2 rows in Excel with one Google Forms submission?
Each Google Forms submission creates a Row in the Excel document. Is it possible to submit a single response that populates in multiple rows as opposed to columns? I.e. keeping other inputs constant ...
0
votes
0
answers
69
views
Create new Google Workspace account and send sign-in instruction automatically using API
As a new user onboarding process, I'm creating new account in workspace using API.
I'm using below API to create new account:
https://admin.googleapis.com/admin/directory/v1/users
New account gets ...
0
votes
0
answers
22
views
Swim Times MM:SS.00 Subtraction, and Transferring to Different Sheets
I created a Google Sheet to catalog my swim times and find out how much of a difference I have in time between swims. I have a =query carrying over data from one sheet to another, but it does not ...
0
votes
0
answers
51
views
Getting generic server error on Image.getBlob() in Appscript
In appscript for a Google Slides extension I am getting a generic error in my logs:
Exception: We're sorry, a server error occurred. Please wait a bit and try again.
In my code, I am simply getting an ...
0
votes
0
answers
107
views
Google Apps Script: Problem with error "Exception: Couldn't open document ... Unable to load document."
I keep getting the following error message when I run my code:
"Exception: Couldn't open document with id 1IOwbcFWrh_jEeZbhVgw5fEbGOtM6zXKpmdrO_qUGNZM: Unable to load document."
I can't see ...
0
votes
1
answer
76
views
Cannot find Classroom Addon function
App Configuration
Navigate to the GWM SDK's App Configuration page. Provide the following information:
Set App Visibility to Private. This setting is appropriate for testing and development purposes, ...
0
votes
0
answers
53
views
Google Sheets Query a table of sales data and multiply 2 columns together as shown
Can you help with this please.
I have a large sales data table as shown below. I'd like to QUERY that with the desired results shown below it. Note that as sales are tallied up for each sales rep, I'd ...
-1
votes
1
answer
301
views
Google workload identity federation to call directory API
I'm trying to set up Google Identity Federation with AWS to make admin.directory API calls from aws lambda function. It is written in Java.
I set up workload pool, created service account and ...
0
votes
0
answers
22
views
Google Site - File Structure Replication with Auto Naming?
I am creating a Google Site and creating a calendar within to link to a document for each and every day for every month of the year.
Are there any easier ways to replicate this structure for a ...
3
votes
0
answers
108
views
Best practices to identify users in Gmail API?
The Gmail API uses a UserId which is the user email address. However, an email address is not a reliable identified over the time. On Google Workspace, it is frequent that user email addresses are ...
0
votes
0
answers
83
views
Google Workspace API - How to GET Devices (Computers NOT Mobile Devices)
I'm looking to perform a GET to retrieve details of a users devices (computers) to perform actions in a similar way that I can for mobile devices.
Please advise if this is possible.
Cannot find API to ...
0
votes
0
answers
79
views
Why does my browser page freeze when making a Google Sheets api (v4) call in my Unity WebGL build?
recently I've been involved in a game project where some data of the player needs to be collected and stored centrally. Due to unavailability of a database, we're using Google Sheets to store the data ...
0
votes
0
answers
37
views
Gmail API How to deal with non existent threadId
I am working on a solution to restore a message back into a Gmail mailbox as close to the original message as possible. I downloaded the message and its RAW content. I was to then insert this message ...
0
votes
2
answers
403
views
Whats the Difference Between a Chrome Extension and Workspace Marketplace App?
Can someone please explain to me the difference between a Chrome Extension and a Google Workspace Marketplace App?
I have tons of experience in Chrome Extensions, but I don't understand the difference ...
0
votes
1
answer
59
views
How can i make gmail send me HTTP request everytime i get new message [closed]
I am creating a laravel app to manage my Gmail using google client api to manage my customers and connect them with the emplyees
In my app there is last_interaction attribute to each client that ...
0
votes
0
answers
19
views
looking for a formula evaluated in Google sheets
I'm looking for an add on in Google Sheets to help me evaluate formulas
Like the formula tab in Microsoft Excel, is there an option to evaluate the formula in Google sheet?
0
votes
0
answers
37
views
I am using google sheets and receiving error Cannot find range or sheet for imported range?
I am using google sheets and receiving error Cannot find range or sheet for imported range? Everything is correct and I reviewed all possible solutions. I have looked at all reviews to find the ...
0
votes
0
answers
48
views
I get a 400 error when accessing the Admin SDK Api
I use GET https://admin.googleapis.com/admin/directory/v1/customer/{customerId}/orgunits to get information about all organizers. I use the service account to authorize requests.
But I get an error ...
1
vote
0
answers
33
views
Google App Script Error : API call to bigquery.jobs.getQueryResults failed with error: Not found: Job [duplicate]
I'm attempting to use Apps Script to retrieve data from BigQuery and put it to a spreadsheet, but I'm getting the following error notice when my script runs:
GoogleJsonResponseException: API call to ...
0
votes
0
answers
57
views
Gmail API attachment preview not working after insert call
I am using the .NET client library to perform an users.messages.insert call to a Gmail mailbox. I am inserting a MIME message with an attachment by encoding it into URLSafeBase64 and adding it to ...
0
votes
0
answers
62
views
Is there a way to access Google Workspace if Squarespace is the provider of said services?
I'm an IT Administrator and my client wants access to Google workspace. They are currently with Squarespace who provides email through google workspace. I've been in contact with Squarespace and ...
1
vote
1
answer
68
views
Can't send an email from service account, get 400 Precondition check failed error
Trying to send an email using a service account with role owner within my project. I keep getting a 400 error that says Precondition check failed.
const sendEmail = async () => {
const auth = new ...
0
votes
1
answer
1k
views
Where to get the IDP Metadata url from?
Our customers integrate their SSO (okta/google) with our SaaS.
Now inorder to authenticate them, we do a SAML login.
The crewjam library in golang has the following snippet which asks for metadataUrl :...
0
votes
0
answers
166
views
Restore deleted user using Google Admin API
I deleted a user before and was able to recover them by following https://developers.google.com/admin-sdk/directory/reference/rest/v1/users/undelete. Through research, I saw that they can also be ...
0
votes
1
answer
346
views
Checking student submission marked as "Excused" in Google Classroom
There is a new feature in Google Classroom that allows the teacher to mark a student submission to an assignment as excused. This renders the submission "Graded" but allows the grade to ...
0
votes
1
answer
439
views
Rewrite "from" address to X-Gm-Original-To field
I own a domain name and use Google Workspace to manage the email for it (i.e. example.com). I have an email catch-all set up to forward all emails sent to the domain to a catch-all email address, and ...
0
votes
0
answers
75
views
How can we make the Google App script able to send POST request on a webhook which is only accessible within my Internal Network
I have created a Google-app Script which will take the slash commands(/job;/help etc) from the GoogleChat App and sends the POST request to respective webhook api which is only accessible within ...
0
votes
1
answer
66
views
Google Form - Delete rows/records older than 3 years
I have a google form that records sales of certain items to customers. I need to automatically delete rows that are older than 3 years. This is for GDPR data retention reasons.
I though I could have a ...
0
votes
0
answers
21
views
Trying to create a batch file for opening a new tab on Chrome
I want a batch file that can open a specific webpage every time on a new tab in chrome. How can I do it?
The tried script which is very very simple, I guess
@echo off
"C:\Program Files (x86)\...
1
vote
0
answers
170
views
Changing Google Forms question options without affecting existing answers
I have a Google Forms questionnaire which has already received a number of answers. I've noticed that many of the questions are "checkboxes" when they should've been "multiple choice&...
0
votes
1
answer
115
views
Unable to create a contact within a specified label, in google people api
I programmatically created a new label and obtained the corresponding label ID as a response mentioned below.
contactGroups/47b2ea780fbdabe
Using above Id, i am trying to add the contact details ...
0
votes
0
answers
33
views
I want to update some html inside google doc for some placeholders
function insertDataToDoc(copiedDocId, placeholder, contentToReplace) {
placeholder = '{{Response'+ placeholder+'}}';
//placeholder = '{{Response1}}';
Logger.log(placeholder);
// Open the ...
1
vote
1
answer
48
views
how use client-side html to server-side in Gmail add-on apps-script?
when use client-side html to server-side then not show out put of client side html in Gmail add-on sidebar. Gmail add-on side bar show message that "Content not available for this message".
...
0
votes
0
answers
57
views
Parts of Deal Annotation Not Showing in Gmail Promotions Tab
My team has been testing using deal annotations on marketing emails, but we're having issues getting the full annotation to display in the Promotions tab.
When testing with the preview tool, ...
0
votes
0
answers
13
views
Google Workspace Marketplace listing for firebase mobile app
My flutter based mobile app is on Firebase and I want to publish on Google Apps Marketplace so user can login with google and have user install the mobile app from web app. Is this possible? If yes, ...
0
votes
1
answer
159
views
How do I make my add-on appear as a "primary" sidebar that appears on the far right?
We have an add-on that appears as a sidebar using the Ui.showSidebar function. To make this appear we are utilizing the homepageTrigger feature in appsscript.json
This works fine, however I notice ...