Home › Forums › Advanced usage › Error: too much computing time
This topic contains 3 replies, has 2 voices, and was last updated by mhawksey 2 years, 5 months ago.
-
AuthorPosts
-
August 28, 2018 at 9:58 pm #1254
Hello,
I have recently edited my TAGS sheets and set their triggers to 15 min instead of the original 60 min in order to try to approach the maximum Twitter API rate limit. It first seemed to run okay, I tested and compared results between two sheets.
However, now I’m getting emails reporting errors for many of my sheets (total: 35) containing the error message ‘the service requires too much computing time for one day’ (translated from German) by the function
getTweets
. They seem to keep on collecting tweets though.What is this about and what can I do?
Best,
Quirin-
This topic was modified 2 years, 6 months ago by
Quirin.
August 30, 2018 at 6:39 pm #1262Hi – sounds like you are hitting the quota Google provide for running scripts in Google Sheets https://developers.google.com/apps-script/guides/services/quotas#current_quotas If you are running via a Gmail account then G Suite accounts are more generous … or split the load across multiple accounts
September 7, 2018 at 10:44 am #1266Thanks for your answer! I’d like to stick with my single Gmail account for several reasons, so I guess I’ll have to switch back from 15 to 60 min intervals for the
getTweets
trigger. My only concern for that is that I’d get less than the maximum number of tweets that could be harvested for my queries, as the absolute frequency of tweets for those queries are crucial for my research project. Would I get a warning or error if I hit that ceiling?September 13, 2018 at 7:52 pm #1271No unfortunately I don’t think the script throws an error if reaches the collection limit and there are more tweets.
-
This topic was modified 2 years, 6 months ago by
-
AuthorPosts
You must be logged in to reply to this topic.