Streaming custom function in Google Sheets?

[Tuan Do]

Just wondering whether there is a way to build a custom function in Google Sheets that can stream real-time data? I am trying to build a custom function which can receive data from my website every second and display it in the cell. Basically I need a function that reruns every second (or every few seconds is also fine).

I have tried to search for something like this but could not find the answer. I have also though about using time trigger to rerun the functions every second but add-on's custom functions can only rerun every hour if we use time trigger.

Appreciate any help.

[Bennett, Scott]

You can use an installable trigger on App Script.  They can run every minute. 

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/a2145f7b-d9b4-46b4-9e09-f47906baa9afn%40googlegroups.com.

--

Scott Bennett

[Tuan Do]

Thanks for your answer. Every minute unfortunately does not work for me. I am looking for something more frequent than that (at least every 5 seconds)

[Jonathan Butler]

I don't see why that couldn't work, besides the UrlFetchApp quota. As long as the data is under a certain amount, you can do it pretty easily with one custom function. You have set the custom function reference to be the start and end area of the data you want to view. Upon a change, all data gets sent to that function automatically, then just UrlFetchApp to your api endpoint.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/2ca67c1b-8602-4c14-af58-650753cd3d91n%40googlegroups.com.

[Tuan Do]

How do I make that function automatically rerun every 5 seconds? time trigger can only run every minute.

[Jonathan Butler]

It runs every time there is an edit. To my knowledge, there would be no need to run when there is no edit. If you can give me more details on the environment I can be of better help.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/5322b13e-f70f-4086-a441-d921b3b6dff7n%40googlegroups.com.

[Do Quoc Tuan]

Oh I need it to rerun automatically every 5 seconds without any editing required. Essentially I am trying to build a streaming function.

You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/V6lCBqAaZO4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAE9k5yC6jO%2BGYS_bMmDegiuavHre9Xdpr5jq-WPYUdh06u_1oA%40mail.gmail.com.

[Jonathan Butler]

This should help you out.

- Create a trigger that calls a function every 5 minutes.

- The function is a while loop that sends the data, then sleeps for 3 seconds.

- Then the program terminates itself after 5 minutes by checking the time difference from the start time every run.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAHi8D-u%3DwMxopQb4b6Xzn05YAL7EJGBpKKa2j1u%3D2yfvrJb2gQ%40mail.gmail.com.

[Tuan Do]

Thanks for your answer. That idea may work. Just wondering whether there is an easier way than that? In Excel there is something called streaming function: https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-web-reqs#make-a-streaming-function. We can even use websocket in Excel custom function. I am hoping Google App Script has something similar