# Google Sheets Scheduled Refresh Not Running or Failing

If your Google Sheets scheduled refresh keeps failing or never runs, this guide helps you tell which is happening and fix it. A refresh that runs but fails is often caused by report size or heavy formulas; a refresh that never runs is usually an authorization problem.

> **Note:** **Where you'll work:** most of these steps happen in Google Sheets, in the Power My Analytics add-on (**Extensions > Power My Analytics > Open sidebar**). A few happen in your Power My Analytics Hub (**Reports > Google Sheets** and **Sources**), and one in your Google Account settings. Each step says where.

## Symptom

- You configured a scheduled refresh in the Power My Analytics Sheets Data Connector add-on, but your report does not update automatically at the scheduled time.
- The refresh runs but keeps failing: you get an error-alert email, a report shows an error, or some reports update while others keep their old data.
- Or the refresh never runs: there is no error at all, and nothing updates until you refresh by hand.

## First, Check Whether the Refresh Runs or Never Runs

The fix depends on which of these you are seeing:

- **It runs but fails** if you get an error-alert email with the subject "Power My Analytics scheduled refresh error" (it lists each report that failed and its error), a report in the PMA sidebar shows an error icon (hover over it to read the error), the **Error** column of the **PMA Configuration** tab has a message, or some reports update while others do not. Start with **The Refresh Runs but Fails** below.
- **It never runs** if there is no error anywhere and no report updates on schedule. Cell Z1 of the **PMA Configuration** tab shows **Last refresh** with the date and time the last scheduled refresh finished; if that time does not change, start with **The Refresh Never Runs** below.

## The Refresh Runs but Fails: Check Report Size and Formulas

When a scheduled refresh starts but keeps failing, look at the size of the spreadsheet first. A scheduled refresh updates every report in the spreadsheet in a single run, and Google limits each run to 6 minutes. While the reports are written, Google Sheets recalculates the formulas that use their data, and the add-on has to wait for those calculations. Large reports and heavy formulas can push the run past Google's limits.

Check these first:

- **How many reports does the spreadsheet have, and how long are their date ranges?** A long, growing date range (such as this year to date) adds data every day, so a refresh that worked for months can start failing as the data grows.
- **Do formulas in the same spreadsheet use the report data?** Many SUMIFS or COUNTIFS formulas, or ARRAYFORMULA formulas over entire columns, are a common cause, because they recalculate every time the reports are written.
- **What does the error say?** "Exceeded maximum execution time," "Service Timed Out: Spreadsheets," "Request timed out," and "over 50MB of compressed data" all point to report size or formulas. A large refresh that times out can also show the general "Request failed! Please contact Power My Analytics for support."

If a run reaches the 6-minute limit, it stops partway: reports refreshed before the limit show new data, the rest keep their old data, and the error-alert email may not arrive.

To fix it, use one or more of these:

