How should I edit this formula for my mileage tracker using google sheets?

Question

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 "calls" 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.

=importxml("https://maps.googleapis.com/maps/api/directions/xml?origin=" & C2 & "&destination=" & D2 & "&sensor=false&alternatives=false&key=YOUR_API_KEY","//leg/distance/value")

Here is a similar question on the topic. G Sheets mileage log formula?

Thanks so much, Joe

Answer 1

You can increase the daily quota. Instructions at https://cloud.google.com/docs/quota#viewing_your_quota_console.