Questions tagged [google-apps]

DO NOT USE ALONE.Questions should be tagged with more specific, relevant tags whenever possible. - For questions about programmatic interactions with services via [google-apps-script] or where no appropriate API tag exists, use: [google-docs] [google-sheets] [google-drive] [google-calendar] [gmail] [google-maps] - For questions regarding API usage, use [google-sheets-api] [google-docs-api] [google-maps-api] [google-calendar-api]

Google Apps is a suite of cloud-based applications and services for communication and collaboration. Organizational domains are available for Education and Business, and this tag also encompasses use of the APIs provided for management of those domains and their users' accounts.

Usage questions about any of the web applications should be posted at Web Applications Stack Exchange instead of here.

Questions should be tagged with more specific, relevant tags whenever possible.

2168 questions
25
votes
2 answers

How can we check if our app is installed for some organizations but not all of them?

We created an application for Google Apps Marketplace. Our app works only if it's installed for everyone. But the problem is, some customers install our app for some organizations, not everyone. We want to display a specific message to those…
Uri
  • 2,992
  • 8
  • 43
  • 86
24
votes
4 answers

Google Spreadsheets Regex Case Insensitive (Regexreplace)

I'm trying to create a case insensitive regex query in Google Spreadsheets with the regexreplace function. Is that possible? I've tried the \i flag and got a #REF error saying the expression was invalid: =regexreplace("Test","t\i","") gives an error…
nate11000
  • 247
  • 1
  • 4
  • 8
23
votes
6 answers

Unable to setup DKIM TXT-Value as DNS-Record

I have a domain name which DNS is edited via Google Cloud DNS. And I have a Google Apps for Work Account with that domain name. I wanted to set up DKIM-authentication but when I try to save the corresponding TXT-Record I get the error that the Tag…
tnr23
  • 623
  • 1
  • 5
  • 13
23
votes
3 answers

What is the correct SPF record for using both Amazon SES and Google Apps

What would be the correct SPF record to use for both Amazon SES and Google Apps together: Google Apps says they want you to have the tilde "~" in it: http://support.google.com/a/bin/answer.py?hl=en&answer=178723, but most other examples have a dash…
Random5000
  • 1,562
  • 3
  • 16
  • 26
22
votes
3 answers

If var isnumber, for script

I need to run a script which contains the logic: If isNumber, Then DoSomething. I've run other such if then tests such as if blank, and if cell contains "x". It should be simple but I can't find a solution. I've tried getNumberFormat, innum,…
MinneapolisCoder9
  • 601
  • 1
  • 11
  • 29
21
votes
1 answer

LightOpenID validate() fail on Google Apps

I'm using LightOpenID to authenticate OpenID against Google Apps. I make the initial authURL() request and things are good. I call validate() and it fails. Through copious echo's, i've tracked it down to the last few lines of validate(). From…
Eric B.
  • 241
  • 1
  • 6
21
votes
3 answers

Google Apps Calendar shows "Busy" instead of sharing full, more details

We're building a multi-user platform where each registered user has a Google App account with their e-mail and calendar. People can add to the events to the calendar, but the entry always show "Busy" instead of displaying the full event…
Tomer Lichtash
  • 9,002
  • 16
  • 55
  • 71
20
votes
6 answers

Must issue a STARTTLS command first. Sending email with Java and Google Apps

I am trying to use Bill the Lizard's code to send an email using Google Apps. I am getting this error: Exception in thread "main" javax.mail.SendFailedException: Sending failed; nested exception is: javax.mail.MessagingException: 530 5.7.0…
Sergio del Amo
  • 76,835
  • 68
  • 152
  • 179
20
votes
3 answers

pre-register app on google play

I am working on a product, and have plans to launch in next 4-5 weeks, i have read so many blogs post about a new features of google play console i.e Pre-Register-App before launch.so i am also thinking to do the same, i dig google and found many…
Pankaj Arora
  • 10,224
  • 2
  • 37
  • 59
20
votes
2 answers

How to get group membership or roles from a Google Apps SAML2 Identity Provider

I did setup my Google Apps for Work Unlimited account to act as SAML2 Identity Provider and register my web application as Service Provider (as explained in the links below). It works great, I can login into my app after login into google with a…
pabloelustondo
  • 2,196
  • 3
  • 19
  • 23
19
votes
3 answers

Share a Drive document without notifying user with Google Apps Script

I am creating a workflow process in Apps Script where a Doc is generated from a template and shared with various users for approval. The Script sends a customised email notifying a user that the document requires their approval but they also receive…
18
votes
0 answers

Script to summarise data not updating

I have a Google spreadsheet of timesheet data; it has a sheet for each month, each sheet is a lot of six column blocks, one block per client. I have created a summary sheet that goes and gets the total for each clients and displays it in a…
16
votes
2 answers

Can I generate a file from Google Sheets script?

I'm using Google Sheets to prototype a bunch of numerical data for something I'm doing. Is there a way to export a subset to a text file? Effectively, what I'm aiming to do is export a file I can include directly in the build for another project.…
Charles Randall
  • 6,920
  • 12
  • 33
  • 38
16
votes
5 answers

Google App Engine and domain name

Here is the situation: I own a Google Apps for Business account. I have two domain names registered : mycompany.com which is the principal domain myapp.com which is another domain Note: both domains are validated and active. I'm working on a…
Nicolas Repiquet
  • 9,097
  • 2
  • 31
  • 53
16
votes
1 answer

Google G Suite SAML SSO domain login page

I'm usign Google G Suite and created an app which is manage users logins with G Suite SAML. (see. https://support.google.com/a/answer/6087519?hl=en&ref_topic=6304963#) Everything is works smoothly, but I have problem when users not logged in our G…