Contents x
    Google Sheets
    • 25 Sep 2023
    • 4 Minutes to read
    • Dark
      Light
    Contents

    Google Sheets

    • Updated on 25 Sep 2023
    • 4 Minutes to read
    • Dark
      Light
    Article Summary

    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

    NameDescription
    CompanyThe name of the buyer organization.
    CountryThe buyer organization’s headquarters country.
    StateThe buyer organization’s headquarters state.
    Total ViewsThe total number of Buyer Intent signals generated for your product during the buyer's session.
    Profile ViewsThe number of views of your G2 product profile.
    Category ViewsThe number of category pageviews that included your product
    Compare ViewsThe number of comparison pageviews that included your product.
    Competitor Page ViewsThe number of alternatives pageviews that featured your product or a competitor’s product.
    Pricing Page ViewsThe number of views of your G2 pricing page.
    Sponsored Content ViewsThe number of views of an advertisement for your product on G2.
    Intent ScoreThe Buyer Intent score for your visitor. This field is deprecated as of July 2022.
    Last SeenA timestamp of the last time the buyer organization was on G2.

    Other fields

    NameDescription
    Activity LevelThe Activity Level of the buyer. For more information, refer to the Buyer Intent documentation.
    Buying StageThe Buying Stage of the buyer. For more information, refer to the Buyer Intent documentation.
    Organization IDThe G2 ID for the visitor company.
    SectorThe company's business sector.
    Legal NameThe legal name of the company.
    DomainThe company’s website domain.
    Domain AliasesA list of domains also used by the company.
    TwitterThe company's Twitter username.
    Org Twitter IDThe company's Twitter ID.
    Twitter BioThe company's Twitter bio.
    Twitter FollowersThe number of followers the company has on Twitter.
    Twitter FollowingThe accounts the company is following on Twitter.
    Org Twitter LocationThe company's headquarters location on Twitter.
    Twitter SiteThe URL for the company's Twitter account.
    Twitter AvatarThe company's avatar on Twitter.
    LinkedInThe company's LinkedIn profile URL.
    FacebookThe company's Facebook profile URL.
    Org URLThe URL for the company's website.
    Site TitleThe title of the company's website.
    Site H1The first heading from the company's website.
    Site MetaThe meta description of the company's website.
    Site AuthorThe page author of the company's website.
    DescriptionA description of the company.
    Founded YearTHe year the company was founded.
    TagsA list of keywords associated with the company.
    Crunchbase HandleThe company's Crunchbase handle.
    ProviderThe provider of the firmographic information.
    Email ProviderWhether the domain is associated with a public email provider.
    Company TypeThe ownership status of the company.
    Alexa US Site RankThe Alexa rank for the United States. This field is deprecated as of April 2023.
    Alexa Global Site RankThe Alexa global rank. This field is deprecated as of April 2023.
    Market CapThe company's market cap.
    EmployeesThe number of employees at the company.
    Employees RangeThe number of employees at the company, reported as a range.
    RaisedThe amount of money raised by the company.
    Annual RevenueThe company's most recent revenue, reported in millions of USD.
    Sub PremiseThe company’s sub premise, such as a suite number.
    Street NumberThe company's headquarters street number.
    Street NameThe company's headquarters street.
    CityThe company's headquarters city.
    State CodeThe two-character code for the company's headquarters state.
    Postal CodeThe postal code for the company's headquarters.
    Country CodeThe two-character code for the company's headquarters country.
    LatitudeThe company's headquarters latitude.
    LongitudeThe company's headquarters longitude.
    TechThe company’s known tech products.
    IndustryThe company’s industry.
    Industry GroupThe company’s industry group.
    Sub IndustryThe company’s sub-industry.
    LocationThe geolocation of the individual buyer.
    What's Next