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?
Google Data Studio allows you to create reports with data visualizations to share with your clients. When connected to Smartsheet from data studio, you get instant access to Smartsheet data for visualizations, dashboards, and more.
Connecting Smartsheet data source through data studio allows you to build reports from live Smartsheet data in Google Data Studio, without replicating data.
Also you can apply filter based on your desired field and value, or you can create your own calculated field using available fields of Smartsheet. You can use Date Range Control, to get only desired amount of data, in given date ranges.
Key Features Comparison
Data Studio Report
Multiple Data Source
Maximum 50 widgets can add to report
Date Range Control
Blend data with other app data
Scheduled / Automated Reports
Scorecards and Time Series chart
Real Time Collaboration