7 Bonus Applications That Are Included With G Suite

G Suite Bonus ApplicationsThe core applications of office productivity suites such as G Suite are: email, documents, spreadsheets and presentations. These are the basic software tools most people use at work.

In addition to these core applications, there are a number of G Suite extras that are included in the monthly per user price. Not everyone is aware of these bonus applications.

Read more7 Bonus Applications That Are Included With G Suite

How To Set Up Salesforce Files Connect for Google Drive

Google Drive Files on Lightning Page ComponentSalesforce Files Connect for Google Drive allows specified users to add Google Drive files to the Files section or a Lightning Page component of any record.

The Salesforce Files tab will show Google Drive as a Connected Source. A custom tab called Google Drive can be created. This tab can have list views like any other tab.

Setting up Files Connect for Google Drive requires administrative access to both Salesforce and the Google Cloud Platform console (the same admin login as G Suite).

It’s best that the same username is used for logging into both. This may mean temporarily making a G Suite admin a Salesforce System Administrator or visa versa.

While the following may seem like a lot of steps, the ability to set up secure server-to-server integration in about 30 minutes represents a tiny sliver of time compared to setting up other types of system integrations.

If your organization is not yet using G Suite, you can try this setup yourself with a free trial of G Suite.

Read moreHow To Set Up Salesforce Files Connect for Google Drive

Five G Suite to Salesforce Integrations and How They Benefit Businesses

At Salesforce’s annual Dreamforce conference in 2017, a strategic partnership with Google was announced.

Often, these alliances come and go. However, the Salesforce/Google partnership has gained momentum. Google had a noticeable presence at the 2018 Dreamforce conference.

Google Booth at Dreamforce 2018

Among a wide range of facets to the partnership are the following five Salesforce to G Suite integrations.

Read moreFive G Suite to Salesforce Integrations and How They Benefit Businesses

How To Find a G Suite Partner To Help With Your Implementation

Find G Suite PartnerMany small businesses do not have the in-house resources needed to fully implement and properly manage G Suite. These companies often seek help from a G Suite Partner.

There are a lot of companies that advertise G Suite services, but not are all official Google partners.

In 2017, Google launched its Cloud Partner directory, which is a searchable listing of all companies that have been accepted into the Google Cloud Partner Program.

Read moreHow To Find a G Suite Partner To Help With Your Implementation

6 Business Data Sources To Feed Into Google Sheets

There are a variety of add-ons and built-in functions for seamlessly and automatically pulling business data into Google Sheets from external sources.

Once business data is in Sheets, it can be manipulated an analyzed in a number of ways.

Here are six functions and add-ons for importing information into Google Sheets. All six are free of charge.

Read more6 Business Data Sources To Feed Into Google Sheets

How Admins & Users Can Make G Suite Security Even Stronger

Updated: December 12, 2018

G Suite Security KeyIf you’re using G Suite or considering G Suite for your organization, there may be questions about G Suite security in your mind.

After all company email and business documents (if you are leveraging Google Drive for cloud backup of local files) are stored in Google’s data centers.

G Suite, as you’d expect, has multiple levels of built-in security.

Read moreHow Admins & Users Can Make G Suite Security Even Stronger

Gmail Offline For Business and Consumer Users

Google has introduced native Gmail Offline for business (G Suite) and consumer users of Gmail.

This means that Gmail users can now read, reply to and compose emails while not connected to the internet. What’s more, no Chrome extension is needed.

It also means that people who current use a local email client in conjunction with G Suite, mainly for offline access, may find that the local client is no longer needed.

Read moreGmail Offline For Business and Consumer Users

G Suite vs Office 365: What’s Best For Your Company?

Updated: July 31, 2018

G Suite vs Office 365G Suite and Microsoft Office 365 are the two most popular cloud-based suites of business productivity applications on the market. Among the best known applications within these suites are email, calendar, documents, spreadsheets, presentations and online storage.

Google and Microsoft continue to add their own flavors of additional components to their respective suites. For example, G Suite includes Forms, Drawings and My Maps and new Google Sites. Google Jamboard is a paid extra. Included extras at no additional charge are Hangouts Chat and Hangouts Meet.

