Also the ability to pick the exact time for it to run when using the automatic updates (hourly).
Right now it looks like the hourly updates at 22 minutes past the hour, no matter when it is started. Even if we can't pick the exact time, it would be much more useful if it ran 1 or 2 minutes past the hour. That might be a simple change on your end. Thanks for considering it.
Or every 5 minutes.
Update connections more then once a week, ex. Monday Wednesday, Friday, or twice a day if necessary etc.
Update Sheets faster, maybe 5 min intreravlas
have sheets updated automatically every minute instead of every hour
Another vote from the community:
Every minute (or less) would be a great.
Can an automatic update be done anytime a source sheet is edited?
"pulls" relevant data from the backup sheets in real time
How about a plan for instant updates?
Enable automated updates every minute :)
Offer a 5 min update cycle
Specifically, I have a need to have Sheetgo update the last Saturday of every month.
Is there any way the consolidation can be triggered more often than once an hour (without having to do it manually) ?
Also, random question: Is it possible to add multiple time triggers to a single spreadsheet so they can update weekly on Monday, Wednesday & Friday?
Instead of just "weekends", it should be flexible to set special holidays or working days at weekends. Like the google calendar can set any repeated events in a most flexible way.
I have a number of forms that all require a calendar update; our fiscal year, and when the quarters start and end are all the same for each of those forms. I'm setting up next year's forms and thought to have one sheet with the quarter breakdown, then run Sheetgo to update all the others. The calendar just needs updating once, just thought it would be nice to just set it and forget it; I just update the doc, and have Sheetgo take care of the rest.
I am in the process of automating my report. However I want Sheetgo to process only between 9am and 5pm on an hourly basis (9,10,11,12,1,2,3,4,5). 9*20 = 180 connections per month. Is this possible?
You won't be notified about changes to this idea.