title: How should I edit this formula for my mileage tracker using google sheets?
body: <p>I created a sheet from a youtube video last year to calcuate business mileage and it worked great for awhile. However, as the data amount increased, I began receiving error code 'service invoked too many times in one day'. I understand that each row of data &quot;calls&quot; to the google server and there are limits in the script. I have an API key from the Google Cloud platform to put in the formula and now the error code is 'imported content is empty'. I really appreciate some help with this. There is a year of driving data and it's critical that I can calculate the data with ease. There are roughly 200 rows of trips per month.</p>
  <p>=importxml(&quot;https://maps.googleapis.com/maps/api/directions/xml?origin=&quot; &amp; C2 &amp; &quot;&amp;destination=&quot; &amp; D2 &amp; &quot;&amp;sensor=false&amp;alternatives=false&amp;key=<em><strong>YOUR_API_KEY</strong></em>&quot;,&quot;//leg/distance/value&quot;)</p>
  <p>Here is a similar question on the topic.
  <a href="https://stackoverflow.com/q/67624960/18023150">G Sheets mileage log formula?</a></p>
  <p>Thanks so much,
  Joe</p>