How to get Space -> Apps -> Sheets information into a QVD file using single Automation

[VijaySekar]

I am trying to get the details of all the space, apps and the sheets in each app into a QVD file to create an app on this. Could anyone suggest how to achieve this in Qlik Sense SaaS version please.?

Ex. I need to create a table like below

SpaceName     AppName    SheetName                             SheetType

Dev                  Test              Space_App_Sheets                Public

Prod                 Test1            Demo                                      Private

[VijaySekar · Accepted solution]

This is what i want. Thanks for the solution DaveChannon. 

[Harsha-Lodha]

Hello @DaveChannon  Thank you for sharing this. I am trying to track the changes in the app on backend (such in load script or data connection) also frontend changes (such as addition of new sheet or change in expression). I want to use this to trigger my automation to backup that app. When I make any backend changes App's Modified date changes. Can you please help tweak your automation a bit to use this to track or just get flagged if there are any frontend changes in any apps.