There 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.
The Chrome browser and G Suite can work together in several ways.
These connections will help you create and find documents more easily. They will save you mouse clicks.
The following tips also work for consumer Gmail accounts.
[Read more…]3 Ways Chrome and G Suite Work Together To Save You Time
Google 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.
You missed an important online meeting. Was it because you did not create a Google Calendar Reminder?
It’s more likely because you did not enable one or more Event Notifications.
Let’s look at the difference between Reminders and Event Notifications.
[Read more…]Google Calendar Reminders vs. Event Notifications
Because Google is a search company at its core, there is a collateral search benefit to users of Gmail for Business (G Suite) and consumer Gmail users.
That benefit is a set Gmail search operators that you can use to find specific emails anywhere within a Gmail account.
Here are some of the ways you can use these search operators to save time.
[Read more…]10 Gmail Search Operators That Will Save You Time
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.
What many people don’t realize is that Gmail is also available to organizations.
Gmail is just one of the components of G Suite. Other components include Calendar, Drive, Docs, Sheets, Slides and Sites.
[Read more…]What is G Suite and Should I Consider It For My Business?
We 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).
Both 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…]Gmail Templates: How to Create Them Using Canned Responses
In April 2019, Google announced Voice for Business. The previous iteration of Google Voice—which is still available—was a free, individual user offering for Gmail users.
The April 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…]Google Voice For Businesses: Cloud Telephony For G Suite Customers
Over time, some businesses end up with a plethora of different logins to assorted Google and non-Google online properties.
This is particularly true in the digital marketing realm, where there can be dozens of online accounts that a staff marketer or a contract marketer needs to access.
[Read more…]G Suite Pro Tip: Best Practices For Managing Access to Online Marketing Accounts
Google Drive is well known as a consumer product. 1.5+ billion Gmail users each have access to 15 GB of free cloud storage on Google Drive (consumers can always buy more storage).
What many people don’t know is that Google Drive is also a business product. It is a part of G Suite, the business version of Gmail.
[Read more…]10 Ways Google Drive Saves Businesses Time & Money
Google Sheets, available as part of both consumer Gmail and organization-wide G Suite, allows users to easily create trend charts of anything with a valid Google Finance ticker symbol. Bitcoin happens to have a symbol.
A Bitcoin price chart can be created using the GOOGLEFINANCE function. The GOOGLEFINANCE function supports any date range. It supports both daily and weekly intervals. You can “set and forget” the function — cells will auto-populate or auto-update at regular intervals.
Many people have multiple Gmail logins.
An example is someone who has a personal Gmail account and one or more business Gmail (G Suite) 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…]Login to Gmail as Different Users in the Same Browser
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…]Why Become a Google Customer Instead of Just a Gmail User?
One 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…]Sharing Google Docs Outside of an Organization: A Major Barrier Removed
The 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.
Updated: December 26, 2019
Salesforce 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…]How To Set Up Salesforce Files Connect for Google Drive
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.
Among a wide range of facets to the partnership are the following five Salesforce to G Suite integrations.
[Read more…]Five G Suite to Salesforce Integrations and How They Benefit Businesses
Many 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 more…]How To Find a G Suite Partner To Help With Your Implementation
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…]6 Business Data Sources To Feed Into Google Sheets
Updated: March 14, 2019
If 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 more…]How Admins & Users Can Make G Suite Security Even Stronger
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.
Updated: April 10, 2019
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, G Suite includes Forms, Drawings, My Maps and new Google Sites. Google Jamboard and Voice for G Suite (2019) are paid extras. 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 more…]G Suite vs Office 365: What’s Best For Your Company?
Updated: February 23, 2020
In 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.
Let’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 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 more…]Google Sheets and Microsoft Excel: Moving Data Between The Two