What is Smartsheet Connector?

Smartsheet Connector is Looker Studio connector that helps to connect Looker Studio with Smartsheet  and use it as  a data source  in Looker Studio.

Smartsheet Connector turns your data into informative dashboards and reports that are easy to read, easy to share, and fully customizable.

What is Smartsheet?

Smartsheet is a software as a service offering for collaboration and work management.

Smartsheet is a spreadsheet-style project management solution for businesses managing multiple projects with dozens of moving parts. It helps companies of all sizes manage workflows and improve collaboration 

How does it work?

Step 1: Choose "Smartsheet" connector by Jivrus Technologies from Google Looker Studio Partner Gallery

Step 2: Click on 'AUTHORIZE' button for authorizing your google account.

Step 3: Once you click Authorize button, you can provide access with your Google account

Click on 'Allow' button for Access  google Account.

Step 4: Once you give access to google account, you need to authorize the third-party service. In this case Smartsheet.

step 5: Click on 'AUTHORIZE' button for authorizing your Smartsheet account.

Step 6: Once you click on authorize, you need to login with your Smartsheet Account.

Click on Allow button to provide authorization.

Step 7: Choose the Smartsheet Object Type you want to use.

Step 8: Select the Smartsheet Sheet you want to use.

Step 9: Click on 'Connect' button.

Step 9: The available fields from the Sheet Object is listed .

Step 10: Use this as a data source and continue normally with designing your report in Looker Studio.

Step 11: Click on 'Create Report' button.

Step 12: You can customize the dashboard as you want.


Smartsheet - Looker Studio Dashboard

An example of a dashboard created in Looker Studio with Smartsheet Data Connector.


Why you need Data Studio for Smartsheet?

 Key Features  Comparison

Data Studio Report

  Smartsheet Dashboard

Data Import/Export 

Multiple Data Source

Maximum 50 widgets can add to report

Data Visualization 

Date Range Control

Blend data with other app data

Scheduled / Automated Reports

Scorecards and Time Series chart

Customizable Dashboard

Geo maps

Share Reports

Real Time Collaboration

Smartsheet Report Template

Sample Data Studio Report Template