You are reading a single comment by @user16171 and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@user16171
I am trying to calculate the distance between two postcodes in my google sheet, and return the results as driving distance and driving time.
I have found a script and copy/pasted it into script editor, and it runs nicely for the first time.
But it seems to be permanently calling to maps to refresh the data and then starts erroring stating that the service has been invoked too many times.
Can anyone help with drastically reducing the number of calls it makes, or caching and loading the page from cached cell data?
1 Attachment