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.
0
votes
1answer
28 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
25 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
33 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 ...
-1
votes
1answer
33 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
14 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
26 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
45 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 ...
0
votes
1answer
22 views
Google Sheets table of data wont create graph accurately?
So I am trying to convert some data into a scatter plot using google sheets. But 2 problems:
1) when I try and order the x and y so that the graph has x data on x and y on y it inverts it. May this ...
1
vote
0answers
14 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
19 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
19 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
18 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
15 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
233 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
69 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
19 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 ...
0
votes
0answers
49 views
Recovering my Google account with out a recovery email or phone number [duplicate]
Someone hacked my password and changed it. I have been using the same password for years and I need help getting my account back. You said you would email me back but I have not received any response ...
1
vote
1answer
122 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
28 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 ...
0
votes
0answers
20 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
64 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
34 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 ...
0
votes
1answer
223 views
Vlookup using Regex Extract
I trying to do insert an image into a cell in google sheets.
I'm using vlookup and regex extract to lookup columns to retrieve the image URL for the IMAGE function in google sheets.
However one of ...
0
votes
0answers
151 views
Removing Styles In Google Docs?
I'm working on a corporate document template and had all of my styles in perfect order until I noticed there was an extra style. I used that style to see where it came from and it added another style. ...
0
votes
2answers
73 views
Migrate from personal Google to GSuite
I’ve been using Gmail for almost 15 years, including many Google products linked to that same account.
I’ve now created a GSuite account, and I want to migrate as much as possible to that new ...
3
votes
2answers
206 views
Can you specify an accout to use with Google's “.new” doc creation URL?
I am usually logged in to multiple Google accounts, and I have been using links like these to create sheets (docs, etc.) in the respective accounts:
https://docs.google.com/spreadsheets**/u/0**/...
1
vote
1answer
395 views
Redirect link to another Google drive video
Is there a way to redirect a link to another video in Google Drive when both are made shareable?
I ask this because I have shared someone a link to an older video and I want them to access the new ...
0
votes
1answer
208 views
Adding extra but non-aliased emails within GSuite
Have setup GSuite to handle emails for a certain domain name and have also added aliases via: Google Admin -> Users -> {User} -> User Information -> Email Aliases
However, what if I want to add an ...
0
votes
0answers
38 views
How to migrate and convert an individual Google Suite email account to Office 365 Shared Mailbox?
I'm planning to migrate my company GSuite email account to Office 365. The Office 365 will have the same domain.
My Office 365 subscription is the Business Premium, so we will have shared mailbox for ...
1
vote
1answer
614 views
Google sheets, data validation - how to auto-update the options from a “list in a range”
I have a dropdown in all the cells in a column. Around 150 rows. The four options inside the dropdown come from another tab (sheet), A1 to A4.
This works fine. The options are listed from that tab, ...
0
votes
0answers
10 views
G Suite Calendar Default Working Hours
As a G Suite Administrator, is it possible for me use the G Suite Administration app to set default "working hours" for all users' calendars?
0
votes
0answers
40 views
Script to duplicate rows but continue formulas
I feel like my script is close to the goal, yet so far.
I'd like to take the current row that the user is clicked on, and then insert multiple new rows below the current row, but also continue the ...
0
votes
1answer
3k views
How do I get Gmail to wrap my paragraph text in the default HTML mode?
I've been noticing of late that when I write paragraphs that end up needing word-wrapping as Gmail will make these lines extremely long and cause horizontal scroll bars and hence make having to read ...
0
votes
0answers
80 views
Google App to add a specific forwarding address to a user's Gmail
I wish to create a Google App that will, upon approval by the user, automatically add a specific forwarding address to their Gmail.
When trying to hit the https://www.googleapis.com/gmail/v1/users/...
0
votes
1answer
72 views
Automatically switch to another Google account during work hours?
I have two Google accounts:
personal@gmail.com
business@company.com
Is it possible to automatically change between during working hours?
Example:
Monday to Friday
08:00 - 17:00 -> business@...
0
votes
2answers
2k views
Some saved places are not shown on map
I have saved Dune of Pilat to my custom list:
If I zoom out I see my other bookmark from the same list, but there is no Dune of Pilat mark on map.
Why some bookmarks are visible and some not from ...
0
votes
1answer
25 views
Grab route from other site
Is it possible somehow grab route from others maps and use in my personal map?
For example how to grab map from this ultimatedrives site?
1
vote
1answer
329 views
Default all Google Apps to English
I am currently travelling in Europe and every time I visit Google.com, or any Google Apps, like Sheets or Docs, it defaults to the region locale...
Currently, Google Sheets is showing me all menus in ...
0
votes
0answers
169 views
Google App Script - Append Table to Google Doc
I am having an issue appending a table from a google sheet into a google doc via app script.
if(rtemp == "tblhead")
{
//http://www.googleappsscript.org/home/create-table-in-google-...
0
votes
0answers
201 views
Multi-part data validation and calling formatting in google sheets
I have a couple of questions:
Is it possible to make a conditional formatting or data validation rule such that multiple data types can be input into a cell and the cell will automatically separate ...
0
votes
0answers
192 views
Changing non-primary verified google apps domain in legacy account
We have a 2007 google apps account, where we have multiple verified additional domains on this account, Verified and not Aliases.
One of these web sites is going to be renamed, is there any way i can ...
0
votes
1answer
949 views
Using Google Apps Script add-on without publishing
I've just written my first Apps Script add-on for showing some links in a sidebar of a Docs document.
It looks like the way I created it made it bound to a specific document (the one from which I ...
0
votes
0answers
34 views
How do you filter AdSense ads via Doubleclick for Publishers? (DFP)
I have an AdSense account and a Google DFP account. On my AdSense account I have a screen for filtering out categories of ads that looks like this:
Since DFP ad units have "AdSense inventory settings"...
0
votes
1answer
46 views
Locating third-party Google Docs web apps
I got an e-mail from Google today, warning me to "Remove risky access to your data". According to the security checkup, there are two third-party apps which "have extensive access to [my] personal ...
0
votes
0answers
281 views
G Suite with domain alias causes emails to be considered spam
A legacy G Suite associated to a dead domain has had a new working domain added as an alias. Although Google sets the From as the new domain, how can I stop Google setting the Envelope-from as the old ...
0
votes
1answer
321 views
Google Sheets - Fetch random value from array for each new line created with form
I have a Google Form that fills up a new line with values in Sheet1!, column A and column B.
I am trying to create an =ARRAYFORMULA function in column C, which will populate the C cell in each new ...
-1
votes
2answers
27 views
Can I move only a few accounts to google apps paid plan?
Is it possible to move a few free google accounts using a custom email (eg non gmail) to a paid google app plan whilst leaving all other accounts and emails as they are.
Here’s my scenario
I’ve ...
2
votes
1answer
202 views
Is the new Gmail interface available for all domain accounts?
My domain is on Google since ~2006, the name changed a few times (Google Apps initially, now I think this is G Suite) and I benefit from the free grandfathering program.
I wanted to try the new 2018 ...
2
votes
1answer
2k views
Users can't access Gmail Accounts in G-Suite [closed]
I am the Admin for the G-Suite Account. I am seeing the following in my admin (see below), but new users are getting "We are sorry, but you do not have access to Email. Please contact your domain ...
1
vote
1answer
551 views
Reference entire row data or row-by-value from other sheets
I've a Google Spreadsheet where my first sheet is a Products table.
The columns are SKU, Title, Price, Category, Type
I've some tasks in front of me where I need to create some bundles of different ...
