Set refresh rate for Spreadsheets widgets powered by import functions
Set your own refresh interval by writing a script using Google Apps Script… Give your Google Sheet a name.
To write the script, click on Tools > Script Editor… Writing the Apps Script