Leveraging the Power of Google Sheets and Salesforce

When thinking about cornerstone software companies that are assisting enterprises today, Google and Salesforce are at the top of the list. 

With G-Suite, Google Cloud, and Google Marketing Platform offerings, many companies rely on Google to operate multiple aspects of their business.  On the same token, Salesforce continues to dominate the CRM space, while also expanding their relevance within the enterprise with Marketing Cloud, Commerce Cloud, and more.

Many enterprises know about the Google Analytics 360 to Salesforce integration (check out our Dreamforce presentation on this topic if interested in learning more) but not many are aware of the Google Sheets to Salesforce connection and its benefits. 

The Google Sheets and Salesforce Integration 

The Google Sheets & Salesforce integration was first announced in 2018, allowing Salesforce data from a specific object (e.g. Leads) to be pulled into Google Sheets with the click of a button. 

Pulling this information into Google Sheets allows you to make edits on the fly, which automatically updates this information inside your Salesforce org. This can be a massive time-saver. Think about the last time you had a bunch of leads that needed their Lead Status or Lead Source updated. With this integration, instead of exporting this information, making any changes, and then uploading this file, you can simply push this information into Google Sheets, make the necessary changes, and have this information update Salesforce for you.

Another benefit of pushing Salesforce data into Google Sheets is the added flexibility that comes with it. By having Salesforce data within Google Sheets, this information can then easily be visualized in Google’s Data Studio or integrated into other Google products like Google Slides. It also means you can create pivot tables from a data set for added flexibility/functionality. For example, by tracking Opportunities values by salesperson and estimated close date, you can help your Finance team build out annual revenue forecasts. 

Steps For Using Google Sheets And Salesforce 

When it comes to taking advantage of everything that Google Sheets and Salesforce have to offer, all of this can be set up in a matter of minutes by following these simple steps:

1) Download the Salesforce Connector:

    1. Open up a sheet in Google Sheets
    2. In the top navigation click on Add ons > Get add-ons
    3. Find “Data connector for Salesforce” and click Add +

2) Connect to Salesforce:

    1. Open up a sheet in Google Sheets
    2. In the top navigation click Add ons > Data connector for Salesforce > Login to Salesforce
    3. Select whether it is a Production or Staging environment
    4. Click Authorize
    5. Log in with your desired Salesforce credentials

GoogleSheets.SF-screenshot (1)

From there you can then quickly Update, Refresh, and Delete data within a couple of clicks. Instructions on how to do each of these can be found in these simple steps on Google’s site. 

Wrap Up 

We hope this blog post left you with actionable insight on how to connect Google Sheets and Salesforce for massive time-savings. 

Have questions or comments about this blog post?  Reach out today. 

You may be interested in

Sales Leadership Setting Up for Success

Sales Leadership: Setting up for Success

As a sales leader, there are a number of strategies you can implement to ensure your team is set up for success, but arguably the most critical is this simple yet effective combo: Reports* + Reports** * the people you lead on your team ** the actual data and numbers Part 1: Meet with your […]

Read More

Building the RevOps Scaffolding to Support your Planned Growth

In a perfect world, a company’s revenue grows in an upward arc. As a Canadian, we like to think that it resembles a hockey stick curve. However, the systems and processes that provide the scaffolding to support that growth curve tend to evolve in a stair-step fashion. While CloudKettle is a fan of growth, some […]

Read More

Sign up for the latest tips & news from CloudKettle

Thank you for subscribing.