Data Movements to Create Automated Workflows
Hi all,
Quick question:
We use qpulse as a quality reporting tool. We currently export data and manually enter it in Smartsheet from a .csv. I want to create a tool from that export, that drives a SQL import into Smartsheet, wherein the data from that import can automatically update my dashboards/reports/data source sheets.
My big question is:
1) Is there an API to QPulse?
2) If not, has anyone had any experiencing automated in such a way?
Certifications:
-Smartsheet 2023 Core Product Certification
-Smartsheet 2023 System Administrator Certification
Best Answer
-
The DataShuttle add-on would be perfect for automatically grabbing that .csv and updating the main sheet in Smartsheet. From there you would need to build out your metrics sheet(s) with cross sheet references, and then set up your dashboards to reference these metrics sheets.
Answers
-
The DataShuttle add-on would be perfect for automatically grabbing that .csv and updating the main sheet in Smartsheet. From there you would need to build out your metrics sheet(s) with cross sheet references, and then set up your dashboards to reference these metrics sheets.
-
Awesome Paul... just what I was thinking I'd need to do. Thanks for your help!
Certifications:
-Smartsheet 2023 Core Product Certification
-Smartsheet 2023 System Administrator Certification
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives