Refresh rate for Spreadsheet widgets

Widgets refresh every 15 mins, except when powered by a Google Sheet where it's within 3 mins from the sheet's last update.

Updated over a week ago

Spreadsheet widgets powered by a Google Sheets spreadsheet automatically refresh within 3 minutes from the connected spreadsheet's last update. This doesn't include direct links to Google Sheets, which refresh every 15 minutes.

For .xlsx files uploaded to Google Drive, Dropbox, and OneDrive the refresh rate is around every 15 minutes.

Connection source

File type

Refreshes every (mins)

Google Drive

Google Sheets

Within 3

Google Drive

.xlsx

15

Dropbox

.xlsx

15

OneDrive

.xlsx

15

Refresh rate when using import formulas

Widgets powered by import functions, such as ImportRange and ImportData, automatically refresh around every 15 minutes. Be aware, though, that when data from multiple import functions with their own refresh intervals are used in the same connected spreadsheet, it can affect the accuracy of the data displayed.

Did this answer your question?