• Home
  • /Archive by category ' Google Apps Tips '

Archive For: Google Apps Tips

Real-Time Data and Teamwork with Google Sheets

Real-Time Data and Teamwork with Google Sheets

Convert your Microsoft Excel Spreadsheets to Google Sheets and experience Real-Time Data and Teamwork….in just  3 easy steps.

Google Sheets

Step 1:
In Google Drive, click the Settings icon in the top-right corner of the page and select Settings > Convert uploads.
Step 2:
Click the New button on the left of the page and select File upload, then navigate to your Excel file.
Step 3:
To start working with teammates in real time, open the file and click the Share button in the top-right corner, then invite as many people as you want to view, comment or edit.

 
How to Wrap Text in New Google Sheets

How to Wrap Text in New Google Sheets

One of the first things I noticed (and found annoying) when switching to the “New Google Spreadsheets” was the fact that my cells were spilling into adjacent cells rather than wrapping with-in the existing cell.   Word-wrap is turned off by default in New Google Sheets

It took me a few minutes to figure it out, but once I did,  it is a super easy fix.  If you do not want your cells to word-wrap in Google Sheets, simply highlight all of the cells that you do not want to wrap, and click the “wrap-text” icon.  You can toggle word-wrap off and on by highlighting cells clicking the “wrap text” “word-wrap” icon (see below.)

 

 
Setup a Ticketing System using Google Groups for Business

Setup a Ticketing System using Google Groups for Business

If your business requires a ticketing system and you are an existing Google Apps for Business or Education customer, you may not know it, but you already have one!  In addition to the email, calendar, contacts, and 30GB storage you get with your $5/user/month, you also get a flexible, robust, and reliable ticketing system.

The video below shows you how Google Groups for Business can be used as a full blown ticketing system:

GoogleGroupsCollaborativeInbox-450-92

 
How To Send Mail from Your Printer or Scanner Using Google Apps

How To Send Mail from Your Printer or Scanner Using Google Apps

Sending mail from a printer, scanner or app

You can set up your on-premises multifunction printer, scanner, fax, or application to send email through Google Apps. The three available options are: SMTP relay service, Gmail SMTP server and Restricted Gmail SMTP server.

  1. SMTP relay service – used to send mail from your organization by authenticating with the IP address(s). You can send messages to anyone inside or outside of your domain.
  2. Gmail SMTP server – requires authentication with your Gmail/Google Apps account and password. Messages can be sent to anyone inside or outside of your domain.
  3. Restricted Gmail SMTP server – does not require authentication, and you will be restricted to send messages to Gmail or Google Apps users only.

If you decide to use an SSL based solution (recommended in most cases) SSL must be enabled from the Google Apps Domain

Enable SSL in Google Apps Domain:

admin.google.com –>  Security –> Basic Settings –> Enable SSL (checked)

Enable SSL in Google Apps Domain

 

The table below will help you decide which one of these options will best meet your needs:

Option Google Apps SMTP relay (recommended) Gmail SMTP server Restricted Gmail SMTP server
FQDN of SMTP Service smtp-relay.gmail.com smtp.gmail.com aspmx.l.google.com
Configuration requirements Port 25, 465, or 587
TLS optional.
One or more static IP addresses are required.
Port 465 (SSL required)
Port 587 (TLS required)
Dynamic IPs allowed
Port 25
TLS not required
Dynamic IPs allowed
Mail can only be sent to Gmail or Google Apps users
Requires authentication IP address provides authentication. Your full Gmail or Google Apps email address required for authentication No.
Bypasses anti-spam No. Suspicious emails may be filtered. No. Suspicious emails may be filtered. No. Suspicious emails may be filtered.
Sending Limits Limits for registered Google Apps users. 
A registered user cannot relay messages to more than 2,000 recipients per day.
For full SMTP relay limits please see Sending limits for the SMTP relay service.
2000 Messages per day. SeeSending limits for more detailed information. Per user receiving limits will apply.

You can use the SMTP relay service in the Google Admin console to relay mail from your device or application. This is possible once you add your network IP range to the SMTP relay service. You will need to configure your device to connect to smtp-relay.gmail.com on ports 25 or 465, 587. For more details about using this setting, see SMTP relay service setting.

Gmail SMTP Server could also be used to relay messages from your device or application. You can connect to Gmail mail servers using SMTP, SSL/TLS. If you connect using SMTP, you can only send mail to Gmail or Google Apps users; if you connect using SSL/TLS, you can send mail to anyone.

If your device or application supports SSL – connect to smtp.gmail.com on port 465.

To connect with SSL, you need to provide a Google username and password for authentication. Ensure that the username you use has cleared the CAPTCHA word verification test that appears when the user first logs in. We also recommend ensuring that the account has a secure password.

If your device or application does not support SSL – connect to aspmx.l.google.com on port 25.

