Questions tagged [google-gsuite]

33 questions
0
votes
1 answer

Is there a way to allow Google Sheets to IMPORTXML that is inside my company's corporate network?

My company is on an enterprise plan and behind a FW. This means I cannot IMPORT... in a Google Sheet to any URL inside the corporate network. Is there way to make it so files in my company's G-Suite organization (example.com) can access my internal…
IMTheNachoMan
  • 5,343
  • 5
  • 40
  • 89
0
votes
1 answer

Is there some public Google API for getting the current logged in user's email address or domain that does not require AUTH or an API key?

I have a Google Spreadsheet and I need to get the current user's email address in it. I can't use GAS + Session.getActiveUser().getEmail() since that requires auth/permissions. So my thought is to use one of the IMPORT functions to import data from…
IMTheNachoMan
  • 5,343
  • 5
  • 40
  • 89
0
votes
1 answer

Does google API allow us to get 'Usage of 3rd party apps authenticated through Google'?

Does google API allow us to get 'List of user 3rd party apps authenticated through Google' ? I can't find any references in documentation. But, it seems like it should be in…
0
votes
1 answer

How do I manage google groups and modify user attributes without domain wide delegation?

I want to give GSAs direct access to modify Google users. I can't find current docs on this so assuming it's not possible right now? It looks like this is only possible for working with…
red888
  • 27,709
  • 55
  • 204
  • 392
0
votes
1 answer

Report on totals semails sent/received by date range

I am trying to grab a report of all users, and how many emails they sent/received. The Workspace admin reports all for a report of this on a given day, but I would want to look at the comparison of month-to-month data. Is there any easy way to grab…
CGross
  • 493
  • 1
  • 7
  • 18
0
votes
1 answer

link Azure AD users with Gsuite

Currently we have all users with their email in Gsuite. And we have these same users with Azure AD to login and use Devops, Azure and Apps How can I join these users to only use a single account? This can be done with Federation Services? Or some…
bielsa
  • 13
  • 3
0
votes
1 answer

How to Lock Google sheet at a particular time in a day

I need to lock google sheet every day at 5 PM to 6 PM to read-only mode. do we have a setting to achieve this? I saw a couple of answers in StackOverflow but most of them are to lock cells I followed the below script and created a time-driven…
Eva
  • 515
  • 4
  • 28
0
votes
1 answer

GAM Command to update Locations -> BuildingID

My GAM is running, and I can pull users info, but I cant seem to find anywhere how to set the BuildingID value in Locations. Ive tried below, but says buildingID is wrong. gam user testguy@thisplace.com update BuildingID 12345
Joe Fox
  • 17
  • 4
0
votes
0 answers

can a single OAuth 2.0 Client IDs Credential work for different Domeins in other gsuite accounts?

We have Gsuite account where we created a OAuth 2.0 Client IDs (picture below) in order to implement our client application to users for Single sing on using (Using OAuth 2.0 for Web Server Applications:…
0
votes
1 answer

Adding custom fields to google calendar

I'm trying to add custom fields to google calendar (similar to description, guests). I need the fields to have custom text like company consent which will remain the same throughout all events/meetings. Is there a way that we can add such fields? So…
0
votes
1 answer

GAM command not running as expected

I'm in the process of making changes to groups, when testing this against 1 group I can confirm this works but now I'm attempting to run this against a .csv which contains a list of all groups using the following. gam csv mygroup.csv | gam update…
Matthew
  • 1,412
  • 2
  • 20
  • 35
0
votes
1 answer

GMail API set non-primary send as signature return error 403

I'm making an application that should set the signature for every user in the domain. When I try to set the signature on primary aliases this work fine, but this solution is not working for other aliases (non-primary aliases). I use a domain wide…
0
votes
0 answers

GMail API/Google Workspace Add-on to automatically process emails with my own API

I'm wondering if I can use the GMail API, or some Google Workspace Add-On to aautomatically handle emails received by a specific address. I have my own web app API, and I'd like any email sent to a specific address to trigger an API call to my web…
0
votes
1 answer

nodemailer OAuth2 gsuite (mail@example.com) serviceClient and privateKey config

Nodemailer documentation for 2LO states you can make a config setup as such: Note I'm using a web unique address example.com which is email-hosted with gsuite: host: 'smtp.gmail.com', port: 465, secure: true, auth: { auth: 'OAuth2', user:…
Kevin Danikowski
  • 4,620
  • 6
  • 41
  • 75
0
votes
0 answers

google sheet to Calender event script not working for my client

I created a script in Google sheet to automate google calendar events from the sheet. The script works like a charm for my calendar but is not working on my client's calendar even after adding the correct calendar ID. My client is the actual owner…