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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives