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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives