Refresh rates for Spreadsheets widgets

Spreadsheet widgets powered by a Google Sheets spreadsheet automatically refresh within 3 minutes from the connected spreadsheet's last update.

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

If this isn't fast enough for your needs, you can set your own refresh interval by writing a script using Google Apps Script Editor.

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.