Google sheet not loading data - Reauthorize account
Initially when you authorize and sync your Gmail account with your Google Sheet schedule, Google will keep the synchronization active a certain period of time.
After that, Google will stop your Gmail account synchronization with your Google Sheet schedule, due to security reason.
Once your Gmail account synchronization is stopped, the schedule will not send the Google Sheet report to your Google Drive.
In order to continue to receive the Google Sheet report, you need to reauthorize your Gmail account and sync it with your schedule.
To reauthorize your gmail account, click the actual schedule tab, which can be found in the schedule page:
Once you click the actual schedule tab, the app will take you to the next page where you can edit your active schedule:
Now, click the "Edit" button, to edit your active schedule.
After clicking the "Edit" button, scroll down to the "How do you want the report to be delivered?" section and click Google Sheet:
Now, click the "Revoke Access" button to remove your Gmail account from the schedule.
After that, click the "Add Another Google Drive" button, and choose the same Gmail account to synchronize with your Google Sheet schedule.
Once it is done, the schedule will continue to send the Google Sheet report to your Google Drive.