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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers