Google Apps

Google Apps is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Apps for Work adds business-specific features such as custom email addresses at your domain and storage for documents and email.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have a simple website, and because it's not a Business Plan (nor a self-hosted Wordpress), it doesn't have much in the way of plugins. I have a form on the website, which is currently set up to send an email every time someone submits a form (to a Gmail account). The email has a consistent structure.

What is the best way to get this form data into Google Sheets? I'd like every form submission (previous and future) to have its own line in my Google Sheet.

I've been looking at scripts, where Gmail labels the email, and then the label is used to extract the relevant data from the email and place it in the relevant field in the Sheet - but it is beyond me to write one myself, and I was hoping there would be an easier way.  I've also had a look at IFTTT but I can't one that does what I need.

Any ideas?
Free Tool: Subnet Calculator
LVL 12
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

My end goal is to have a custom menu in GSuite that will allow me to merge a Google Doc to a predefined PDF Letterhead where page one gets the letterhead and subsequent pages do not.

For this question, I will be happy with the Google Apps Script to merge the text to a letterhead pdf where I can adjust margins (in the script) for different pdf's. Or at least point me to the right beginnings of code.
I have a Samsung Galaxy S7 and I use Android Auto to connect to my car.  I recently lost the ability to use the voice command "Ok Google". I can still prompt it if I touch the mic on my car dashboard and then voice command whatever I want it to do..

Note: That this has worked before with my current set up. It may of stopped working after a recent phone update, but I can't be sure.

My settings in Android Auto are on to allow voice command. Are there any other settings that might be causing this?

What's the best way to troubleshoot?
Gmail by Google
Read this tutorial to learn how to fix repeating password error prompts when setting up Gmail IMAP with Microsoft Outlook. The entire process is described with step by step, illustrated instructions. Enjoy...
[Webinar] Optimize Retail & On-Demand Customer Experiences With Google Maps APIs
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment.

Powered by the world's most widely used and innovative mapping technologies and locations services, your business can quickly integrate and deploy an advanced location strategy, using:
  • Dynamic and interactive store locators to engage customers
  • Places and Autocomplete to streamline user interaction, standardize data, and minimize errors
  • Multi-point route optimization, estimated travel times, and asset tracking for on-demand and delivery services

For more information on how to build and deploy an effective location strategy, check out this webinar.
Someone has shared a Google Drive folder with me. They keep adding files to that folder. However, they may also delete files from that folder.
Is it possible to set something up to synchronise the files from Google Drive to a folder on my PC? If files are deleted from the Google Drive shared folder, I do not want them to be deleted from my PC.

Thank you
I am unable to login to Google's Drive File Stream.  When I login it gives a generic error that states "Can't reach Google Drive" and a notification pops up in the bottom corner stating that it encountered an error and had to close.  Looking over the event viewer I see the attached log recorded every time I have tried to login.  The computer is running Windows 10 Pro with Windows Defender as the anti-virus and the we use Google Apps.  This is a new computer and Google File Stream or Drive has never logged in successfully.  Any suggestions?
Hi, our company uses google Gmail app, I need to increase the inbox capacity only for 1 gmail user. I"m having a hard time with the instructions i've seen online. If you can point me in the right direction it'd be greatly appreciated.

A Mac OS X user was running an older version of Google Drive on her Mac to connect to a corporate Google Drive structure where our organization stores files within the Google cloud.

A week ago she received a prompt to upgrade to Google File Stream and proceeded to perform the upgrade.

She then uninstalled Google Drive.

Now her computer has been having persistent issues updating existing files and downloading new files.

When we open Google File Stream it always says that it is running and syncing. Also her computer constantly maintains a connection to the internet.

She is able to fix the issue by rebooting her Mac and then it will sync the latest changes and download the newest files. However, she has to reboot her computer several times a day.

What can be done to fix this issue?
What is the definitive date for Google Drive “going away”?

I’ve seen March 12, 2018 in online blogs but May 12, 2018 from Google itself,

I’m inclined to believe Google but wonder why the bloggers / online journalists (including CNET) were reporting March as recently as December. Have the reporters issued update reports on this? Maybe I’ve missed them.

I would appreciate any corroboration stories from the media as the clients I serve would like to see a news story on this as well as some Google statement buried on a support page.
Train for your Pen Testing Engineer Certification
LVL 12
Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

I have already setup my extended oauth2 connection and I can do an impersonation of anyone in my org.

I can successfully, say, do a


and get a good response.

What I can't figure out is what calls to use in order to set “Share this calendar with everyone in the organization” and Set to “See only free/busy (hide details)”

Thank you in advance for any assistance!
The user has tens of thousands of past gmail messages.  They appear to be in "All Mail" folder in gmail.    Gmail will delete about 100 at a time.

Is there a way to delete a larger amount?

The  Mail  Application on the Mac keeps trying to synchronize them, which slows down the computer.

We have user that has Google Apps Sync in Outlook. His mailbox over 50GB. Causing performance issue with Outlook. He wants to be able to search for all emails in Outlook, so they need to be locally on computer. He does not want to use Google apps website. I am thinking about archiving feature in Outlook. Not sure that work with Google Apps sync.

I have a Google map API 3 which works in Chrome and Firefox but displays a blank white page in Internet Explorer 11. It is a copy of the  Google Maps Api Example called Simple Store Locator App

The example has 3 files.

1) index.html
2) app.js
3) stores.json

Which I have attached to this question.

After a lot of head scratching and trying to work out what was wrong with my code I went back to the example given by Google to rule out anything I had done. The only thing I have changed in the files is my API Key.

