Conteúdo x
Google Sheets
  • 25 Sep 2023
  • 4 Minutos para Ler
  • Sombrio
    Luz
Conteúdo

Google Sheets

  • Atualizado em 25 Sep 2023
  • 4 Minutos para Ler
  • Sombrio
    Luz
The content is currently unavailable in Portuguese. You are viewing the default English version.
Resumo do artigo

The G2 + Google Sheets integration sends G2 Buyer Intent data directly to your Google workspace, enabling you to share insights with key stakeholders and upload Buyer Intent data into another system.

An example of Buyer Intent data in a Google sheet. Includes key columns like Company, Name, Profile Views, Category Views, Last Seen, etc. Each row represents a new Buyer Intent signal.

About G2 Buyer Intent data

G2 Buyer Intent captures enriched data about buyers researching your product across G2. Buyer Intent signals can be generated by a variety of buyer actions, including interacting with your G2 product profile page, comparing your product to a competitor, and viewing alternatives for a product in a shared category. This data enables your sales, marketing, and customer success teams to identify a buyer's stage in the buyer journey.

Refer to the Buyer Intent documentation for more information on signal types, checking the signals included in your subscription, and more.

Where Buyer Intent data appears in Google Drive

G2 adds a sheet called "{YOUR_PRODUCT_NAME} Buyer Intent Data" to the root directory of the connected user's My Drive.

An example of a document called "G2 Track Buyer Intent data" in the My Drive folder.

Implementation

Before getting started

Only one user at an organization can receive Buyer Intent delivery at a time. If the connected user's account is deactivated, Buyer Intent data will stop flowing into Google Sheets.

1. Activate the integration

A successful implementation setup screen that shows that Google Sheets access is authenticated, the Integration Status is active, and Buyer Intent is configured.

To set up the G2 + Google Sheets integration:

  1. Go to my.G2, then Integrations > Integration Hub.
  2. Select the Google Sheets tile, then select Authenticate Now.
  3. Log in to Google if prompted, then choose your Google account.
  4. Select Allow to confirm G2's access to your Google account. You will be redirected to my.G2.
  5. Set the Integration Status slider to Active. Buyer Intent data will begin flowing to Google Sheets within 24 hours. New Buyer Intent signals are sent daily.

2. (Optional) Configure fields

G2 offers a variety of fields associated with each Buyer Intent signal, including detailed information about the G2 pages viewed and firmographic information about the buyer.

Select Edit Configuration to modify the columns included in your delivery. You can search for additional columns and remove existing ones.

The Buyer Intent Configuration search panel. The search bar is pre-populated with default fields.

The following sections describe the default fields included in your delivery and other fields you can add via my.G2.

Default fields

Name Description
Company The name of the buyer organization.
Country The buyer organization’s headquarters country.
State The buyer organization’s headquarters state.
Total Views The total number of Buyer Intent signals generated for your product during the buyer's session.
Profile Views The number of views of your G2 product profile.
Category Views The number of category pageviews that included your product
Compare Views The number of comparison pageviews that included your product.
Competitor Page Views The number of alternatives pageviews that featured your product or a competitor’s product.
Pricing Page Views The number of views of your G2 pricing page.
Sponsored Content Views The number of views of an advertisement for your product on G2.
Intent Score The Buyer Intent score for your visitor. This field is deprecated as of July 2022.
Last Seen A timestamp of the last time the buyer organization was on G2.

Other fields

Name Description
Activity Level The Activity Level of the buyer. For more information, refer to the Buyer Intent documentation.
Buying Stage The Buying Stage of the buyer. For more information, refer to the Buyer Intent documentation.
Organization ID The G2 ID for the visitor company.
Sector The company's business sector.
Legal Name The legal name of the company.
Domain The company’s website domain.
Domain Aliases A list of domains also used by the company.
Twitter The company's Twitter username.
Org Twitter ID The company's Twitter ID.
Twitter Bio The company's Twitter bio.
Twitter Followers The number of followers the company has on Twitter.
Twitter Following The accounts the company is following on Twitter.
Org Twitter Location The company's headquarters location on Twitter.
Twitter Site The URL for the company's Twitter account.
Twitter Avatar The company's avatar on Twitter.
LinkedIn The company's LinkedIn profile URL.
Facebook The company's Facebook profile URL.
Org URL The URL for the company's website.
Site Title The title of the company's website.
Site H1 The first heading from the company's website.
Site Meta The meta description of the company's website.
Site Author The page author of the company's website.
Description A description of the company.
Founded Year THe year the company was founded.
Tags A list of keywords associated with the company.
Crunchbase Handle The company's Crunchbase handle.
Provider The provider of the firmographic information.
Email Provider Whether the domain is associated with a public email provider.
Company Type The ownership status of the company.
Alexa US Site Rank The Alexa rank for the United States. This field is deprecated as of April 2023.
Alexa Global Site Rank The Alexa global rank. This field is deprecated as of April 2023.
Market Cap The company's market cap.
Employees The number of employees at the company.
Employees Range The number of employees at the company, reported as a range.
Raised The amount of money raised by the company.
Annual Revenue The company's most recent revenue, reported in millions of USD.
Sub Premise The company’s sub premise, such as a suite number.
Street Number The company's headquarters street number.
Street Name The company's headquarters street.
City The company's headquarters city.
State Code The two-character code for the company's headquarters state.
Postal Code The postal code for the company's headquarters.
Country Code The two-character code for the company's headquarters country.
Latitude The company's headquarters latitude.
Longitude The company's headquarters longitude.
Tech The company’s known tech products.
Industry The company’s industry.
Industry Group The company’s industry group.
Sub Industry The company’s sub-industry.
Location The geolocation of the individual buyer.
What's Next