Google Docs Preferences: Should You Change Default Settings?

Google Docs General PreferencesGoogle Docs provides a lot of flexibility in terms of user preferences.

Some of the preferences are very useful when enabled. Others can be plain annoying.

However, utility is in the eye of the beholder. One person’s annoyance may be another’s productivity booster.

The following is a list the current options in the General tab (under Tools > Preferences), along with our preferences. Of course, your mileage may vary.

[Read more…]

How to Create a Free Marketing Dashboard With G Suite

Marketing DashboardWith the help of four Google components, two of which are included with G Suite and G Suite Essentials, you as a marketer can create a free marketing dashboard.

Once you’ve created a dashboard, you can easily share it with anyone within your organization. All they will need is their G Suite login to access the dashboard.

You can optionally share the dashboard outside of your organization with someone who has a G Suite or Google account.

The needed Google components are:

[Read more…]

Scheduling Vendor x.ai Reports That Google Meet is #2

Google Meet SchedulingThe AI-driven meeting scheduling vendor x.ai reported in a March 18, 2020 blog post that Google Meet is being used in 24.83% of all video conference meetings scheduled using their app.

Zoom is being used in 69.13% of meetings. That means all other online meeting platforms among x.ai’s customers account for only 6.04%.

Keep in mind that Zoom meetings can be hosted by anyone, regardless of what office suite or email client they’re using. Google Meet is specific to G Suite.

[Read more…]

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: July 23, 2020

Google Hangouts Meet Screen
Google Meet, which is available to all users of G Suite 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…]

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 G Suite users by default, but user access can be disabled by a G Suite administrator in the admin console.

[Read more…]

Google Voice For Businesses: Cloud Telephony For G Suite Customers

Updated: May 9, 2020

Google Voice for BusinessesIn April 2019, Google announced Voice [for businesses]. This is different from Google Voice, which is a free, individual user offering for Gmail users.

The Voice announcement was for a complete, cloud-based business telephone system, with features such as auto attendant, call transfer and one button calling among users. This “Cloud Telephony for G Suite” may be disruptive to the entire business cloud telephony industry.

Why? Because Google now has a service that competes directly with popular business VoIP (Voice over Internet Protocol) providers like Vonage, RingCentral, 8×8 and Ooma.

[Read more…]

Bitcoin vs Gold in Google Sheets

Updated: July 28, 2020

Bitcoin vs GoldGoogle Sheets, available as part of both consumer Gmail and organization-wide G Suite, 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…]

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 G Suite or consumer Gmail user outside of one’s own organization.

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

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