I have set up a simple API that does the following: provided an access token to Smartsheet, fetch data of a selected sheet and return graphs that display some analysis.
This video shows the whole operation: it can't be simpler.
This example is not sophisticated: it demonstrates the structure. Reports can be made sophisticated at will, later.

I think this small example perfectly illustrates the major paradigm shift that tools like Smartsheet and Wolfram Cloud achieve when linked together:

• Data capture in a shared environment on the one hand: Smartsheet
• Limitless analysis of data, small data and big data, with return of synthetic reports on the other hand: Wolfram Cloud

Strict separation between data capture and data analysis, using "best suited" tools; still only one single environment for the user.
The possibilities that this mechanism opens are limitless. Think of

• Engineering calculations,
• Financial analysis,
• Polls analysis,
• Marketing analysis,

to name just a few.

I wanted to share my enthusiasm with you.

JP