Unable to Schedule Refresh in Google Sheets

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.




    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • 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 ...

      • 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 ...

      • 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 ...

      • 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. ...