Issue Summary

Users have reported that scheduled updates to Google Sheets, which previously worked reliably, have suddenly stopped functioning. While manual refreshes are successful, scheduled updates do not run as expected. Investigation suggests this may be caused by the expiration of the Google account authentication token after prolonged use. In some cases, the issue was due to the Google Auth token having 'Insufficient Scope'. Re-authenticating via the schedule tab (by clicking 'Edit') resolves the issue.

Steps to Reproduce

This issue occurs only on affected customer instances.

Expected Results

Google Sheets should update according to the defined schedule. If authentication fails and re-authentication is required, users should be notified via the UI rather than experiencing silent failures.

Actual Results

No errors or logs are generated. Scheduled updates do not run, leaving users without guidance on how to resolve the issue.

Workaround

Re-authenticate from the Scheduled tab by clicking the 'Edit' button to resolve the problem.