How to Perform a HubSpot Lead Source Analysis in Google Sheets

Last Modified: August 21, 2023 - 3 min read

Hannah Recker

In order to optimize campaign strategy, budget allocation, and other marketing efforts, marketers need to understand where leads come from. That’s where lead source analysis comes in.

But manually conducting lead source analysis is incredibly labor-intensive, time-consuming, and error-prone.

Who hasn’t spent hours copying and pasting data into a spreadsheet only to find they made a mistake?

But here’s the good news: you can automatically perform lead source analysis entirely in Google Sheets, without all the hassle.  

In this blog, we’ll show you how to generate a comprehensive lead source analysis with your HubSpot data using Coefficient’s GPT-powered pivot table builder.

Step-by-Step Guide: Analyze Lead Sources Directly in Google Sheets

Coefficient is a free Google Sheets add-on that allows you to connect your business systems to Google Sheets and pull real-time data into your spreadsheet.

Coefficient also comes with several powerful AI features that help marketers easily perform lead source analysis.

First, let’s install Coefficient. Open Google Sheets. Click Extensions on the menu bar and select ‘Add-ons’ -> ‘Get add-ons.’

google sheets addon coefficient

This will launch Google Workspace Marketplace. In the search bar at the top, search for “Coefficient” and select the Coefficient app.

coefficient data connector

Grant Coefficient access to your Google account by pressing ‘Allow.’

coefficient permissions

Then, return to your Google Sheets menu and click on Extensions -> Coefficient -> Launch.

Image10

Coefficient will appear on the sidebar of your Google Sheet. Now you can import your live HubSpot data into Google Sheets.

Click ‘Import from…’ on the Coefficient sidebar menu.

import live data google sheets

Scroll down the sidebar to select HubSpot as your data source. Click ‘Connect.’

Image8

Now click ‘Authorize’ to grant Coefficient permission to access your HubSpot account.  

Image19

Click ‘From Objects & Fields’ to import your data from HubSpot.

Image16

Select “Contacts” from the list of objects.

Image6

Choose the fields you want to import. 

Image14

In this example, we’ll select: ‘ID,’ ‘Date,’ ‘Deal Name,’ ‘Lead Source,’ ‘Amount,’ ‘Deal Revenue,’ and ‘Status.’

Image2

Name your import and click ‘Import’ to pull your data into your spreadsheet. Your import should look something like this:

Coefficient Excel Google Sheets Connectors
314,000 Pros Sync Live Data from Their Business Systems into Spreadsheet

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

Image9

Once your data is imported, we can start building our lead source analysis. Select ‘GPT Copilot’ from the Coefficient app menu.

Image11

Choose ‘Pivot Builder.’

Image17

Use your cursor to select the data range.

Image3

Pro tip: instead of dragging all the way down, you can delete the ‘9’ from “Deal!A2:G9” and the pivot builder will automatically take care of the rest.

Now describe the pivot table you want to build in the text box. Let’s view our deal revenue and number of deals by lead source and by month.

Input “Summarize deal revenue and count of deal revenue by lead source, pivot by month.”

Click ‘Build.’

Image18

Click ‘Insert’ -> ‘New Sheet,’ and your pivot table (GPT Pivot!A1) will automatically populate in a new sheet.

Image13

Now, you can see the deal revenue and the count of deal revenue in your table.

Image7

Note: The Pivot Builder saves your prompt history if you want to use it later.

And there you have it! Now you can easily perform a lead source analysis with your HubSpot data directly in Google Sheets!

Master Lead Source Analyses with Your HubSpot Data using Google Sheets + Coefficient

Coefficient makes it easy for anyone to use their HubSpot data to perform any analysis directly in Google Sheets, saving time and the headache of combining multiple CSV extracts.

Ready to take your HubSpot reporting to the next level? Check out Coefficient (for free) to start performing your lead source analysis today.

Set Spreadsheet Data on Refresh

Try the Spreadsheet Automation Tool Over 300,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 300,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Hannah Recker Growth Marketer
Hannah Recker was a data-driven growth marketer before partying in the data became a thing. In her 12 years experience, she's become fascinated with the way data enablement amongst teams can truly make or break a business. This fascination drove her to taking a deep dive into the data industry over the past 4 years in her work at StreamSets and Coefficient.
Google icon
300,000+ users on Google Marketplace
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies