Keep an imported Google Sheet up to date
Sync now, or refresh every hour, day or week; charts keep working throughout.
For the complete AI-readable content index, see /llms.txt.
Datasets · 1 min read
An imported dataset’s page has a “Google Sheets source” card: the spreadsheet and worksheet (click to open it in Google Sheets), who it is read with, when it was last refreshed and when the next refresh is due.
Choose “Sync now” to re-read the spreadsheet. The current data stays in place until the new version lands, so charts and canvases keep working; a “Refreshing” badge shows progress.
Under Refresh, choose Every day or Every week to refresh on a schedule, or Manually to stop; Every hour is available on Enterprise. Intervals run from when you set them, so “Every day” means about every 24 hours.
Change the Range or Header row and choose “Save”; the change applies at the next refresh.
Related reading
Guides from Learn on the why and when behind this.
Still stuck?
Ask the docs assistant about “Keep an imported Google Sheet up to date” or anything else in DashboardGPT.