Microsoft Office 365 plans variously include Sway, Yammer, Skype for Business, Office 365 Video and Microsoft Teams.

Read moreG Suite vs Office 365: What’s Best For Your Company?

Google Hangouts Meet vs GoToMeeting

Updated: November 30, 2018

Hangouts Meet vs GoToMeetingIn March 2017, Google introduced a new online meeting experience called Hangouts Meet.

This capability is a major differentiator between consumer Gmail and business G Suite.

Almost all the component functionality (Docs, Sheets, Slides, Maps) that is available to a G Suite user is also available to a consumer Gmail user.

However, a Hangouts Meet meeting can only be initiated by someone who is part of an organization that is using G Suite and for which the Meet capability has been enabled for the G Suite organization.

Read moreGoogle Hangouts Meet vs GoToMeeting

How To Move Data Between Google Sheets and Excel

Google Excel Spreadsheet InterchangeLet’s begin with a distinction between Google Sheets & Excel:

Excel is a spreadsheet application that is a part of Microsoft Office 365.

Google Sheets a spreadsheet app that is available with free consumer Gmail and also with G Suite (GMail for organizations).

Some people use only one or the other. Other people use both.

If a Google user who does not have Excel installed receives an Excel spreadsheet via email, the user can preview the spreadsheet within Gmail and then convert the spreadsheet to Google Sheets.

There are several ways to move spreadsheets and spreadsheet data between Google Sheets and Microsoft Excel. Here are examples of Google Excel information exchange.

Read moreHow To Move Data Between Google Sheets and Excel

25 Ways G Suite Can Increase Business Productivity

Accelerate Business With G SuiteThere are many aspects to G Suite that can add energy to a business. Most of them are not available with standard web host email. Some are available with consumer Gmail.

Through continuous improvement, Google regularly adds new productivity features and functionality to G Suite.

Unless noted, all of the functionality below is included with G Suite at no extra cost. Google packs a lot of business value into G Suite beyond email, documents, spreadsheets and presentations. Here are 25 ways your business can use G Suite to increase productivity.

Read more25 Ways G Suite Can Increase Business Productivity

Hangouts Chat vs Hangouts Meet vs Classic Hangouts

Updated: December 6, 2018

Google Chat AppsIt’s a bit difficult to keep with Google’s various iterations of chat and Hangouts products.

However, Google has been honing its strategy and has come up with two well-thought-out business productivity offerings that complement G Suite’s core offerings.

Here is a roundup of the current Google Hangouts and Chat products, including the newest kid on the block.

Read moreHangouts Chat vs Hangouts Meet vs Classic Hangouts

Where is G Suite Data Stored?

G Suite Data StorageGmail and G Suite use the same global data storage as Google’s search engine.

Google currently has 15 data global data centers. The first data center was built on the Oregon side of the Columbia River in 2006.

Google stores subscriber data (email, documents, spreadsheets, etc.) in small pieces. Each of those pieces is copied several times and stored in multiple geographic locations.

Read moreWhere is G Suite Data Stored?

G Suite Enterprise Adoption: Slow But Sure Progress

G Suite Enterprise Adoption

Updated: August 27, 2018

Google has made significant inroads into the small business market with G Suite. For business owners and employees who have been using consumer Gmail, moving to G Suite is an easy transition.

However, Google has faced several barriers to widespread G Suite enterprise adoption. Here are some of those blockers and what Google has been doing to address them.

Read moreG Suite Enterprise Adoption: Slow But Sure Progress

A Sales Productivity Tool for G Suite and Gmail Users

Sales Productivity in GmailFor anyone who is in sales and who uses either G Suite or Gmail, there’s a new sales productivity platform from Cirrus Insight that’s worth taking on a test drive.

Cirrus Insight’s flagship product was a Chrome extension for Gmail to Salesforce integration. Recently, the company expanded its offering to become a a broad and useful feature set for any user of Gmail or G Suite — regardless of whether they are using a specific CRM application.

Through a combination of internal inventions and acquisitions, Cirrus has assembled a “dream suite” of tools that most salespeople will appreciate.

Here is an overview of a few of the ways that salespeople can benefit from the Cirrus platform.

