All Collections
Reporting and data management
Copper reports
Looker Studio: Pull data from Google Sheets Add-on into Looker Studio
Looker Studio: Pull data from Google Sheets Add-on into Looker Studio

Looker Studio: Pull data from Google Sheets Add-on into Looker Studio

Success at Copper avatar
Written by Success at Copper
Updated over a week ago
AllPlans.png

If you want to surpass the data limitation of the Looker Studio, you can use our Google Sheets add-on to pull data into Looker Studio. This article explains how.

Import and connect your Copper data to Looker Studio

There are two parts to connecting Copper to Looker Studio:

  1. Importing Copper data into a Google Sheet

  2. Connecting the Sheet to Looker Studio

Part 1 - Import your Copper Data into a Google Sheet

google sheets add on import data.png

Import your data using the Copper Google Sheets Add-on

    1. Once the Add-on is installed, go to Add-ons

    2. Select Copper CRM for Google Sheets --> Import data

    3. When the side panel pops up on the right, choose what you’d like to import. In this example, we’ll be using Opportunities

    4. Select the appropriate pipeline - we’ll be using Sales in this example

    5. Choose a filter from the dropdown if you’re looking to segment your import at all.

    6. Once you’ve selected what you’re importing, click “Import Data”. Note: It may take a few minutes for the data to load in your Sheet, depending on the number of records.

google sheets add on side panel.png

Part 2 - Connect your Copper Import to a report in Looker Studio

  1. Open Google Looker Studio and click the “+” to create a new report

  2. Once a blank report opens, in the bottom right, select “Create New Data Source’

  3. Under Connectors, select Google Sheets

    Data_Studio_Connector.png
  4. Select the appropriate Spreadsheet & Tab with your imported data (i.e. “All Opportunities - Sales”)

    mceclip0.png
  5. Define Optional Range as "A2:BB" (where BB is the right-most column).

    mceclip1.png


    Note: This is because the Google Sheets Add-on uses two rows for column headers. The first row is the API field name (normally hidden) and the second is the plain text field name. Defining the optional range enables us to the plain text column names.
    - Do not include a number after "BB", like "A2:BB700". If you did this, then it would ignore data below row 700.
    - Unfortunately, deleting row 1 (API field names) would only temporarily resolve this issue. When you refresh the data with CRB, the sheet will be overwritten, which will restore both rows of column headers

    mceclip2.png
  6. Add to Report, using default configuration

    mceclip3.png

Now you're Copper data is successfully connected to a new Looker report.

Still have questions?

Still have questions? Ask in our Community, and get answers from our Customer Success Team as well as fellow users.

Did this answer your question?