Have you created any new heavy queries lately? (thousands of cells of results), or do you have any huge Google Sheets files that have large amounts of data in them from Supermetrics queries?
At the moment there's an unfortunate issue with Google Sheets triggering which appears especially if the data amounts in single spreadsheet files are huge. We're terribly sorry for the inconvenience, but help is on the way as we are currently building a new triggering mechanism.
If you keep experiencing trigger failures for many days in a row, please send us a private ticket about it.