Unable to Schedule Refresh in Google Sheets
This article will address the following error:
Unable to schedule refresh in Google Sheets. Error shown is "Exception: Bad Value."
Cause
Google Sheets requires you to set a Time Zone. Additionally, you must be a member of the report's hub in order to schedule a refresh via the Sheets data connector sidebar.
Solution
Go to File > Settings. Choose the appropriate time zone and click Save Settings. Then schedule the refresh.
Related Articles
Google Sheets Error: "Exception: This add-on has created too many time-based triggers in this document for this Google user account"
Your Schedule Refresh won't save, and Google Sheets shows an error about too many time-based triggers. This is a Google limit on the spreadsheet, not a Power My Analytics limit, and you can usually clear it yourself in a couple of minutes. Here is ...Google Sheets Scheduled Refresh Not Running
You set up a scheduled refresh for a Power My Analytics report in Google Sheets, but the data does not update on its own. This guide helps you confirm the schedule is saved, re-authorize the add-on (the most common fix), read the add-on logs, and ...Configure Data Source Sync Time and Google Sheets Refresh for the Latest Data
Keeping your marketing data up-to-date is crucial for accurate reporting and analysis. This guide will walk you through configuring your data source sync time and Google Sheets scheduled refresh to ensure you're always working with the most recent ...Google Sheets Error: Query Inactivity Error
If you are receiving a Query Inactivity Error when using our Sheets add-on, the following steps may help to resolve the issue. This page will assist you with the following error in Google Sheets: Query Inactivity Error Solution First, duplicate the ...Error: Data Appears Blank in Cells in Google Sheets Report
If your Power My Analytics data appears blank in Google Sheets but becomes visible when you click on the cells, this is likely caused by incorrect column formatting. This article will help you identify and resolve this common formatting issue. Error ...