Questions tagged [google-apps]
For questions about specific features of Google web applications for Google Apps accounts. G Suite (aka Google Suite) is the new name for Google Apps. It is a suite of products for business clients of Google. Do not use this tag for general Google applications.
821
questions
0
votes
0answers
15 views
Google calendar receive email invitation to your own event
I've been asked to write an application and one of the features is to allow users to add events to their Google calendar. They (calendar owner) have also asked to be able to get an email invitation to ...
0
votes
0answers
11 views
Google Sheets - Recognising sequences
I have a spreadsheet with a list of files and the majority of it is an image sequence, for example:
ImageTest_0001
ImageTest_0002
ImageTest_0003
...
ImageTest_0385
ImageTest_0386
ImageTest_0387
Is ...
0
votes
1answer
30 views
How do I report a scam on Hangouts?
A so-called Army orthopedic physician scammed me out of a large sum of money on Hangouts. His original email was usarmydavid1234@gmail.com. He said he needed help sending his consignment box from ...
1
vote
1answer
15 views
What does .activate do in google scripts?
sheetFunction {
var sourceFile = SpreadsheetApp.openById("1asdasdasdasdasd");
// Set sheet
var masterSheet = sourceFile.getSheetByName("Master");
masterSheet.activate
}
cellFunction {
...
0
votes
0answers
15 views
G-suite to Salesforce Attribute mapping
I’m running into an issue while mapping attributes from G-suite to Salesforce.
I’ve setup the following environment:
G-suite for Business &
Salesforce lightning sandbox
SSO (SAML2.0) is setup ...
0
votes
0answers
36 views
Auto-create new Sheets with specific data, copy rows and conditional formatting
I did find few scripts about how to make Google Forms result sheets to auto-create new sheets by a specific data in a cell. I did not manage to get the scripts to work - and I was wondering if ...
0
votes
1answer
28 views
Where can users in my domain find published Google Sites?
I created a Google site using the new Google sites. This site was then published with the setting "Published - Anyone at [organization] can find and view" selected. However, users who are not editors ...
1
vote
0answers
48 views
Forward a suspended Google account's mail
In my organization, I've suspended 2 users who have quit.
I'm trying to accomplish 3 things:
Block them from logging in
Retain a copy of all of their old emails, in case anything critical is needed
...
1
vote
1answer
141 views
How to change the default Google account for Google webpages on Chrome?
So I have a Google account signed into Chrome through which I keep bookmarks, etc. However, I use a different (work) account for most of my calendar needs. How can I make it so that when I go to ...
0
votes
1answer
34 views
Reverse Shortened URL to Get the Original URL Before the Shortening in Google Sheets
I have a sheet where I collect tweets with links based on a search query. Twitter, however, is handing me for each tweet their short URL format (t.co) rather than the original URL that was shared.
Is ...
-1
votes
2answers
31 views
Linkable preview of Google Docs (Sheets, Slides, etc.)?
Is there a way to get a live preview image (an image, similar to the content of the document that updates without manual intervention) of a Google Sheet (or other apps in the Google suite) to link to ...
0
votes
0answers
21 views
How can I get the Google Drive webapp/window to open documents in their own separate webapp/window?
In chrome://apps/, all my webapps are set to "open as a window". I have also created shortcuts for them.
I basically want Google Docs, Sheets and Slides to open in their respective app when I double ...
3
votes
1answer
927 views
Parse JSON from Google Spreadsheet Cell
I am working on an API with google spreadsheet and app script to retrieve JSON response; I am using ImportJSON function (custom function by Brad Jasper and Trevor Lohrbeer) to retrieve and parse JSON ...
0
votes
0answers
24 views
How can I get multiple choice question id form Google Form
I want to pass Google Form value to my HTML form. In my HTML form I created multiple choices questions as well as I created the same question in the Google Form now I want to pass those input values ...
0
votes
0answers
8 views
Google/Apple Calendar
Is it possible to remove/hide a calendar without completing deleting it and losing it forever? I just don't want some calendars to show up on the sidebar anymore, but I don't want to lose them forever....
1
vote
0answers
47 views
How to get a cc or bcc copy automatically to my admin account when any of the user accounts receives a mail?
I need to monitor all the users emails under my domain, so when any of the user in my domain receives a mail from others, my email (admin@abc.com) should get a bcc automatically...
i.e. if any ...
0
votes
1answer
28 views
Google shows results and values in mixed languages
I am using English language in Chrome and have this language set as default for most of the sites, but since I am from Poland I have forced (in Google Account settings) to have all the search results ...
1
vote
1answer
65 views
Trying to use Google Sheets importHTML() to import a table. But no content appears
I'm attempting to load the following website into Google Sheets:
https://www.lasvegasadvisor.com/vegas-lines/?sport=ncaafb&period=0
Can anyone help provide a formula that would work in google ...
0
votes
0answers
137 views
Change Google 2FA app from Gmail to another on iOS?
When logging into a Google service on the web with 2FA enabled, Google will prompt you to go to the Gmail app on the iPhone to confirm the login.
If you delete the Gmail app, it will still prompt you ...
0
votes
0answers
70 views
SSO via SAML GSuite to DocuSign - Unable to Restrict Access
I am setting up SSO via SAML GSuite to DocuSign and am having trouble limiting user account creation to the users in a group. I have successfully tested user provisioning and users within my domain ...
0
votes
1answer
119 views
Google sports widget: displaying women schedule by default
When searching for a sporting event on Google, say Wimbledon, Google displays the schedule of the upcoming games.
I've noticed that, by default, Google displays the women's singles schedule (second ...
0
votes
1answer
758 views
App Script to move a row of data from one Google sheet to a different one (different sheet id's) based on a cell entry
I'm currently trying to adjust a script I found that copies the contents of a row from one tab of a google sheet, pastes it into the next descending empty row in a different tab and then deletes the ...
1
vote
1answer
18 views
How can I add details to goals in Google Calendar?
I have been using goals in Google Calendar for quite sometime now. They are very handy and easy to use. Just create a goal you want to accomplish, set preferred time and frequency and you are all set. ...
1
vote
1answer
61 views
Any way to stop the “outside of your domain” notifications across Google Apps?
I use a GSuite account as my primary Google account for everything and across calendar / hangouts / etc, I see a "outside of your domain" notification for a lot of random things. Sometimes it's just a ...
0
votes
0answers
153 views
Can my employer access my device's hardware info or control it in any manner even after I unregister? (On the Google apps/ business platform)
I added a new Google account on my device and signed in with my work account. It said that my device info like IMEI number, Mac address etc will be shared and the admins will also be able to control ...
1
vote
1answer
455 views
All Google Docs URL parameters/functions/commands?
Where is the official documentation for the URL parameters/arguments?
There are things like /preview, /copy, /export, #headings, ?something question mark, that I stumbled on tips and tricks articles ...
1
vote
1answer
300 views
Copy Contents of Cell When Checkbox is Checked - Google Scripts
Preamble: never used javascript before, but trying to learn through google sheets since I work with tons of data.
Hello, I'm attempting to write a google script that will take the contents of a cell ...
3
votes
1answer
79 views
How can I hide a paragraph of information in Google Docs?
I want to hide a blob of information or a paragraph.
I identified two ways to try this neither of which worked.
One was to store it in a comment which takes it outside the page but I can't use ...
0
votes
1answer
113 views
Get Google Backup and Sync to only sync one file at a time instead of three?
I have Google Backup and Sync set to upload all files in a folder to Google Drive. The default behavior seems to sync 3 files simultaneously. Is there any way to set it to sync only one file at a time?...
0
votes
0answers
26 views
Connect Firebase to MySQL
how do I connect my Firebase Cloud to MySQL? MySQL is from my wordpress website and I need to connect that to Firebase Cloud, which is where I have my mobile app.
0
votes
1answer
40 views
How to automatically add new row in Google Spreadsheets
I want to automatically add row in Google Spreadsheets when I type information in row 5 by Google script.
]1
1
vote
1answer
59 views
How to save Gmail emoticons/emojis to use on other apps
I like Gmail style/design of emoticons/emojis:
How can I save them as PNG/JPEG to be imported on other applications like Slack? Slack allows importing emojis as PNG/JPEG files.
Ideally, is there any ...
0
votes
0answers
49 views
Not receiving emails in Google Apps MX records are correct
I am not sure what to do to troubleshoot further:
I did recently move my domain to CloudFlare (but I have always used CF DNS) but I did that on March 8th and my last email was April 9th.
I have ...
0
votes
1answer
235 views
Google Sheets Two-Way Databinding?
I want to make a spreadsheet in Google Sheets with a user friendly editable front end and a back end with an arbitrary number of rows containing the data to be displayed. There should be a dropdown on ...
0
votes
0answers
16 views
In GSUITE, how can I detect a user sending multiple emails to the same recipient to detect data exfiltration?
I've had a number of instances where departing sales professionals have sent themselves emails with client data. I have blocked the sending of archive attachments, but some people will send multiple ...
0
votes
1answer
315 views
In Google Sheets how can I view which cells are protected?
In my Google Sheets spreadsheet I set the Protection for some of the cells so that "Only You" can edit (only myself can edit, but the dialog text reads "only you"). Other cells do not have any ...
1
vote
1answer
533 views
How to set default Google Sheets and Google Docs account?
I have two Google accounts that I always sign into, one of them is my personal account and the other belongs to the company I work for.
I created a desktop shortcut for both of these apps from chrome ...
1
vote
0answers
16 views
Making a group email list for multiple org members to get emails from external sources?
In the past it was pretty straight forward to make a group with proper permissions without worry in Google Apps' Groups Admin function. I frequently used it to create a recipient group for services ...
0
votes
0answers
71 views
How can I prevent users from “resolving” comments in Google apps?
I would like to give users the chance to comment on a Google doc but not to resolve comments I or other editors made on it. But if I invite a user in "comment" mode it seems they can resolve comments ...
0
votes
1answer
70 views
How do I give write only access to a Google TeamDrive subfolder
I setup a TeamDrive with sub-folders (handins and handouts). I want people to be able to write to the handins folder but not view, and view and edit in the handouts folder.
0
votes
0answers
26 views
unique numbers based on respondent's answers
I am managing a group of participants (example: doctors, nurses,etc) in filling the form, each participant chooses an option according to his goup (doctor, nurse, etc) i want different sets of unique ...
0
votes
0answers
23 views
Is it possible for a Google App Script to convert a file in the cloud?
Is it possible for a Google App Script to take a file from Google Drive, such as a PDF, video, image or .rar file, perform a conversion to it, to convert it to another format, then upload the ...
0
votes
0answers
546 views
Upload from URL (on Google Sheet) to directly in Google Drive
I have a google sheet on which links are generating (by calculation) for downloading / uploading in G-Drive.
I want when links are generated, I can upload file (from generated link) to directly in my ...
0
votes
1answer
275 views
Translate UrlFetchApp Response HTML To Google Sheet
I'm new to working with APIs/CURL and trying to figure out how to get a response (not response code) into a sheet. Here's my code:
function myFunction() {
var url = "https://platform.quip.com/1/...
0
votes
1answer
30 views
Unable to share YouTube videos to groups of users
We have a Google G Suite Basic account (company). I would like to share some videos to a group of users (a subset of domain accounts). Although I can share with individual users, there seems to be no ...
1
vote
1answer
572 views
Is it possible to set an account wide auto responder in Google Apps for Business (G Suite) Gmail?
Is it possible to set a company wide auto responder in Google apps for business Gmail?
For instance if the office is closed for a set date range I would like to set an auto responder for all emails, ...
0
votes
0answers
38 views
How to manually nest block quotes in Gmail in single consolidated reply to multiple different-subject emails, as if emails were part of same thread?
Someone emailed me multiple times using different subjects. In chronological order, let's refer to them as Email1, Email2, and Email3. If I reply to Email3, Gmail will automatically put Email3's body ...
1
vote
0answers
27 views
In Google Docs, how do I make every paragraph have its own #heading tag in its URL without using a Style?
I have some documents in which every paragraph has its own #heading URL tag, even if it is Normal Text (no Style applied), and it helps a lot to externally refer to a specific part of the document, ...
-1
votes
1answer
141 views
Google Script Editor apply to all sheets except 1st, 2nd and 3rd sheet [duplicate]
Currently this code is only applied to the sheet called "Name" I wanted applied to all except for 3 sheets (Template,Summary and Count):
function EqualValue() {
var ss = SpreadsheetApp....
0
votes
0answers
54 views
My Chrome account isn't my primary email
I've been using Chrome synced with my personal email for some time. All of my Chrome settings, bookmarks, history, etc. are on there. In practice I use my school email a lot more often (I use my ...
