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


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 SheetsData_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

  6. Add to Report, using default configuration

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.

Was this article helpful? 1 out of 2 found this helpful