Bitcoin vs Gold in Google Sheets

Updated: July 28, 2020

Bitcoin vs GoldGoogle Sheets, available as part of both consumer Gmail and organization-wide Google Workspace, allows users to easily create trend charts based on any source that can be connected to a Google Sheet.

The GOOGLEFINANCE function for Bitcoin was not working for a time, but seems to be working again now. You can “set and forget” the function—cells will auto-populate or auto-update at regular intervals.

[Read more…]

Login to Gmail as Different Users in the Same Browser

Many people have multiple Gmail logins.

An example is someone who has a personal Gmail account and one or more business Gmail (Google Workspace) accounts.

In fact, independent contractors such as marketers can have many business Gmail accounts—one for each of their customers.

The good news is that an individual can login to Gmail as different users within the same browser.

[Read more…]

Why Become a Google Customer Instead of Just a Gmail User?

When someone uses a free service such as Gmail, Facebook, Twitter or LinkedIn, they are not a customer of the service provider.

For free services such as these, the customers of the service provider are the advertisers.

The product offered by the service provider to advertisers is a combination of the service itself and the users of the service. In other words, free users are a part of a product offering for advertisers.

[Read more…]

Sharing Google Docs Outside of an Organization: A Major Barrier Removed

Google Docs SharingOne of the key advantages that Google Docs has over the competition is that a document (or spreadsheet or presentation, etc.) can be shared for editing or commenting with any Google Workspace or consumer Gmail user outside of one’s own organization.

But what if a Google Workspace user needs to share a document with someone outside their organization who does not have a Gmail account?

[Read more…]

7 Useful Apps That Are Included With Google Workspace

Google Workspace Included ApplicationsThe core applications of office productivity suites such as Google Workspace 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 Google Workspace extras that are included in the monthly per user price. Not everyone is aware of these bonus applications.

[Read more…]

How To Set Up Salesforce Files Connect for Google Drive

Updated: December 26, 2019

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 Google Workspace).

It’s best that the same username is used for logging into both. This may mean temporarily making a Google Workspace 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 Google Workspace, you can try this setup yourself with a free trial of Google Workspace.

[Read more…]

Five Google Workspace 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 Google Workspace integrations.

[Read more…]

How To Find a Google Workspace Partner To Help With Your Implementation

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

There are a lot of companies that advertise Google Workspace 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 more…]

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 more…]

How Admins & Users Can Make Google Workspace Security Even Stronger

Updated: March 14, 2019

Google Workspace Security KeyIf you’re using Google Workspace or considering Google Workspace for your organization, there may be questions about Google Workspace 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.

Google Workspace, as you’d expect, has multiple levels of built-in security.

[Read more…]

Gmail Offline For Business and Consumer Users

Google has introduced native Gmail Offline for business (Google Workspace) 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 Google Workspace, mainly for offline access, may find that the local client is no longer needed.

[Read more…]

Google Workspace vs Microsoft Office 365

Updated: April 10, 2019

Google Workspace vs Office 365Google Workspace (formerly G 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, Google Workspace includes Forms, Drawings, My Maps and new Google Sites. Google Jamboard and Voice for Google Workspace (2019) are paid extras. Included extras at no additional charge are Google Chat and Google Meet.

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

[Read more…]

Google Meet vs GoToMeeting

Updated: May 5, 2020

Google Meet vs GoToMeetingIn March 2017, Google introduced a new online meeting experience called Hangouts Meet. On April 7, 2020, the app was rebranded to “Google Meet.”

This online meeting capability used to be a major differentiator between consumer Gmail and business Google Workspace.

A Google Meet meeting could only be initiated by someone who was part of an organization using Google Workspace and for which the Meet capability has been enabled for the Google Workspace organization. However, the ability to be a Google Meet host will soon be available to anyone with a Google account—including a free Gmail account.

[Read more…]

Google Sheets and Microsoft Excel: Moving Data Between The Two

Google Excel Spreadsheet Exchange DataLet’s begin with a distinction between Google Sheets & Microsoft Excel:

Microsoft 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 Google Workspace (formerly G Suite).

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 more…]

25 Ways Google Workspace Improves Business Productivity

Accelerate Business With Google WorkspaceThere are many aspects to Google Workspace 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 Google Workspace.

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

[Read more…]

Google Chat vs Google Meet vs Classic Hangouts

Updated: July 15, 2020

Google Chat Meet HangoutsIt’s a challenge to keep with Google’s various iterations of chat, online meeting and Hangouts products—as well as the branding of these apps. In fact, we need to frequently update this post.

Google now has three distinct components in this category that are a part of Google Workspace’s core services, a.k.a. core apps.

Here is a roundup of the Google Hangouts, Meet, Chat (and now Rooms) offerings.

[Read more…]

Where is Google Workspace Data Stored?

Google Workspace Data StorageGmail and Google Workspace 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 more…]

Google Workspace Enterprise Adoption: Steady Progress

Updated: April 25, 2019

Google Workspace Enterprise Adoption

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

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

[Read more…]

A Sales Productivity Tool for Google Workspace and Gmail Users

Sales Productivity in GmailFor anyone who is in sales and who uses either Google Workspace 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 Google Workspace — 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 more…]

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 more…]

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 Google Workspace. 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 more…]

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 Google Workspace users.

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

[Read more…]

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 more…]

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 more…]