title: IMPORTXML - Resource at URL contents exceeded maximum size
body: <p>I have been using importxml to dynamically get data from a websource. I achieved this using multiple importxml formulas. The total no of rows is less than 200. But now I am getting the error &quot;Resource at URL contents exceeded maximum size.&quot;. This URL contents are not larger than 200 rows.</p>
  <p>Anybody have any tips. I may have to use google app script to replicate this. Does anyone have any helpful suggestions to achieve this? I am an amateur when it comes to google script.</p>
  <p>Sample Spreadsheet located here.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1bQqCpT-dn5ll09Rh07xC4Z3by1I3jkuk3qc3sA1iSBk/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1bQqCpT-dn5ll09Rh07xC4Z3by1I3jkuk3qc3sA1iSBk/edit?usp=sharing</a></p>
  <p>Basically. I am after all race details for today from the links in Col D of backend sheet.</p>
  <p>For each event, I want to extract the following xpaths</p>
  <pre><code>Box, Name, Form, Speed, Rating, Rated Odds - //tr[@class=&quot;our-price&quot;]. All separate columns
  Overall Win, Place % - //div[@class=&quot;runnerRight&quot;]/table[2]/tbody/tr[1]/td[3]
  TRACK/DIST WIN, PLACE% -//div[@class=&quot;runnerRight&quot;]/table[2]/tbody/tr[3]/td[3]
  BEST 1st Sec/Dist - //div[@class=&quot;runnerRight&quot;]/table[2]/tbody/tr[4]/td[2]
  BEST Time Trk/Dist - //div[@class=&quot;runnerRight&quot;]/table[2]/tbody/tr[5]/td[2]
  Box Wins - //table[@class=&quot;longFormStatsBox&quot;]/tbody/tr[2]
  Box Races - //table[@class=&quot;longFormStatsBox&quot;]/tbody/tr[3]
  </code></pre>