I wonder if now, after being purchased by Google, Appsheet would alow/be able to create functions using google api, just input your api key simewhere and use functions within appsheet rather than google scripts.
For example, a while back i wanted to be able to calculate driving distance between addresses. I had to write a google script but due to the daily limitation by google, my app was useles, more over, there was no way to add google map api to that script.
So now is the time to fully integrate the full power of google services with appsheet.