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 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
Multiple Data Source
Maximum 50 widgets can add to report
Date Range Control
Blend data with other app data
Real Time Collaboration