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
0answers
21 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
11 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
47 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
38 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
21 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
11 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
21 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
21 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
40 views
Vlookup using Regex Extract - Google Sheets
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
25 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
41 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 ...
2
votes
1answer
143 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
180 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
161 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
27 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
0answers
307 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
5 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
25 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
1k 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
58 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
71 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
52 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
21 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?
0
votes
0answers
93 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
133 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
176 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
373 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 ...
2
votes
3answers
103 views
Copying data from one cell in another based on date
I have a spreadsheet, using google sheets, that I have formed into the follow metrics:
Column A is the dates of the month
Column B is the data
I want to be able to copy the data from Column B into ...
0
votes
0answers
25 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
0answers
1k views
YouTube “not interested” button is missing. How can this be resolved, and bring back that button?
Whenever I search for something the "not interested" button is not there to mark a video I don't want to see.
It only appears on homepage videos, but on search videos and the videos under playing ...
0
votes
1answer
39 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
259 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
210 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
22 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
191 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
1k 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
416 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 ...
0
votes
0answers
27 views
Google spreadsheet: Getting same result for both cells when dividing
I'm trying to divide two cells values in Google Spreadsheet, but it's weird because both cells are getting the same value.
The values to be are different and they are:
Session duration
=TEXT(P2/...
0
votes
1answer
16 views
Google spreadsheet data not showing properly in graphic
I'm using =CONCATENATE('90diaspessoas'!B16," ", TO_TEXT('90diaspessoas'!A16)) to join two cells data into one, then display the data on a graphic.
The following picture shows the result that I'm ...
-1
votes
1answer
33 views
Join two cells data - COCATENATE not working properly
I'm using the following formula to get the data of two cells:
=CONCATENATE(C2,"Dia",E2)
But it's not working properly. Take a look at the screenshots:
It should be returning the Traffic + Date, but ...
0
votes
0answers
15 views
Google and personal suggestions with shared IP
As I know, Google collects information about search requests, what YouTube videos are viewed, etc. to suggest the new content or reorder search results according to my interests. The question is: how ...
-3
votes
1answer
48 views
send mail from google sheet with given range content in simple html format to single email id— kindly help me
.
I have developed the sheet with some condition the email should be lite then only it will deliver to me in short period based on the technical details will take desition on my trade. I have ...
2
votes
1answer
162 views
Use non-linear color scale for conditional formatting in Google Sheets
In Google Sheets, when you use conditional formatting on a column with numeric values, is there a way to place a colored scale that is non-linear, but exponential, for example? I know you could ...
1
vote
1answer
422 views
How can I set up a “public” or a “team” folder in Google Drive (G suite)?
I'd like to have 2 types of folders:
A Public Folder, everyone in the company can see in their "Shared with me" section and edit
Few Team-specific folders, everyone in the team can see and edit (a
...
0
votes
0answers
36 views
Is it possible to set a formula in google spreadsheet with two variables?
I want to set a formula to calculate an equation like Y=X+5 where Y is an calculated constant value generated by another formula depending on X. is there any solution.
0
votes
0answers
402 views
Setting up a conditional auto responder from a gmail / google apps for business account ?
Is it possible to send a conditional auto responder from a gmail / google apps for business account ?
What i mean by a conditional auto responder is if someone email an email alias (email alias is a ...
0
votes
0answers
75 views
Unable to collect email address
The script is unable to extract emails get body /get plain body. Can any one guide?
function getEmails() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var labels = GmailApp.getUserLabels(), ...
4
votes
1answer
237 views
Odd Google Apps Script behavior
I have a Google Apps Script project that I have used for the past few months (successfully) and everything has worked just fine. A few weeks ago, I started getting the "Unable to load files" error ...
1
vote
1answer
1k views
Google drive keyboard shortcuts not working with non-US keyboard
Some important keyboard shortcuts in Google Drive and Google Docs seem not to work on a non-US keyboard, at least on Macs.
For example, I have a French keyboard and in Google Drive, hitting "/" opens ...
4
votes
2answers
1k views
Why is my G Suite Gmail favicon blue?
My G Suite Gmail favicon has turned blue. Now it looks like this:
What the color change mean? Is is part of a rebranding, or is it supposed to notify users about some special state of Gmail app?
Is ...