The errors that the IE11 console are giving are as follows:

HTML1527: DOCTYPE expected. Consider adding a valid HTML5 doctype: "<!DOCTYPE html>".
Google-original (16,1)
HTML1503: Unexpected start tag.
Google-original (23,1)
SCRIPT1002: Syntax error
app.js (116,64)
SCRIPT5022: InvalidValueError: initMap is not a function
js (100,96)

Hi, we have a  lot of projects where we collaborate via email with multiple internal and external staff via email. We use Business gmail.

For others who may be involved after the project is complete,is there a way we can archive those emails per the project to a server so they can have access to everything?
Users within my organization who use our corporate Google Drive have been getting the message shown in the screenshot "Google Drive for Mac/PC is going away soon. We recommend installing Drive File Stream to continue syncing."

We are wondering exactly how much longer it will be until Google Drive will be going away permanently.

Has Google published any information as to when this might be?

Google Drive is Going Away Soon

I'm relatively new to Google Hangouts and Google Docs, but I am enjoying the features.

One problem I'm having is that random people seem to try and start conversations with me. I get emails such as;

Hangouts Emailsweet girl started a conversation with you View Conversation: 
This notification was sent to Don't want to  
receive Google Hangouts notifications? Change which emails Google Hangouts  
sends to you: 
To stop receiving Google Hangouts notifications from someone, open their  
Google+ profile and click Mute. Google LLC, 1600 Amphitheatre Pkwy,  
Mountain View, CA 94043 USA

I know I can simply unsubscribe from notifications, but I don't want to do that because I do want notifications when my approved contacts in Hangout try to contact me. I could also easily flag these for automatic delete in Mailwasher, but I'd like to avoid doing that as well.

I've looked at Hangouts Settings, but can't see what I would need to change in order to stop people I haven't approved trying to contact me.

Is there a setting in Hangouts Settings I could set that I'm unaware of so that only my approved contacts can contact me?

Thanks for any help...
Is there any way of exporting corporate Gmail email accounts to .PST files without having to setup the account with Outlook first and then exporting the email accout to a .PST file?

I need to export an entire organization's corporate Gmail accounts to .PST files and am looking for the easiest ways of doing this.
What is Gantt Chart & How to use it?
Free Tool: Port Scanner
LVL 12
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

It's my understanding that with the basic Google Apps GSuite setup you cannot delegate mailboxes to another user as an administrator as you can in 365. You have to know the users login information and then login to their account, open settings and delegate the mailbox. Is there any way to get this setup so I can delegate mailboxes without having to log into that users account? We used to have a third party service that allowed this and other features; however, the price was too much to justify what we utilized it for.

I have a very strange problem with Office 365 and G suite.
Our company has registret our domain at Google Apps for Business, also known as G suite. This is where all our employee has there email hosted.
We have Office365, a mix of pro and enterprise. Theese are only for the Office apps.

I have set up a service user with a Exchange Online plan 1 license. Everything works fine, but for some reason i cant send email to everyone in our organiztion. Some recieve the emails just fine, but alot of them bounced with a "The recipient cannot be forund on"

I have tried sending to a few personal email and theese is recieved just fine.

Any thoughts?

Kind regards Lars
I need a solution to add a local json file to the body of an html page, to display data from said file in a Google map window.  So far, all attempts to display data from an external source have failed.  Below, is the code I am using.

<!DOCTYPE html>
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="viewport" content="initial-scale=1.0, user-scalable=no">
	<title>Info windows</title>
	<style type="text/css">/* Always set the map height explicitly to define the size of the div
       * element that contains the map. */
      #map {
        height: 100%;
      /* Optional: Makes the sample page fill the window. */
      html, body {
        height: 100%;
        margin: 0;
        padding: 0;
<div id="map"></div>

      // This example displays a marker at the center of Australia.
      // When the user clicks the marker, an info window opens.

      function initMap() {
        var hc = {lat: 40.4512, lng: -85.3700};
        var map = new google.maps.Map(document.getElementById('map'), {
          zoom: 4,
          center: hc

obj = { "table":"customers", "limit":20 };
dbParam = JSON.stringify(obj);
xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
    if (this.readyState == 4 && this.status == 200) {
        myObj = JSON.parse(this.responseText);
        txt += "<table border='1'>"
        for (x in myObj) {
            txt += "<tr><td>" + 

Open in new window

Is there any way of setting corporate Google Drive data to read-only?

Once we migrate the data from our corporate Google Drive folder we would like to set this data as read-only so that the data will remain in Google Drive but will not be able to be modified.

Is there any way of doing this?
Client is using Gmail for their e-mail and has recovery e-mail setup with their personal e-mail.  They cannot remember the password, and no longer have the cell phone # they had at the time of sign-up.  Going through recovery, they know exactly what day they created the account, and the e-mail recovery sends them a code which they verify.  Then it claims the account could not verify ownership and try another method.  Phone attempts direct them to the  This looks different but gives the same result.  Is there any hope for them?
I realize that this might be a long shot considering how limited Google sheets seems to be but let's see if there are any Google sheets gurus on EE. :)

I have a sheet that is importing selected cells from another sheet that is populated by a Google Form, using the following formula:
=IMPORTRANGE("","Form Responses 1!A2:A200")

But this column contains more than one answer, separated by a comma. It may appear like this: "3, N/A" or "5, Live" or "3, 4, Self"
However, I only wish to display the text and not the number values. Is there a way to filter and display only the three possible text results?

Thank you

Google Apps

Google Apps is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Apps for Work adds business-specific features such as custom email addresses at your domain and storage for documents and email.