I’ve built a cryptocurrency portfolio app that uses an automation as follows: The trigger is a “At a scheduled time” set to once every 15 minutes. The Action is “Run a script”. The script fetches Cryptocurrency prices, converts them to £GBP and then writes them to a table for inclusion in some formulas.
When I share this base, the automation is not shared, I must provide setup instructions to the recipient so that they recreate the automation. This is true even if the base has been copied to a Workspace with a Pro plan.
I see that recently, the scripting App has become free to all users so wonder if I can remove the Automation but replace it with a Script App that will be able to trigger on a schedule, programatically.
Is this feasible? Does anyone have any experience, advice or suggestions for a better solution?
I can see similar questions were asked in this category but well over a year ago.
Many, many thanks