79347547

Date: 2025-01-11 05:19:02
Score: 1
Natty:
Report link

Easiest way imo is to use a time-based built in trigger for the Sheet, selecting the function you want to run on the time-based trigger, as shown here: https://help.databox.com/how-to-refresh-a-google-sheet-using-google-apps-script

Can create many different triggers to run different functions, or the same functions on different schedules, or a combination thereof.

This works well for me for the use-case of refreshing asset price data fetched once every 10 minutes.

Reasons:
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: christopherbalz