Software Tools For a Distributed Workforce

Updated: May 22, 2020

Globally Distributed Workforce

Long before current events changed where and how many of us work, Matt Matt Mullenweg, cofounder of WordPress had developed a 100% distributed workforce at his company Automattic.

Automattic is “distributed first.” The idea of a geographically disperse workforce was a foundational one. Nearly 800 employees work in 67 different countries.

In the following video, Matt provides a number of tips for building what he calls “a distributed capability.” These include:

  • Document everything
  • Always leave a trail (so others can pick up where you left off)
  • Move communications online
  • Find the right [software] tools
  • Create productive face to face time
  • Help people create their own working space

[Read more…]

6 Audio Options for Google Meet

Updated: September 23, 2020

Google Hangouts Meet Screen
Google Meet, which is available to all users of Google Workspace and consumer Gmail users, is an easy to use online meeting application. As do all meeting apps, Meet supports camera, audio and screen sharing.

As far as audio hardware goes, there are a number of options. Some work better than others, depending on the environment the meeting host or attendee is in.

Keep in mind that just one attendee who introduces too much ambient noise can degrade the meeting experience for all attendees.

[Read more…]

How To Remove Duplicates In Google Sheets

DuplicatesThere are a number of cases in which you may want to remove duplicates from a list of records using Google Sheets.

For example, you may want to remove duplicate records before importing a list of leads into a CRM system such as Salesforce—or into a marketing automation system like ActiveCampaign.

Despite all of Google’s human and artificial intelligence capabilities, Sheets does not have a very sophisticated deduplication logic… yet.

[Read more…]

Pixelbook Go: The Ideal Travel Companion

Google's Pixelbook GoGoogle released Pixelbook Go on October 27, 2019.

Go is marketed as a consumer laptop. But since this is a business-oriented site, we’ll take a corporate angle on this new Google offering.

If you’re not familiar with Chromebook’s Chrome OS, it’s a lightweight operating system that can be considered “browser first”—mainly a gateway to the cloud.

[Read more…]

What is Google Workspace?

What is Google Workspace?Most people are aware of consumer Gmail. If you don’t personally use Gmail, you likely receive email from friends and family with gmail.com addresses.

Many people don’t realize that Gmail is also available to organizations.

Gmail is just one of the components of Google Workspace. Other components include Calendar, Drive, Docs, Sheets, Slides and Sites.

[Read more…]

How to Block (And Unblock) Emails on Gmail

Stop Unwanted Emails in GmailWe all get annoying emails in consumer Gmail and business Gmail that aren’t necessarily spam.

Let’s look at some of these types of incoming emails and why you might want to block them instead of reporting them as spam. Then we’ll look at how to block and unblock emails.

The emails in question are sometimes personalized. They often come directly from an individual email account (as opposed to from an email server).

[Read more…]

Gmail Templates: How to Create Them Using Canned Responses

Create Gmail TemplatesBoth consumer Gmail and business Gmail users often have a need to create Gmail templates.

Fortunately, Google Labs developed an easy (and free) way to create Gmail templates. This app is called Canned Responses. As its name implies, the intent of the app was for responding to inbound emails. However, the majority use case may well be for new outbound emails.

Access to Canned Responses is available to Google Workspace users by default, but user access can be disabled by a Google Workspace administrator in the admin console.

[Read more…]

Bitcoin vs Gold in Google Sheets

Bitcoin vs Gold

Updated: January 16, 2021

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

[Read more…]

Five Google Workspace to Salesforce Integrations and How They Benefit Businesses

Google Booth at Dreamforce 2018

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

Google Sheets Data connector for Salesforce

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

Google Workspace Security Key

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 Office 365

Google Workspace vs 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

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

This site includes affiliate links to Google.com and associate links to Amazon.com. As an Amazon Associate, I earn from qualifying purchases.

Gmail™, Google Workspace™, Google Sheets™ , Google Docs™ , Google Slides™ , Google Meet™ , Google Drive™, and Google Sites™ are trademarks of Google LLC