Background
If you notice an Error lozenge 
on a red Error lozenge on the Published Sheets screen, or notice that issue data changes in Jira are not reflected in your realtime update sheets, your Google Service Account may be hitting Google API quota limits. While the Google APIs used by this add-on have no daily usage limits, they do have default time-based read and write limits that can be exceeded by larger Jira instances with a higher number of users or published sheets. The default limits are 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user. Because this add-on's requests are all performed by a single user, the 100 requests per 100 seconds per user limit is more often the problem.
...