You must configure an SPF record for your domain with the IP address of the device or application to ensure that recipients do not reject mail sent from it. You must also add this IP address to the Email Whitelist box in your Google Admin console. For example, if your sending device sends from 123.45.67.89, add that address to your SPF record without removing the Google Apps mail servers from the record: v=spf1 ip4:123.45.67.89 include:_spf.google.com ~all

v=spf1 ip4:123.45.67.89 include:_spf.google.com ~all

 
How To Disable New Tab History Icons in Google Chrome

How To Disable New Tab History Icons in Google Chrome

If you have recently upgraded to the latest version of Google Chrome, like it or not, thumbnails of your browsing history are now showing up when you launch a new tab.  There are several situations where this configuration may not be ideal….

Luckily you can turn off the Google Chrome browser history thumbnails in new tabs as follows:

Launch Google Chrome and type the following in your browser:

chrome://flags

Scroll down until you find “Enable Instant Extended API” and  DISABLE

Relaunch Chrome with the button on the bottom left of the page

ChromeFixedNewTab

 
HowTo Sync Your Gmail Contacts to your iPhone

HowTo Sync Your Gmail Contacts to your iPhone

If you are using a free @gmail.com account and want to sync you Gmail contacts to your IOS device, just follow the instructions below: (note, if you are using a Google Apps for Business or Education account, you should use  Google Sync instead):

GoogleContacts-IOS.jpg-1

From your IOS Device

  1. Open the Settings application on your device.
  2. Select Mail, Contacts, Calendars.
  3. Select Add Account…
  4. Select Other
  5. Select Add CardDAV Account
  6. Fill out your account information in the following fields:
    • Server: Enter “google.com”
    • User Name: Enter your full Google Account or Google Apps email address.
    • Password: Your Google Account or Google Apps password. (If you’ve enabled 2 Step verification, you’ll need to generate and enter an application specific password.)
    • Description: Enter a description of the account (e.g. Personal Contacts).
  7. Select Next at the top of your screen.
  8. Make sure that the “Contacts” option is turned to ON.

After you've completed setup, open the Contacts app on your device, and syncing will automatically begin.

Setting Google contacts as your default account

If you have set up iCloud, are syncing contacts from another account, or already have contacts stored on the device, you will need to select a Default Account.

Set your default account

  1. Open the Settings application on your device.
  2. Select Mail, Contacts, Calendars and scroll down to the Contacts section. You will only see the Default Account option if you are syncing more than one account.
  3. Select Default Account.
  4. Select your Google contacts account. Your account will be labeled with the description you gave it in the Description field.

New and existing contacts

New contacts created directly on your iOS device will be added to your default account.

Existing contacts should be imported into Google contacts. If your contacts are stored on an Apple device, you cantransfer your contacts using vCard files. If your contacts are stored with another provider, first export your contacts and then import your contacts into Gmail.

Troubleshooting steps

If you have any problems, please try these things first:

  1. Open the CardDAV account you established at Settings > Mail, Contacts, Calendars under Accounts. Make sure that the Account option is turned to ON.
  2. If the Account is ON, then open Advanced Settings below and make sure Use SSL is turned to ON.
  3. If you have changed anything, please click Done and the top right of the screen showing your account settings to save those changes.
  4. If you’re still experiencing issues syncing your contacts using CardDAV, please login to your Google account on the web. You might be prompted to acknowledge an “Unusual sign-in location”.
 
HowTo Enable Google+ Hangouts on your Google Apps Domain

HowTo Enable Google+ Hangouts on your Google Apps Domain

(If you have not already done so, you will need to enable Google+ for your Google Apps Domain.)

 

1)  Open Google Chrome, navigate, and login to:

admin.google.com

 

2)Click “Google Apps”

  •  

3)  Click on the Google “Talk” Service

4) GoTo Google Talk Advanced Settings

5)  Click the “Enable the new Hangouts for users in this organization”

(you will be prompted to review and accept the considerations in enabling Google Hangouts for your domain.)

 

You now have Google Hangouts enabled for your Google Apps Domain!

(Also see howto  enable Google+ for your Google Apps Domain.)

Google Apps +Hangouts Domain Considerations

  • Domain warnings and restrictions – Hangouts does not support warnings outside of your domain and does not support restricting chat with users outside of your domain.
  • Chat history – Administrators can no longer disable chat history for all users. Chat history is stored automatically in Gmail for each chat unless all participants agree to disable it.
  • Contact sharing – Hangouts does not autocomplete from the Global Address List.
  • Google+ – Some features, such as multi-person video calls and photo sharing in Hangouts, require a Google+ profile.
  • Google Apps Vault – Hangouts is not compatible with Google Apps Vault, and you should not enable Hangouts at this time if you intend to purchase Vault.
  • Support – While in preview, the new Hangouts is not covered according to the terms outlined in theTechnical Support Service Guidelines.
  • Reverting to Talk – You can revert your users back to the Google Talk version of chat within their Gmail by disabling the new Hangouts for this organizational unit (from within Talk settings). Note: Conversations and history created while using Hangouts will still remain after reverting.