I found the right way to handle this from the URL, without the need to build a new workbook every single time the link is accessed, plus I plan to make these trends widely available to folks who will only be assigned rights to View these worksheets. This opens the worksheet in View-only mode as well, which will be helpful for my use case.
https://your-instance-url/view/WORKSHEET_ID?displayRangeStart=YYYY-MM-DDTHH:MM:SSZ&displayRangeEnd=YYYY-MM-DDTHH:MM:SSZ
I did look through the documentation but did not find mention of this is while going through the KBs - perhaps you could point me to the right place which contains a full list of these URL query parameters which are useable with '/view/'? I am trying to generate the trends with displayRangeStart= *-1hr (now minus 1 hour) and displayRangeEnd = * (now) however it does not work for me.
Besides that, is there a way for me to also set the timezone from the URL query parameters?