1. **Move your formulas to a separate spreadsheet.** Keep the PMA reports in one Google Sheets document with no formulas, and do your calculations in a second document that brings the data in with the IMPORTRANGE function. These must be two separate documents, not two tabs in the same document. [What to Do When a Report Is Loading Slowly](https://knowledge.powermyanalytics.com/application/troubleshooting/what-to-do-when-a-report-is-loading-slowly/#google-sheets) shows how.
2. **Split long date ranges into reports by period.** For example, replace one report that covers last year and this year with one report for each year. Past periods rarely change, so you can move those reports to a spreadsheet without a scheduled refresh and refresh them by hand when you need to.
3. **Spread your reports across spreadsheets.** Each spreadsheet has its own schedule and its own 6-minute run. For example, four spreadsheets with 25 reports each refresh more reliably than one spreadsheet with 100 reports.
4. **Make each report smaller.** Remove fields you don't use, and shorten date ranges where you can.
5. **Do the heavy calculations in BigQuery.** If you work with a lot of data, build the table in [Data Builder](https://knowledge.powermyanalytics.com/application/tools/data-builder-guide/), [export it to BigQuery](https://knowledge.powermyanalytics.com/application/exports/how-to-export-to-bigquery/), and do your aggregation there instead of in the sheet. Data exports are available as a paid add-on on the Business, Grow, and Pro plans, and are included with the Custom plan when your agreement includes data exports.

Re-authorizing the add-on does not fix these errors. For more on each message, see [Spreadsheets Error: Exceeded Maximum Execution Time](https://knowledge.powermyanalytics.com/application/troubleshooting/spreadsheets-error-exceeded-maximum-execution-time/), [Google Sheets Error: "Exception: Service Timed Out: Spreadsheets"](https://knowledge.powermyanalytics.com/application/troubleshooting/google-sheets-error-exception-service-timed-out-spreadsheets/), and [Apps Script Error: This Report is Over 50MB of Compressed Data](https://knowledge.powermyanalytics.com/application/troubleshooting/apps-script-error-this-report-is-over-50mb-of-compressed-data/). If the error asks you to reconnect a data source instead, see **Common Causes and Fixes** below.

## The Refresh Never Runs: Re-authorize the Add-on

If the scheduled refresh never runs and shows no error, the cause is usually a Google authorization issue. When the add-on's authorization goes stale, or a required permission is missing, the scheduled refresh can quietly stop running even though the schedule still looks like it is set. Re-authorizing resolves this in the majority of these cases.

In Google Sheets:

1. Open the spreadsheet that contains your PMA report.
2. Go to **Extensions > Power My Analytics > Sign out**.
3. Go to **Extensions > Power My Analytics > Open sidebar**, click **Sign in**, and finish signing in on the tab that opens, approving every permission that is requested.
4. Refresh the spreadsheet (press F5, or reload the browser tab).
5. Check that your schedule is still set (see Step 1), then allow the next scheduled run to occur.

> **Note:** A permission conflict is especially common if you connected a Google data source (Google Ads, Google Analytics 4, or Google Search Console) in your Hub *before* you installed the Google Sheets add-on. Signing out and back in re-requests the full set of permissions the add-on needs to run in the background.

If re-authorizing does not fix it, work through the steps below.

## Step 1: Verify the Scheduled Refresh Is Set Up

First, confirm the schedule actually exists and is saved for the right spreadsheet.

**In your Hub:**

1. Go to **Reports > Google Sheets**.
2. Find your spreadsheet in the list and check its **Scheduled Refresh** column, which shows the schedule and its time zone. If it is blank, no schedule is saved for that spreadsheet.

**In Google Sheets:**

1. Open the PMA sidebar: **Extensions > Power My Analytics > Open sidebar**.
2. Click **Refresh** at the bottom of the sidebar and select **Schedule refresh**.
3. Confirm the **Frequency** (monthly, weekly, daily, or hourly) and the **Time** are what you expect. One schedule refreshes all of the reports in the spreadsheet.
4. Click **Save**. (Choosing a frequency without clicking **Save** does not save the schedule.)

> **Note:** A scheduled refresh has a few requirements: your spreadsheet must have a time zone set (**File > Settings > General tab > Time Zone**); without it, scheduling fails with "Exception: Bad Value." You must be a member of the report's hub to schedule or run a refresh. Scheduled refresh is available for Google Sheets only (Microsoft Excel reports do not support it). Hourly refresh requires the Hourly Refreshes add-on, or a Custom plan agreement that includes it.

Schedule the refresh at least 2 hours after your data source's sync time (3 AM in the source's time zone by default), so the latest data is ready when the refresh runs; allow longer if the sync time falls between 3 AM and 7 AM Pacific Time. You can check and change the sync time in your Hub: go to **Sources**, open the data source's **Action** menu, and select **Edit sync time**. The schedule uses the individual spreadsheet's time zone, so set the spreadsheet's time zone to match your data source's sync time. If the two time zones differ, a daylight saving change can move the refresh an hour closer to the sync.

## Step 2: Check the Add-on's Google Permissions

The scheduled refresh runs in the background on Google Apps Script, so it needs the add-on's full permission set:

- See, edit, create, and delete all your Google Sheets spreadsheets.
- Connect to an external service.
- Send email as you.
- Allow this application to run when you are not present. (This is the key permission for scheduled, background runs.)
- Display and run third-party web content in prompts and sidebars inside Google applications.

If any of these were not granted, or were later revoked, the scheduled refresh cannot run while you are away. To restore them:

1. Sign out of the add-on and sign in again in Google Sheets (see **The Refresh Never Runs** above), approving every permission at the Google prompt.
2. If the problem continues, remove PMA's access and re-add it: in your Google Account, go to [https://myaccount.google.com/connections](https://myaccount.google.com/connections), select **Power My Analytics**, delete the connection(s), then return to Google Sheets, open **Extensions > Power My Analytics > Open sidebar**, and sign in again.

> **Important:** If you are on Google Workspace and the account keeps disconnecting with "Authorization Error - Access Token Expired," your Workspace admin may need to add PMA as a trusted app before scheduled refreshes will run reliably. See [Google Account Disconnects When Using Google Workspace](https://knowledge.powermyanalytics.com/application/troubleshooting/google-account-disconnects-when-using-google-workspace/).

## Step 3: Read the Logs to See What Happened

Turn on error alerts and use the activity log to see whether the scheduled refresh ran, and whether it errored.

### Enable error-alert emails (recommended)

In Google Sheets:

1. In the PMA sidebar, click **Refresh** and select **Schedule refresh**.
2. Turn on **Email an alert if a refresh fails**, then enter one or more addresses under **Send alerts to** (separate multiple addresses with commas). If you also email your reports, you can choose **Same as reports** instead.
3. Click **Save**. From now on, any failed scheduled run emails you the error, so you know exactly what to fix.

### View the activity log in your Hub

1. In your Hub, go to **Reports > Google Sheets**.
2. Open the three-dot menu for your spreadsheet and click **View logs**.
3. Review the entries (for example, "Updated refresh schedule") and the **Logged At** timestamps to confirm the schedule was saved and when activity last occurred.

The same menu has **Delete scheduled refresh**, which removes the spreadsheet's schedule if you need to clear it and set it up again.

### Check the PMA Configuration tab

- Open the **PMA Configuration** tab in your spreadsheet and look for messages in the **Error** column for the affected report. An error here points to the specific failure (for example, a timeout or a data-size limit; see **The Refresh Runs but Fails** above).

> **Note:** Because the scheduled refresh runs on Google's servers under the PMA add-on, the error-alert email and the **PMA Configuration** Error column are the most reliable ways to see why a background run failed. (The add-on's internal Apps Script execution history is not directly viewable from your spreadsheet, which is why enabling error-alert emails is so useful.)

## Common Causes and Fixes

| Cause | What you'll see | Fix |
| --- | --- | --- |
| Stale authorization or missing permission (most common when the refresh never runs) | Refresh never runs, with no error, or a permission error in the logs | In Google Sheets, sign out of the add-on and sign in again, approving all permissions. If needed, remove PMA at myaccount.google.com/connections and sign in again. |
| Report too large or too many formulas (often after months of working, as the data grows) | "Exceeded maximum execution time," "Service Timed Out," "Request timed out," or "over 50MB of compressed data"; or some reports update and others don't | Move formulas to a separate spreadsheet, split long date ranges into reports by period, spread reports across spreadsheets, reduce fields or date range, or do heavy calculations in BigQuery. See **The Refresh Runs but Fails** above. |
| A data source used by the report is disconnected | The error asks you to reconnect the data source, or says its access token expired | Reconnect the data source in your Hub (see [How to Reconnect a Disconnected Data Source](https://knowledge.powermyanalytics.com/application/troubleshooting/how-to-reconnect-a-disconnected-data-source/)), then refresh. |
| Spreadsheet time zone not set | "Exception: Bad Value" when saving the schedule | Set **File > Settings > Time Zone**, then save the schedule. See [Unable to Schedule Refresh in Google Sheets](https://knowledge.powermyanalytics.com/application/troubleshooting/error-bad-value-unable-to-schedule-refresh-in-google-sheets/). |
| Not a member of the report's hub | Cannot save or run the schedule | Ask your hub admin to add you, then set the schedule. |
| Google Workspace token expiring | Recurring "Access Token Expired" disconnects | Have your Workspace admin add PMA as a trusted app. See [Google Account Disconnects When Using Google Workspace](https://knowledge.powermyanalytics.com/application/troubleshooting/google-account-disconnects-when-using-google-workspace/). |
| Signed in to multiple Google accounts | "accounts.google.com refused the connection" or "Authorization is required to perform that action" | Sign out of all Google accounts except the PMA one, or use an incognito window with cookies enabled. |
| Too many scheduled refreshes in one spreadsheet | "This add-on has created too many time-based triggers in this document" | Make a copy of the spreadsheet (**File > Make a copy**) and use the copy. |
| Refresh scheduled too early, or a daylight saving change moved it | It runs, but shows the previous day's data | Schedule at least 2 hours after your data source's sync time (in your Hub: **Sources** > **Action** > **Edit sync time**); use the same time zone for the spreadsheet and the sync time, or add an hour to the buffer. |
| Google daily fetch quota exceeded | "Service invoked too many times for one day: premium urlfetch" | Wait 24 hours for the quota to reset; space out refreshes across your sheets. |

## Still Not Working?

If your scheduled refresh still does not run after these steps, [submit a ticket](https://knowledge.powermyanalytics.com/support/submit-a-ticket/) and include your report link, the refresh schedule you set, the spreadsheet time zone, and any error text from the alert email or the **PMA Configuration** Error column. That detail helps our support team pinpoint the cause quickly.

## Related Articles

- [Configure Data Source Sync Time and Google Sheets Refresh for the Latest Data](https://knowledge.powermyanalytics.com/application/reports/configure-data-source-sync-time-and-google-sheets-refresh-for-the-latest-data/)
- [Unable to Schedule Refresh in Google Sheets](https://knowledge.powermyanalytics.com/application/troubleshooting/error-bad-value-unable-to-schedule-refresh-in-google-sheets/)
- [Required Google Account Permissions for Spreadsheets Add-on](https://knowledge.powermyanalytics.com/application/reports/required-google-account-permissions-for-spreadsheets-add-on/)
- [Error: Authorization Is Required to Perform That Action](https://knowledge.powermyanalytics.com/application/troubleshooting/error-authorization-is-required-to-perform-that-action/)
- [Google Account Disconnects When Using Google Workspace](https://knowledge.powermyanalytics.com/application/troubleshooting/google-account-disconnects-when-using-google-workspace/)
- [What to Do When a Report Is Loading Slowly](https://knowledge.powermyanalytics.com/application/troubleshooting/what-to-do-when-a-report-is-loading-slowly/)
- [Spreadsheets Error: Exceeded Maximum Execution Time](https://knowledge.powermyanalytics.com/application/troubleshooting/spreadsheets-error-exceeded-maximum-execution-time/)
- [Google Sheets Error: "Exception: Service Timed Out: Spreadsheets"](https://knowledge.powermyanalytics.com/application/troubleshooting/google-sheets-error-exception-service-timed-out-spreadsheets/)