Read moreA Sales Productivity Tool for G Suite and Gmail Users

FeedBurner: Still Alive And Somewhat Well

Google FeedburnerFeedBurner is a web feed tool that was launched in 2004. The best know web feed format is RSS (Really Simple Syndication).

FeedBurner was acquired by Google in June of 2007.

Several years later, Google’s inattention to FeedBurner made it clear that FeedBurner did not have any direct or even indirect monetization potential.

Because of Google’s lack of attention to the app, bloggers began to predict its demise.

Read moreFeedBurner: Still Alive And Somewhat Well

GOOGLEFINANCE Function In Google Sheets

GOOGLEFINANCE Function ExamplesThe GOOGLEFINANCE function is part of Google Sheets. Google Sheets is available in both consumer Gmail and organization-wide G Suite. The function allows users to create trend charts and comparisons for any assets that have a valid Google Finance ticker symbol.

Here are several examples of how the GOOGLEFINANCE function can be used in Google Sheets to compare the performance of stocks and indexes against one another.

Read moreGOOGLEFINANCE Function In Google Sheets

California Wine Country Maps in Google My Maps

California Wine Country MapsBelow are several California wine country maps that we created in Google My Maps. Included wine country maps are: Napa Valley; Sonoma Valley; Alexander Valley; Lodi; and Paso Robles.

Google My Maps is available to both users of consumer Gmail accounts and to G Suite users.

Google My Maps allows for mass importing winery locations from a spreadsheet. My Maps also allows for manually adding each winery.

Read moreCalifornia Wine Country Maps in Google My Maps

Chrome Enterprise: How Google Will Get More CIOs To Embrace Chromebook

Google Chrome EnterpriseSince Google introduced Chromebook in 2011, the adoption of Chromebooks by businesses has been more of an interesting idea than a widespread reality.

We first wrote about the business potential for Chromebooks soon after they hit the market.

Our contention was that with so many applications moving to the cloud, that many employees would no longer need a heavyweight local operating system such as Windows or macOS. Technologies such as Citrix could be used to access Windows applications from the Chrome browser.

Read moreChrome Enterprise: How Google Will Get More CIOs To Embrace Chromebook

10 Google My Business Best Practices

Google My Business Best PracticesWhether your company is a small local B2C business or a large B2C company, it’s worth paying attention to your Google My Business (GMB) listing.

According to Google, “listings on Google My Business can only be created for businesses that either have a physical location that customers can visit, or that travel to visit customers where they are.”

This means that most businesses can (and probably should) have a GMB listing. A Google My Business listing is a free source that can direct more visitors to a business’s website, almost no matter what type or size of business.

Read more10 Google My Business Best Practices

Google Apps vs G Suite Search Popularity

Google rebranded Google Apps to G Suite in September of 2016. According to Google Trends, since the rebranding, “google apps” has continued to be the more dominant search term.

Read moreGoogle Apps vs G Suite Search Popularity

Embed a “Live” Google Sheets Pricing Table in a Proposal Doc

Embed Spreadsheet Pricing Table in DocumentFor salespeople who regularly send out long form proposals that contain pricing tables, there has always been a conundrum.

That is, a pricing table within in a document can’t be dynamically updated as easily as a spreadsheet table. The word processing capabilities within a spreadsheet are limited.

Often, a proposal’s pricing table is revised several times before the final version of a proposal is sent to the prospect or customer. This can require manual effort. Either the new bottom line in the document table needs to be hand calculated when line items are changed — or the spreadsheet table must be re-copied/pasted a into the document.

Read moreEmbed a “Live” Google Sheets Pricing Table in a Proposal Doc

G Suite Pricing: What Your Business Can Expect to Pay

Updated: November 15, 2018

G Suite PricingThe current G Suite pricing is different than it was when G Suite was known as Google Apps for Work.

Prior to December 6, 2012, Google offered a free business version of Google Apps. Businesses that signed up for that version are grandfathered at no cost for up to 10 users.

Google still offers free versions of G Suite to qualified educational and government institutions as well as to qualified nonprofit organizations.

For businesses, G Suite does come at a cost.

Read moreG Suite Pricing: What Your Business Can Expect to Pay