At our studio, we often generate reports to send to clients, which include shot data relating to the delivery of the project. At present we query data on Shotgun and input it to an Excel sheet, either manually or via a script. We would very much like to automate this process and generate reports straight out of the Shotgun web app. Is there a way to do this and/or any best practices to go about it?
Any ideas would be appreciated!