Google sheets importData, importRange speed / interval - ways to improve it?
<p>According to google documentation (<a href="https://support.google.com/docs/answer/58515?hl=en" rel="nofollow">https://support.google.com/docs/answer/58515?hl=en</a>) current refresh/recalculate times are as follows;</p>

<blockquote>
  <p>To change how often some Google Sheets functions update:</p>
  
  <p>Open a spreadsheet. Click File > Spreadsheet settings. Under
  "Recalculation," choose a setting from the drop-down menu. Click Save
  settings. Note: External data functions recalculate at the following
  intervals:</p>
  
  <p>ImportRange: 30 minutes ImportHtml, ImportFeed, ImportData, ImportXml:
  1 hour GoogleFinance: 2 minutes</p>
</blockquote>

<p>Is there any way in which we can speed this up? For example deleting the cell and then replacing it will force a refresh of the data. Maybe this could be done via a script for example. Can a script even be used on its own to pull in data from another sheet?</p>

<p>Does anyone have any ideas of how this could be done? Ideally I want a refresh of every 5 minutes.</p>

<p>Many thanks</p>