Add imported data from Zoho Analytics to report on Zoho Creator

Add imported data from Zoho Analytics to report on Zoho Creator

Hello,
I'm trying to find a workaround to give users the ability to search inside subforms in Zoho Creator app.

As suggested from Zoho support team, I'm trying to use Analytics to create custom reports. I did the following:
  1. I connected Zoho Creator with Analytics and imported the main records + their subforms (which are in separate sheets)
  2. I created a query report which JOINs the two tables
Now my question is:
  1. what's the suggested way to send datas from the JOINed table to Creator? Is there any integration to do that?
  2. can this operation be scheduled (i.e.) once a day?
Thank you