Hi
I am currently working on a Appsheet project.
there is one problem that we want to update status every 5 min.
However the automation setting just allows us to do hourly as a shortest term
I have tried to create 11 bot for make it come true, this is not a good way for maintain appsheet.
Editor got to be work worse.
Can you share if there is a good solution for this request.
Thank you in advance.
You can write a Google Apps Script to run every five minutes and update your table via the API which will trigger the bot to run.
Hi @StephenHind ,
Were you able to successfully use this approach of invoking the automation through apps script?
The help article about external eveneting specifically highlights the point below
So you may want to share your insights on how you have implemented it.
May I ask what do you want to do in every 5 minutes? Does it need to run every 5 minutes in every hour in every day? Or do you need to update a row within every 5 minutes if ex. the status column is not updated after the row was created?
hi thank you for your support,
thankfully, i could have make it work.
thank you again
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
