Let me start by saying that, although I am technically savvy, I do not know all the inner workings of coding/writing scripts/APIs/et cetera.

As for my problem, I am using a 3rd party dashboard service that does not have direct integration with Zoho Creator or Zoho Reports. The dashboard service does integrate with Google Sheets.

So, as painful as it is, I have been taking the data manually from a Zoho Reports dashboard and updating the Google Sheet twice a day. The inefficiency of this is frustrating to say the least - and automating this process would be the highlight of my month (I lead a boring life).

I have spent the past several hours trying to find a way to get the data on my Zoho Reports dashboard over to the google sheet with no luck. I have also tried to find ways to push raw data from Zoho Creator to the google sheet, also with no luck.

With that being said, I know there must be some solution or clever workaround that you all could probably come up with in minutes -- so, I finally brought myself to asking.

I would be beyond appreciative if one of you would be able to help me automate my life a bit -- and an "explain like I'm five years old" instructions would be even more appreciated.

Thank you all so much in advance!