How often does my spreadsheet data refresh?

Visualizations on a Geckoboard dashboard that are built using the Spreadsheets data source, automatically refresh within 3 minutes from the last update of the spreadsheet that powers them. For example, if the spreadsheet connected to a Spreadsheets widget updates at 2:02 pm, the visualization will update by 2:05 pm. 

The exceptions to the above rule are visualizations powered by "import" formulas such as "IMPORTRANGE", "IMPORTDATA", etc. or by pivot tables. These visualizations automatically refresh every 15 minutes.

Tip

You can force the widget to update by reloading the spreadsheet. To do this, follow these steps:

  1. Hover your mouse pointer over the widget you want to edit.
  2. Click the more options icon in the top right corner.edit widget menu
  3. On the pop-up menu, Click Edit.
  4. On the edit widget screen's breadcrumbs menu, click the downward arrow beside the name of your widget.Edit widget breadcrumbs
  5. Click Reload Spreadsheet.
  6. Click Save once you're finished.
Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

We're ready to help, 24 hours a day, 5 days a week

Get support
  • Fernanda Customer Success Avatar

    Megan

    USA
  • Hariharan Customer Success Avatar

    Hariharan

    India
  • Fernanda Customer Success Avatar

    Yasmin

    Spain
  • Luis Customer Success Avatar

    Luis

    UK
  • Richard Customer Success Avatar

    Richard

    UK
  • Fernanda Customer Success Avatar

    Fernanda

    Brazil
  • Heather Customer Success Avatar

    Kirby

    USA
  • Heather Customer Success Avatar

    Heather

    USA