4 ms·
How do you get around the number of fetch limitations?
by thrownaway954 7y ago
How do you get around the number of fetch limitations?
- paulgb 7y agoI'm hitting at a rate of 2/hour, it hasn't been an issue.
- thrownaway954 7y agohow are you accomplishing that? Does Google sheets have a scheduler built into it? Long running timer?
- paulgb 7y agoThe scheduled job runs on AWS, it just fetches the sheet when it runs.
- mneubrand 7y agoGoogle Apps Script has a scheduler built in: https://developers.google.com/apps-script/reference/script/clock-trigger-builder https://developers.google.com/apps-script/reference/script/c... I use this to automate a lot of tasks. E.g. automatically clip supermarket coupons every week, check for tax loss harvesting opportunities in my portfolio, etc. It's really powerful