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.
Solution
Go to File > Settings. Choose the appropriate time zone and click Save Settings. Then schedule the refresh.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Google Sheets Data Integration Guide
Integrate your marketing data into Google Sheets to build custom reports and dashboards. This guide will walk through how to install the Sheets add-on, create reports, edit reports, refresh data, and more. Install the Google Sheets Add-on To install ...Installing the Power My Analytics Add-on for Google Sheets
If you'd like to merge and manipulate data from popular sales and advertising platforms with Google Sheets to create insightful and automated reporting, follow the instructions below to install and launch the Power My Analytics Sheets Data Connector. ...Google Account Disconnects When Using Google Workspace
This article will assist you with the following errors: In Looker Studio: Please click "REFRESH AUTHENTICATION" and reauthenticate with Power My Analytics/Authorization Error - Access Token Expired, please disconnect and reconnect In Google Sheets: ...Missing Data in Google Sheets Report
This article will assist with the following issue: A Google Sheets report is missing data or does not show enough data for a date range. Cause Power My Analytics' Google Sheets connector defaults to a 1,000 row limit. Solution Check the sidebar under ...Spreadsheets Error: Exceeded Maximum Execution Time
This article will assist you with the following error: Exceeded maximum execution time Cause When using the spreadsheets add-on for Google Sheets or Excel, the add-on may time out with this error when you have a large number of reports in your ...